I am running windows 7 professional and have used MS SQL server management studio many times without any incidents by running it using an Admin user name. In my current installation, another windows user can open up MSSQL server management studio, but cannot open/create any databases. I tried giving that windows user all the administrator access, but it hasn't helped.
migrated from stackoverflow.com Aug 26 '11 at 14:25
This question came from our site for professional and enthusiast programmers.
While logged in as the user that you think should have permissions, execute the following:
In the result set, if none of the rows have 'admin' in the privilege column, then the user doesn't have administrative rights. You can fix this by executing: