Some question about FixServerRoleMember

Hello Everyone


i am sorry to send this mail again, i need a hand, thanks everyone



i meet a stranger problem when i use sqlserver fix ServerRoleMember.


For example:

first i login sqlserver as SA,and add a new login

EXEC sp_addlogin 'NewLogin'

then i add this new login into FixServerRoleMember securityadmin

EXEC sp_addsrvrolemember 'NewLogin', 'securityadmin'



Commonly the "NewLogin" will have permission to execute sp_addlogin

but in my customer's server(windows 2000 server and sqlserver 2000
enterprise),the answer is false, i don't know why, i never meet this problem
before.


When Newlogin exec sp_addlogin 'someone' , sqlserver will answer: you
have no permission to execute sp_addlogin



This is the Error Message From sqlserver

Server:Msg 229 Level 14,State 5 Procedure sp_addlogin Line 126
Execute Permission denied on object 'sp_addlogin' Database
'master',owner 'dbo'



does anyone know what can cause this problem , thank you all the time .




--
Best Regards
Chris

It looks like your customer removed the public execute permissions on this
proc. This will prevent securityadmin role members from executing the proc.

--
Hope this helps.

Dan Guzman
SQL Server MVP

"HoneyChris" wrote in message

> Hello Everyone
>
>
> i am sorry to send this mail again, i need a hand, thanks everyone
>
>
>
> i meet a stranger problem when i use sqlserver fix ServerRoleMember.
>
>
> For example:
>
> first i login sqlserver as SA,and add a new login
>
> EXEC sp_addlogin 'NewLogin'
>
> then i add this new login into FixServerRoleMember securityadmin
>
> EXEC sp_addsrvrolemember 'NewLogin', 'securityadmin'
>
>
>
> Commonly the "NewLogin" will have permission to execute sp_addlogin
>
> but in my customer's server(windows 2000 server and sqlserver 2000
> enterprise),the answer is false, i don't know why, i never meet this
> problem
> before.
>
>
> When Newlogin exec sp_addlogin 'someone' , sqlserver will answer: you
> have no permission to execute sp_addlogin
>
>
>
> This is the Error Message From sqlserver
>
> Server:Msg 229 Level 14,State 5 Procedure sp_addlogin Line 126
> Execute Permission denied on object 'sp_addlogin' Database
> 'master',owner 'dbo'
>
>
>
> does anyone know what can cause this problem , thank you all the time .
>
>
>
>
> --
> Best Regards
> Chris
>
>
>
>
>
>
>
>
>
>
>