SQL Error:Cannot open database requested in login
Asked By 750 points N/A Posted on - 06/26/2011
We are implementing some new technology in our workplace, one of them is migrating our application to a new server. When I was done transferring all the data to a new server, I tested the application and I got an error that said, I cannot connect to the SQL server for the reason of login fails.
ACTPR – ODBC/SQL error
[Microsoft][ODBC SQL Server Driver][SQL Server] Cannot open database requested in login ‘ACT7Demoa’. Login fails.
As I saw this error message, my first doubt is I might had mistakenly typed my username and password. So I retyped it again. But when the same error message appeared, I consulted the database administrator to check on my rights. Upon checking, all rights were there. I am now wondering, what might be the problem.
Please help me with this error message.