INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Jobs

Microsoft SQL Server: Setup and Administration FAQ

General Information

Stopping other Services from starting until SQL Server is running by mrdenny
Posted: 5 Nov 04

There are some times that you just need that 3rd party service to not start until after the SQL Server is up and running.

I would recommend setting the service dependency for the 3rd party service so that it depends on the SQL Server.  This way it will not start until the SQL Service has started.

This is a registry tweak and probably isn't supported by anyone, but "should" work.

Open regedt32 (You have to use this, regedit won't work).
Navigate to HKLM\system\CurrentControlSet\Services\{Name of the 3rd Party Service}

The name of the 3rd party service will be the Service Name not the Display Name.  You can find the Service Name by looking at the properties of the Service in the Services Control Panel.

If there is a DependOnService key edit it and add "MSSQLSERVER", if not create it as a REG_MULTI_SZ and put "MSSQLSERVER" in the box.  With out the quotes in both cases.

Click OK, and close RegEdt32.

You can verify that this worked by checking in the services control panel.
The next time that you reboot the server your 3rd party service will not start until after the MSSQLSERVER service has started.
You can also verify this by stopping the MSSQLSERVER service and it will tell you that it will also stop the SQLSERVERAGENT (if running) and your 3rd party service.

You can use this method to make any service depend on any other service.  Be ware of loops.  If ServiceA depends on ServiceB and ServiceB depends on ServiceC and ServiceC depends on ServiceA none of the services will be able to start.



Back to Microsoft SQL Server: Setup and Administration FAQ Index
Back to Microsoft SQL Server: Setup and Administration Forum

My Archive

Resources

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close