System Admin rights for ext'd stored proc 1

[swhitten]

We have a custom program that is calling the extended stored procedure xp_cmdshell. The only way we've been able to get it to successfully run is by giving the user the System Administrator server role.

We tried setting the user up to have the DBO role on the master database and giving the user exec rights to xp_cmdshell, but that still did not allow it to run.

We don't want to assign the System Administrator role to every user who has to run this program. What alternatives do we have?

Thanks in advance for your help.

Sherry

 

[Corran007]

If you choose to use a Windows NT account that is not a member of the local administrator's group for the MSSQLServer service, users who are not members of the sysadmin fixed server role cannot execute xp_cmdshell.

is your account a member of the local admin group?