Stopping SQL Server from Enterprise Manager...

[qwert69]

Can anyone please help me with the following....

We have numerous SQL Servers (v 7.0) on our site and it seems that from the Enterprise Manager console, it is possible to stop and start the SQL server even if the user is not a member of sysadmins - infact, even if the user is a member of nothing and has no local or domain administration rights! If the user tries to use the SHUTDOWN command in Query Analyser they are denied - which is what i would have expected from the Enterprise Manager console.

Surely this cant be the norm.... Anyone know why?

 

[EBee]

any user that goes to the terminal/server with the SQL server, he/she can stop and start services. This is only if the the system allows the user to login login to that server and knows how to do it.

-erwin