Starting the SQL Service through Enterprise Manager

Collapse
This topic is closed.
X
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • ceadtinneh
    #1

    Starting the SQL Service through Enterprise Manager

    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

    Tags: None
    • Jeffrey Sheldon via SQLMonster.com
      #2
      Re: Starting the SQL Service through Enterprise Manager

      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

        Comment

        • Simon Hayes
          #3
          Re: Starting the SQL Service through Enterprise Manager


          "ceadtinneh " <sulla33@yahoo. com> wrote in message
          news:1104939297 .651503.50720@z 14g2000cwz.goog legroups.com...[color=blue]
          > 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
          >[/color]

          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 "Automatica lly 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


            Comment

            Previous template Next
            Working...