February 19, 2012 at 6:47 am
For the past week and a bit we have not been able to connect (through SSMS) to an SQL instance running on one of our servers from within the remote desktop. Each time we recieve an error message along the lines of 'Cannot connect to... Login failed for user ....'.
From my computer I can connect to the database engine and from the remopte desktop I can connect to other services (SSIS, SSAS) on the same machine, just not to the SQL server.
We've tried playing around with the settings to no avail.
Any ideas?
February 19, 2012 at 8:03 am
This is a good resource for investigating 18456 errors
http://sql-articles.com/articles/troubleshooting/troubleshooting-login-failed-error-18456/
February 19, 2012 at 8:22 am
Solved the problem (with the help of the above-mentioned link).
Turned out to be a problem with windows UAC 🙁
This is how I solved it in then end: http://www.sqldbops.com/2010/05/token-based-server-access-validation.html
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply