microsoft.public.sqlserver.notificationsvcs
[Top] [All Lists]

Re: Troubleshooting Creation of an SQL-NS Instance

Subject: Re: Troubleshooting Creation of an SQL-NS Instance
From: Isadore Schwartz
Date: Thu, 14 Sep 2006 05:22:01 -0700
Newsgroups: microsoft.public.sqlserver.notificationsvcs
Thank you Joe,

Right on the money. That's exactly what was there.

I've got another potential issue coming shortly. Depending on whether or not 
I can hack my way through it myself.

"Joe Webb" wrote:

> In SQL Server 2005, metadata about each SQLNS instance is stored in
> the msdb database. Run the following script and I suspect you'll find
> an entry for your failed creation attempt.
> 
> USE MSDB
> GO
> 
> SELECT * FROM NS90.NSInstanceInfo
> SELECT * FROM NS90.NSApplicationInfo
> 
> HTH...
> 
> -- 
> Joe Webb
> SQL Server MVP
> http://www.sqlns.com
> 
> 
> ~~~
> Get up to speed quickly with SQLNS
> http://www.amazon.com/exec/obidos/tg/detail/-/0972688811 
> 
> I support PASS, the Professional Association for SQL Server.
> (www.sqlpass.org)
> 
> 
> 
> On Wed, 13 Sep 2006 11:42:02 -0700, Isadore Schwartz
> <[email protected]> wrote:
> 
> >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 running into this error 
> >every time I make the attempt to create - 
> >
> >System.Reflection.TargetInvocationException: Exception has been thrown by 
> >the target of an invocation. ---> A Notification Services instance is 
> >already 
> >using the specified schema in the database. Specify a different schema name.
> >Instance Name: AwmInboxNMO
> >Database Name: AMBDev50
> >Schema Name: dbo
> >
> >1) There are no other instances running atm. This is the first one I've 
> >tried to create. I've not yet been able to get it to run in the first place.
> >2) I do not see any other instances even listed in the database.
> >3) I 'am' attempting to create this instance in the application database, 
> >not as a separate database.
> >4) I wish for it to use the dbo schema as the primary for the active SQL-NS 
> >instance with the application.
> >
> >Anyone have any ideas as to what could be occurring?
> 

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