Welcome to MSDN Blogs Sign in | Join | Help

SYSK 357: SQL Server Login Problem on Fresh Installation in Vista

I just installed SQL Server 2008 CTP (Katmai) and all the patches on my Vista laptop…  However, trying to login using SQL Management Studio or osql using integrated security (and, yes, I’m an admin on my box) results in the “login failed” error.

To resolve the problem, I had to turn off the “User Control Account” and reboot.  Now, I can login to SQL without any problems… 

If you do want to enable User Control Account feature in Vista, simply add your Windows login to SQL Logins…

Published Sunday, August 05, 2007 9:41 AM by irenak
Filed under:

Comment Notification

If you would like to receive an email when updates are made to this post, please register here

Subscribe to this post's comments using RSS

Comments

# SYSK 357: SQL Server Login Problem on Fresh Installation in Vista

Sunday, August 05, 2007 1:31 PM by Noticias externas

I just installed SQL Server 2008 Beta 2 (Katmai) and all the patches on my Vista laptop… However, trying

# re: SYSK 357: SQL Server Login Problem on Fresh Installation in Vista

Sunday, August 05, 2007 3:20 PM by Matthew Adans

Or you can run SQL Management Studio or the osql command prompt as Administrator, using the right-click option "Run as administrator".  Then, at least, only that app is running elevated, rather than your entire system.

Leave a Comment

(required) 
required 
(required) 

  
Enter Code Here: Required
 
Page view tracker