Starting the SQL Service through Enterprise Manager

[ceadtinneh]

Folks,

We're implementing a software based mirroring solution. This solution
requires that the SQL Server service on the target server be stopped
while data is being replicated from the source server.

One problem we encountered while testing was that the SQL Server
Service on the target server was inadvertantly started when users
selected that server in Enterprise Manager. Is there any way to keep
the service from starting through Enterprise Manager?

Thanks

[Jeffrey Sheldon via SQLMonster.com]

I would suggest to go into Services on that server and change the SQL Server service from Automatic to Manual. This then needs human intervention to turn on the Service.

Jeff

--
Message posted via http://www.sqlmonster.com

[Simon Hayes]

"ceadtinneh" <su*****@yahoo.com> wrote in message
news:11*********************@z14g2000cwz.googlegro ups.com...

Folks,

We're implementing a software based mirroring solution. This solution
requires that the SQL Server service on the target server be stopped
while data is being replicated from the source server.

One problem we encountered while testing was that the SQL Server
Service on the target server was inadvertantly started when users
selected that server in Enterprise Manager. Is there any way to keep
the service from starting through Enterprise Manager?

Thanks

Sure - don't give users permissions to start services on the server, only
sysadmins and DBAs should be able to do that. Starting the MSSQL service (or
any other service) requires operating-system permissions, not MSSQL ones, so
you need to look at it from that angle.

You can also uncheck the "Automatically start SQL Server when connecting"
box in the EM registration properties, but that isn't really addressing the
issue, and won't stop an impatient user starting the service manually.

Simon