|
Home > Archive > MS SQL Server security > November 2005 > SQL Service security
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
SQL Service security
|
|
|
| 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!
| |
| Jeff A. Stucker 2005-11-10, 8:23 pm |
| This is for Win2003, but Win2k should be similar:
http://support.microsoft.com/defaul...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@microso
ft.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!
| |
| Andy Davis 2005-11-18, 3:23 am |
| Hi,
i would suggest to read :
http://vyaskn.tripod.com/ sql_serve...ices
.htm
http://vyaskn.tripod.com/ sql_serve...t_practices.htm
HTH
Regard
--
Andy Davis
Active Crypt Team
--------------------------------------------SQL Server Encryption
Decryption Software
http://www.activecrypt.com
"Lisa" wrote:
> 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!
|
|
|
|
|