Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Restart SQL Server services Expand / Collapse
Author
Message
Posted Thursday, May 6, 2010 4:29 AM
Right there with Babe

Right there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with Babe

Group: General Forum Members
Last Login: Yesterday @ 2:26 PM
Points: 752, Visits: 1,071
Hi,

If a user do not have acces to SQL Server databases can i still shutdown SQL Server or restart the services of SQL Server? or only a user with valid permissions inside SQL Server can restart SQL Server services and shut it down?
Post #916787
Posted Thursday, May 6, 2010 4:45 AM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Yesterday @ 6:48 AM
Points: 2,633, Visits: 3,977
Post #916798
Posted Thursday, May 6, 2010 4:46 AM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Tuesday, March 11, 2014 5:33 AM
Points: 307, Visits: 1,846
A local or domain Windows Administrator can shutdown/restart the server including restarting SQL services.

But perhaps I haven't fully understood your question...
Post #916799
Posted Thursday, May 6, 2010 4:51 AM
Right there with Babe

Right there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with Babe

Group: General Forum Members
Last Login: Yesterday @ 2:26 PM
Points: 752, Visits: 1,071
suppose that i remove the domain admins group from SQL Server 2005 security tab. This means that no administartors have access to SQL Server databases and other SQL Server 2005 resources. But can they still shutdown SQL Server or restart it's services?
Post #916802
Posted Thursday, May 6, 2010 5:34 AM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Tuesday, March 11, 2014 5:33 AM
Points: 307, Visits: 1,846
river1 (5/6/2010)
suppose that i remove the domain admins group from SQL Server 2005 security tab.?

Still don't understand what you mean... are you referring to BUIILTIN\Administrators? Do you mean removing them as a SQL login? or removing them from the local Administrators group of the Windows server concerned?

This means that no administartors have access to SQL Server databases and other SQL Server 2005 resources. But can they still shutdown SQL Server or restart it's services?

Windows Administrator's will always be able to Start/shutdown or restart/shutdown a given Windows server.

Post #916826
Posted Thursday, May 6, 2010 6:26 AM
Right there with Babe

Right there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with Babe

Group: General Forum Members
Last Login: Yesterday @ 2:26 PM
Points: 752, Visits: 1,071
If i remove the Builtin\Administrators login from SQL Server will they still be able to shutdown or restart the services?
Post #916864
Posted Thursday, May 6, 2010 6:38 AM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Tuesday, March 11, 2014 5:33 AM
Points: 307, Visits: 1,846
YES, via services.msc!
Post #916878
Posted Thursday, May 6, 2010 7:01 AM
Right there with Babe

Right there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with Babe

Group: General Forum Members
Last Login: Yesterday @ 2:26 PM
Points: 752, Visits: 1,071
what about by SQl Server 2005 configuration manager?
Post #916906
Posted Thursday, May 6, 2010 7:16 AM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Tuesday, March 11, 2014 5:33 AM
Points: 307, Visits: 1,846
Yes, they will be able to stop/start services via SSCM as well!!!
Post #916925
Posted Yesterday @ 11:51 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Yesterday @ 1:45 PM
Points: 2, Visits: 21
How can I find out WHO did the restarting of such service?

I fully understand that anyone with logonlocally privledges can get to and use these restarts but how do I see which specific AD account did it? My logs always show User to be "N/A".
Post #1628198
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse