Home > Solution Categories > Database > MS SQL Server > SQL Error:Cannot open database requested in login
Question
No of visitors who read this post: 501
Category: MS SQL Server
Type: Question
No votes yet

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.

[Microsoft][ODBC SQL Server Driver][SQL Server] Cannot open database requested in login ‘ACT7Demoa’. 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.

Comment viewing options

Select your preferred way to display the comments and click "Save settings" to activate your changes.

#

Submitted by Nick88 on Mon, 2011-07-11 10:35. Comment Id: 17528

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.
Previous Previous Page
280 of 302
Next Page Next