20
I have an RMS database that allows me to connect to the DB in administrator 'connect' however if I test the db connection I get error 2147467259 Cannot open database requested in login'dtabasename 'Login fails.
Store manager, POS and queries will not run.Any ideas?
*This post is locked for comments
Classic [tag:justsayin].
That is incorrect, if the BC is missing you do not get a (-2147217843) error. You get an error that says you must use management studio to connect to this database. Jeff is correct it is password/user login/permissions not a BC.
Mabuhay! Is there any backward compatibility installed on your PC?
based on our experience we cant use the studio when there is no backward compatibility installed.
SQLServer2005_BC
Thanks, this do it... it also work for the Error [-2147217843] login failed for user
Ahmed,
If you right click on my name in the header, it offers an option to email me with your questions.
Jeff, can u email me at ahmed.nashat@gmail.com?
If this is SQL2k8 or higher, you need to enable and change the order of the protocols.
Start | Microsoft SQL Server 2k8 | Configuration Tools | on the right, right click and stop the SQL Service | on the left. SQl Protocols | on the right Enable both the TCP/IP and Named Pipes | on the left, SQL client | on the right, right click on TCP/IP | select Order | click the down arrow on the far right so that Named Pipes is on top | lastly, restart the SQL Server Service, right click on it and Start
The login u r using doesn't have permission to access ur RMS database, so try a different login and open sql management studio to check users' permissions
#1
André Arnaud de Cal...
291,431
Super User 2024 Season 2
#2
Martin Dráb
230,503
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (
