Re: Troubleshooting Creation of an SQL-NS Instance
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.
SELECT * FROM NS90.NSInstanceInfo
SELECT * FROM NS90.NSApplicationInfo
SQL Server MVP
Get up to speed quickly with SQLNS
I support PASS, the Professional Association for SQL Server.
On Wed, 13 Sep 2006 11:42:02 -0700, Isadore Schwartz
<[email protected]> wrote:
>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?