09.15.07

sql server 2008 and vista

Posted in 经验心得 at 5:04 am by Ike

I 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 …