SQL Error:Cannot open database requested in login

Asked By thomasredmall 750 points N/A Posted on - 06/26/2011

Hi,

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.

 

Thanks folks.

• Status: Open
• Question Views: 1518
• Answer Count: 1
• Vote Up 0 Vote Down

• Answer Accepted: No
• Question Category: MS SQL Server

Answered By Nick88 0 points N/A #122689

SQL Error:Cannot open database requested in login

Hello there,

I suppose this kind of error predominantly happens due to password mismatch. So first of all you must try to login with the same username and password with the SQL client.

 

If the problem still exists you can try using IP address and Machine name. If machines connect we can assume that the network is ok. So then we must check the SQL Server for connection via Windows Authentication or the SQL Authentication modes.

 

If you can open the Query Analyzer, select the server name, select SQL Authentication mode and find the code for connection string. Copy and Paste the user id, password from the connection string to your form and execute.

 

(This requires administrative rights).

 

I think one of these will help.

About Nick88

Questions
0

Answers
5

Best Answers
2

• Vote Up 0 Vote Down

• Posted on - 07/11/2011
• Question Category: MS SQL Server