Thursday, November 01, 2007

SQL EXPRESS on VISTA

If you have installed an SQL express on vista and try to explore the SQL server with Management studio it doesn't open up, does it?

Why ?
During installation login accounts are created and by default the account from which the installation is performed is a part of the 'BUILTIN\Administrators' group. While in Vista coz of the UAC changes it gets added only to the 'BUILTIN\Users' groups, which essentially gives you a narrow scope of control that barely allows one to just connect to the server period curbing one to perform the basic admin acts like creation of a db.

What to do ?
Open Management Studio in Administrator mode.
Create a new login for the desired user with admin rights

Hope MS folks fix this at least in the next SP.