Hi folks,

I'm new to SQL Server 2000, obviously, and I need help with the
following task:

I have a server with 2 instances running. I need to stop all access to
one of these instances until further notice.

I have tried stopping the service, but I notice that it keeps
restarting. I tested the problem and was able to do it myself, as
well, meaning ... I can stop the service on the server, but I can then
go into Enterprise Manager on my workstation and start the service,
which somebody else is also obviously doing.

How can I truly STOP the SQL Server Service for this instance?

Thanks in advance.

You could try disabling the service. Double-click the service in the
control manager & set it's startup type to 'Disabled'. This should
prevent anyone starting it.

You could try disabling the service. Double-click the service in the
control manager & set it's startup type to 'Disabled'. This should
prevent anyone starting it.

Stuart,

Worked like a charm. Thanks for the great help and the lightning fast
response.

Chris

[quoted text, click to view]