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.

When I attempt add an existing domain user to the server role, sysadmin, I am not able to do so. I am logged in as the SysAdmin. I execute sp_addsrvrolemember (or do it through the gui). I get no errors. But that user is not added to the sysadmin group.

share|improve this question

3 Answers 3

Well, mystery solved. The system administrators on the box had installed some 3rd party software (McAfee Host Intrusion Prevention) and it was blocking the sp_addsrvrolemember call. no one told me this had been added. We built in a rule to allow the change. It now works.

share|improve this answer

Are you logged in as an admin in SQL or an admin in windows. Theya re not necessarily the same and by default (unless you specify otherwise during the install) local system admins are not sql admins. (AFAIK this was not a MIcrosoft design decision but a request from many DBA's in general, similarly sql server 2008 has group policies, but it's their own group policies)

share|improve this answer

On top of what Jim B said, you first also have to add the domain account as a user on the SQL instance. Under Security in the Object Browser, right-click Logins and do New User, or use TSQL:

CREATE LOGIN [domain\username] FROM WINDOWS

Just pointing that out in case you haven't done it yet :)

share|improve this answer

Your Answer

 
discard

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