sql server 2008 and vista
Saturday, September 15th, 2007I just installed SQL Server 2008 CTP on Vista … However, trying to login SQL Management Studio using windows integrated security results in the “login failed 18456″ error.
And after investigation, I found that I had to turn off the “User Control Account” …
If you do want to enable UCA, simply add your Windows login to SQL logins … Or you can run SQL Management Studio as Administrator …