Restart SQL Server services

Question

Post reply

Restart SQL Server services

river1

SSC-Insane

Points: 24300
More actions
May 6, 2010 at 4:29 am

#138911

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?

Viewing 10 posts - 1 through 9 (of 9 total)

You must be logged in to reply to this topic. Login to reply

VastSQL SSC-Dedicated Points: 36067 More actions · Answer 1

VastSQL

SSC-Dedicated

Points: 36067

May 6, 2010 at 4:45 am

#1163061

🙂

Shabba SSCertifiable Points: 5007 More actions · Answer 2

A local or domain Windows Administrator can shutdown/restart the server including restarting SQL services.

But perhaps I haven't fully understood your question...

river1 SSC-Insane Points: 24300 More actions · Answer 3

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?

Shabba SSCertifiable Points: 5007 More actions · Answer 4

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.

river1 SSC-Insane Points: 24300 More actions · Answer 5

If i remove the Builtin\Administrators login from SQL Server will they still be able to shutdown or restart the services?

Shabba SSCertifiable Points: 5007 More actions · Answer 6

Shabba

SSCertifiable

Points: 5007

May 6, 2010 at 6:38 am

#1163129

YES, via services.msc!

river1 SSC-Insane Points: 24300 More actions · Answer 7

what about by SQl Server 2005 configuration manager?

Shabba SSCertifiable Points: 5007 More actions · Answer 8

Yes, they will be able to stop/start services via SSCM as well!!!

yzerman19wingnut Valued Member Points: 68 More actions · Answer 9

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".