Welcome to dbForumz.com!
FAQFAQ    SearchSearch      ProfileProfile    Private MessagesPrivate Messages   Log inLog in

Rogue NS instance

  
   Database Forums (Home) -> Notification Services RSS
Next:  ODBC Data Source Administrator  
Author Message
Maria

External


Since: Jun 29, 2007
Posts: 2



(Msg. 1) Posted: Fri Jun 29, 2007 2:57 am
Post subject: Rogue NS instance
Archived from groups: microsoft>public>sqlserver>notificationsvcs (more info?)
Hi folks,

I created a new Notifiction Service, and stopped it halfway through
creation as I realised I hadn't saved an ADF file. Now the NS
databases appear to have been partially created, and I can't delete
the instance because it doesn't appear in the list in Server Explorer.
I tried to delete it with nscontrol, but it claims the instance does
not exist. However if I try to create a new instance, it fails because
the instance already exists! If I choose List Versions from the
Notification Services right-click menu, my instance is in there.

Any clues? I've only been developing NS for a couple of days, am I
missing something obvious? I'm more curious than anything really, it's
easy enough for me to change the instance name!

Thanks
Maria

 >> Stay informed about: Rogue NS instance 
Back to top
Login to vote
Joe Webb1

External


Since: Apr 28, 2004
Posts: 408



(Msg. 2) Posted: Fri Jun 29, 2007 6:13 am
Post subject: Re: Rogue NS instance [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
On Fri, 29 Jun 2007 02:57:44 -0700, Maria wrote:

> Hi folks,
>
> I created a new Notifiction Service, and stopped it halfway through
> creation as I realised I hadn't saved an ADF file. Now the NS
> databases appear to have been partially created, and I can't delete
> the instance because it doesn't appear in the list in Server Explorer.
> I tried to delete it with nscontrol, but it claims the instance does
> not exist. However if I try to create a new instance, it fails because
> the instance already exists! If I choose List Versions from the
> Notification Services right-click menu, my instance is in there.
>
> Any clues? I've only been developing NS for a couple of days, am I
> missing something obvious? I'm more curious than anything really, it's
> easy enough for me to change the instance name!
>
> Thanks
> Maria


Hi Maria -

In SQL Server 2005, SSNS instances are tracked in the msdb database. Try
deleting the instance row in msdb.NS90.NSInstanceInfo and the application
row in msdb.NS90.NSApplicationInfo tables. Afterward you should be able to
create your instance again.

There's a bit more information about this on my blog.

http://sqlns.blogspot.com/2007/04/finding-ssns-instances-using-t-sql.html



HTH...

Joe


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

 >> Stay informed about: Rogue NS instance 
Back to top
Login to vote
Maria

External


Since: Jun 29, 2007
Posts: 2



(Msg. 3) Posted: Fri Jun 29, 2007 6:58 am
Post subject: Re: Rogue NS instance [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
On 29 Jun, 14:13, Joe Webb wrote:
> Hi Maria -
>
> In SQL Server 2005, SSNS instances are tracked in the msdb database. Try
> deleting the instance row in msdb.NS90.NSInstanceInfo and the application
> row in msdb.NS90.NSApplicationInfo tables. Afterward you should be able to
> create your instance again.
>
> There's a bit more information about this on my blog.
>
> http://sqlns.blogspot.com/2007/04/finding-ssns-instances-using-t-sql....
>
> HTH...
>
> Joe
>
> --
> Joe Webb
> SQL Server MVPhttp://www.sqlns.com

Thank you very much Joe, that did the trick. Handy to know info is
stored in msdb too (rather than somewhere "unreachable"!)

Have a good weekend!
Maria
 >> Stay informed about: Rogue NS instance 
Back to top
Login to vote
Display posts from previous:   
Related Topics:
Instance name for SQL 2005 - Hi, If I try to create a notification service instance where the SQL 2005 instance is having (\) in the name, it gives error saying that \ are not allowed. GS

Customizing NS instance db - opinions? - I want just a few more features in my notification application that I haven't seen in SQL NS - the main feature we're desiring is the ability for subscribers to maintain their subscriptions. I know this needs to happen in a Sub. Management interface,..

Troubleshooting Creation of an SQL-NS Instance - Hi all, I am attempting to create an instance of an SQL-NS service, and that creation has failed because it was found that there was a compatibility issue with the DB. That has since been corrected. I attempted to create the instance again, and am..

Start Notification Instance Automatically - Hi, 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..

Accessing NS Instance on a Database Server from a Web Server - Hello. I'm new to SQL Server 2005 Notification Services. I'm trying to access an Instance of SQL 2005 NS on a remote Database Server from a Web Service on a different web server, using the following code: <C#> using..
   Database Forums (Home) -> Notification Services All times are: Pacific Time (US & Canada)
Page 1 of 1

 
 You can post new topics in this forum
You can reply to topics in this forum
You can edit your posts in this forum
You can delete your posts in this forum
You can vote in polls in this forum



[ Contact us | Terms of Service/Privacy Policy ]