August 24, 2007 at 3:41 pm
I have a new installation of SQL Server 2005 running on Windows Vista Home Premium Version 6.0.6000. I have never been able to login to the server using SQL Server Management Studio using SQL Server Authentication. I can get on using Windows authentication. (Actually, I have an application which cannot connect to the server and it gives the same error message)
I get error 18452 - Login failed for user sa. User is not associated with a trusted SQL Server connection.
I have:
Installed SP2
Enabled mixed mode login
Granted each user permission to login and to connect to the database engine
Run the configuration manager and turned on every kind of connection - there are 4 kinds
Run the surface area manager and added new administrator, turning on local and remote connections using TCP/IP and named pipes. Every time I do this, it shows me that I need to add administrator again.
I have searched every blog/thread I can find and I can't seem to get the issue resolved. Can someone help me?
August 24, 2007 at 4:51 pm
Duh! Of course SQL Server doesn't apply settings on the fly (it's a Microsoft product). Shutting down the server and restarting fixed the problem.
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply