Changing the SSNS windows service to "start automatically" -- sql server notification services

sql server notification services : Changing the SSNS windows service to "start automatically"

Mwob
4/20/2007 7:23:09 AM

Hi,

When we deploy our SSNS instance, the SSNS windows service that gets
created has a startup type of "manual" by default. We'd like to change
that to "automatic" so that it always starts up when the PC is
rebooted. Is there an option to control that?

Also, when we change the type to "automatic" ourselves, and then
reboot the pc, the windows service always fails to start. Theres no
error logs in the event log, and when we look at the service its still
set to "automatic", but its status is "stopped". We can start it by
hitting start and its OK then.

Can someone help?

Thanks!

Joe Webb
4/23/2007 6:30:14 AM

[quoted text, click to view]

Hi Mwob -

I'm not aware of a setting in SSNS that will allow you to configure it to
start automatically. I usually just set it to automatic in the Windows
Services interface as you indicated that you do.

As for the error, it's likely because the SSNS service is trying to start
before the SQL Server service is started. Try creating a dependency for
the SSNS service on the SQL Server service.

HTH....

Joe

--
Joe Webb
SQL Server MVP
http://www.sqlns.com

travislspencer NO[at]SPAM gmail.com
4/24/2007 10:31:50 PM

[quoted text, click to view]

Hey,

[quoted text, click to view]

sc NS$instanceName config start= auto

--

Regards,

Travis Spencer

Got something to say? Click here to post a reply to this thread.

Don't see what you're looking for? Try a search.

View other messages about sql server notification services

home · blog · groups

Questions? Comments? Contact the dn