Re: SQL Service security

From: Jeff A. Stucker (jeff_at_mobilize.net)
Date: 11/10/05 

Date: Thu, 10 Nov 2005 15:46:54 -0700

This is for Win2003, but Win2k should be similar:

http://support.microsoft.com/default.aspx?scid=kb;en-us;325349 

-- 
Cheers,
'('     Jeff A. Stucker
\
Senior Consultant
www.rapidigm.com
"Lisa" <Lisa@discussions.microsoft.com> wrote in message 
news:3C439C97-5B4A-4395-95EC-A1A457128576@microsoft.com...
> How can I prevent the SQL Service from being stopped by certain users or
> computers?
>
> Here's the scenario:  A computer with SQL Server Service Manager can 
> connect
> to ANY of the SQL servers on our network and stop/pause the SQL Service.
> When I tested this theory out, it was logged in as admin to the box 
> (running
> 2000 professional workstation).
>
> If the SQL service needs to be stopped, it should be restricted to those 
> in
> the domain admin group or local admin to the server.   Any ideas on how I 
> can
> secure this?  Thanks!

Relevant Pages

  • Re: DB backup to UNC path failing
    ... it is a better to use Enterprise Mangler to change SQL Service ... > Microsoft SQL Server MVP ... >> No password change but I did notice that the account had modified. ...
    (microsoft.public.sqlserver.clustering)
  • Re: cannot generate sspi context when server in mixed authenticati
    ... Kevin Hill ... Real-world stuff I run across with SQL Server: ... after we switched it to mixed authentication mode. ... find a valid SPN for the SQL Service on the server then it should ...
    (microsoft.public.sqlserver.connect)
  • Problem configuring SQL Server 2000
    ... I had a problem before the setup intallation of SQL Server 2000 into a XP machine was successful. ... I can´t start the SQL service, it raises an error related to the sesion init. ...
    (microsoft.public.sqlserver.server)
  • Re: SQL windows account
    ... it is better to have it as "POWER USER" built in group. ... >SQL Service account absoloutely does NOT have ... The rights required by the SQL Service ... >Jasper Smith (SQL Server MVP) ...
    (microsoft.public.sqlserver.security)
  • Re: OK then - the outcome
    ... In the end I didn't even restore master I just stopped sql Server ... service renamed the SQLB Data folder to xData and copied in the SQLA ... Restart SQL Service ...
    (microsoft.public.sqlserver.clustering)