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.
Thursday, November 01, 2007
Subscribe to:
Posts (Atom)