Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

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.

share|improve this question

migrated from stackoverflow.com Aug 26 '11 at 14:25

This question came from our site for professional and enthusiast programmers.

    
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 '11 at 2:20

1 Answer 1

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'
share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.