0

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.

1
  • Have you seen any errors or messages? Did you create Login for this user on the server? Security->Right Click on Logins->New Login. And then create User for that Login in the Database.
    – Igor
    Aug 26, 2011 at 2:20

1 Answer 1

0

While logged in as the user that you think should have permissions, execute the following:

DECLARE @a sysname = SUSER_SNAME()
EXEC xp_logininfo @acctname = @a, @option = 'all'

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:

exec sp_addsrvrolemember @loginame = 'your login here', @rolename = 'sysadmin'

You must log in to answer this question.