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?
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
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
-- Regards,
Jeff HobbsCheck Point Software
Jeff, can u email me at ahmed.nashat@gmail.com?
Ahmed,
If you right click on my name in the header, it offers an option to email me with your questions.