RE: SQL Service manager

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: AnthonyThomas (AnthonyThomas_at_discussions.microsoft.com)
Date: 01/06/05 

Date: Thu, 6 Jan 2005 13:59:05 -0800

Yes, either do not allow that client tool to be installed on end-users
workstations and/or do not let those users be local administrators on your
production server. If they are not local admins, they will not be able to
shut down services.

Sincerely,

Anthony Thomas

"Tom Reis" wrote:

> After the installation of a MSDE server we noticed that the server manager
> on the MSDE server was able to stop the sql services on our production SQL
> 2000 Server. Is there a parameter or setting for our SQL 2000 Server to
> prevent this from occuring. Thanks.
>
>
>