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: Joe Webb
Date: Thu, 14 Sep 2006 06:58:24 -0500
Newsgroups: microsoft.public.sqlserver.notificationsvcs
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>