[Top] [All Lists]

Re: Start Notification Instance Automatically

Subject: Re: Start Notification Instance Automatically
From: Joe Webb
Date: Tue, 25 Apr 2006 06:57:03 -0500
Newsgroups: microsoft.public.sqlserver.notificationsvcs
Hi Ramadu - 

I can't say that I've experienced this problem myself so I'm somewhat
shooting in the dark here.....

I can think of a couple of ways you may be able to address this. First
add a dependency to your SQLNS instance service to SQL Server. Mark
Williams tells how to do it here -
Again, I haven't had this happen to me so I don't know that Mark's
suggestions work. In other words TEST in a safe environment first! 

The other possibility would be to create a boot up script for the
machine. A simple VBScript, CMD or BAT file would work. Here's a link
to some service-related scripts.
HTH....and please post back your results. 

Joe Webb
SQL Server MVP

Get up to speed quickly with SQLNS 

I support PASS, the Professional Association for SQL Server.

On Thu, 20 Apr 2006 11:41:28 -0400, ramadu <[email protected]> wrote:

>I am using SQL Server 2000 Notification Services. The notification 
>instance that I created does not startup automatically when my machine 
>restarts. I read in some previous posts that due to dependencies on the 
>SQL Server, the instance might not start before SQL Server is running.
>My clients need to have the service started automatically when the 
>machine starts. Is there any workaround to make the notification service 
>start automatically?
>NOTE: I did change the startup type of the services from manual to 
>automatic (in vain).
>Also, when the service is created using nscontrol is there a way I can 
>set the service startup type to automatic so that it is set so when the 
>service is created?
>Thanks in advance!
>- ramadu

<Prev in Thread] Current Thread [Next in Thread>