Monday, December 10, 2007

Enabling 'sa' in SQL Server 2005 Server express on Vista

This is the 2nd time I had to do it - should had posted it the first time. For security reasons, user 'sa' doesn't come enabled by default. You'll have to go to Management Studio, on Security > Logins > sa > Status and enable the login. Please don't forget to run Management Studio as administrator.

No comments:

Post a Comment