Troubleshooting Creation of an SQL-NS Instance

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Isadore Schwartz - 13 Sep 2006 19:42 GMT

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?

Reply to this Message

Joe Webb - 14 Sep 2006 12:58 GMT

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...

Signature

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)

>Hi all,
>
[quoted text clipped - 21 lines]
>
>Anyone have any ideas as to what could be occurring?

Reply to this Message

Isadore Schwartz - 14 Sep 2006 13:22 GMT

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.

> 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
[quoted text clipped - 33 lines]
> >
> >Anyone have any ideas as to what could be occurring?

Reply to this Message