all groups > sql server notification services > may 2005 >
You're in the

sql server notification services

group:

Problem porting NS application from SQL2000 to SQL2005


Problem porting NS application from SQL2000 to SQL2005 tarpan
5/18/2005 6:37:27 AM
sql server notification services:
The NS applicatipon works fine on the SQL Server 2000 (installed on Win2000).
I have moved it now on SQL2005 (Win XP Server). My ASP.NET application
statred to crash with the message:

" The registry entries for the specified instance of Notification Services
could not be found."

on the line

NS_Instance = New
Microsoft.SqlServer.NotificationServices.NSInstance(NS_InstanceName)

The instance is definately exists. The instance name is the same.

What to look at?
Re: Problem porting NS application from SQL2000 to SQL2005 Joe Webb
5/18/2005 8:52:00 AM
Hi Tarpan -

On the new machine, have you created and registered the instance using
SQL Server 2005? Do you see NS$<InstanceName> in the services of the
new machine?

--
Joe Webb
SQL Server MVP


~~~
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, 18 May 2005 06:37:27 -0700, tarpan
[quoted text, click to view]
Re: Problem porting NS application from SQL2000 to SQL2005 Shyam Pather [MSFT]
5/18/2005 2:40:00 PM
You need to register the instance with nscontrol register.

When you say you moved the application to SQL 2005, do you mean that you
created it again on the SQL 2005 server? Or are you trying to migrate the
existing SQL2000 application (created databases etc) to SQL 2005?

If it's the latter, you need to follow the instructions in SQL Server 2005
Books Online for migrating from SQL 2000 to SQL 2005. Also, you need to use
the NS tools from the SQL 2005 install - you cannot run NS 2.0 tools against
a SQL 2005 database server.
-shyam
--
Learn more about SQL-NS:
http://www.amazon.com/exec/obidos/tg/detail/-/0672326647/
---------------------------------------------
This posting is provided "AS IS" with no warranties, and confers no rights.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm.
---------------------------------------------
[quoted text, click to view]

Re: Problem porting NS application from SQL2000 to SQL2005 tarpan
5/19/2005 9:02:05 AM
[quoted text, click to view]

Yes.

[quoted text, click to view]

Yes. Up and running.




[quoted text, click to view]
Re: Problem porting NS application from SQL2000 to SQL2005 tarpan
5/19/2005 9:11:05 AM
Thabk you for the responce

[quoted text, click to view]

:-)
Registered
The service is up and running.
The SQL server Management Studio shows the Instance in the Notification
Services group.

[quoted text, click to view]

Yes.

Or are you trying to migrate the
[quoted text, click to view]

No.
Fresh server installation, fresh new DB, and fresh NS apllication created
locally from ADF file same as on server with SQL Server 2000.






[quoted text, click to view]
Re: Problem porting NS application from SQL2000 to SQL2005 Shyam Pather [MSFT]
5/19/2005 10:56:51 AM
Glad to hear you've got it running. Keep in mind that you may not be able to
use exactly the same ADF for SQL 2005, because the Notify() function is no
longer supported. You need to replace any match rules that do

SELECT <NotificationClassName>Notify(...)
....

with

INSERT INTO <NotificationClassName>(...)
SELECT...

This is described in detail in Books Online.

--
Learn more about SQL-NS:
http://www.amazon.com/exec/obidos/tg/detail/-/0672326647/
---------------------------------------------
This posting is provided "AS IS" with no warranties, and confers no rights.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm.
---------------------------------------------
[quoted text, click to view]

Re: Problem porting NS application from SQL2000 to SQL2005 tarpan
5/19/2005 12:47:06 PM
Not at all!


[quoted text, click to view]

Yes. I will try one more time after restart the server completely.
Unfortunately I can not restart the sevrer any time. You know... it's still a
server.

[quoted text, click to view]
Re: Problem porting NS application from SQL2000 to SQL2005 tarpan
5/19/2005 12:52:02 PM
[quoted text, click to view]

%-(
I did not. It always ran fine. But the application does not see the instance.

[quoted text, click to view]
Re: Problem porting NS application from SQL2000 to SQL2005 tarpan
5/19/2005 12:56:07 PM
[quoted text, click to view]

Re: Problem porting NS application from SQL2000 to SQL2005 Joe Webb
5/19/2005 2:23:13 PM
Tarpan -

So, is you issue resolved now?

If not, have you tried unregistering and re-registering your instance
on the web server where the Subscription Management Application is
failing?

--
Joe Webb
SQL Server MVP


~~~
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 Thu, 19 May 2005 09:11:05 -0700, tarpan
[quoted text, click to view]
Re: Problem porting NS application from SQL2000 to SQL2005 Joe Webb
5/19/2005 3:26:51 PM
No need to restart the server, just:
1) stop the NS$<InstanceName> service
2) disable the instance
3) unregister the instance
4) register the instance
5) enable the instance
6) start the NS$<InstanceName> service

That will recreate the register entries & performance counters for
you.

I'm sure you already have, but you may also want to triple check the
name of the instance in the Subscription Management Application to
make sure it matches the instance name.

Is this a single server deployment? That is, are all components
running on this one server?

--
Joe Webb
SQL Server MVP


~~~
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 Thu, 19 May 2005 12:47:06 -0700, tarpan
[quoted text, click to view]
Re: Problem porting NS application from SQL2000 to SQL2005 tarpan
5/20/2005 6:50:03 AM
[quoted text, click to view]

My ReCreate.cmd script does all that in the same sequence. I just tryed it
again - did not help. The instance is exists and running. I have found the
registry entries for the instance using RegEdit.

However, there is one difference between SQL 2000 and SQL 2005
installations. SQL 2000 is installed as a default server, SQL 2005 as a named
server instance. Does it affect the NS at all?

More info:
OS : Windows Server 2003 Web edition
SQL : MS Server 2005 Beta 2





[quoted text, click to view]
Re: Problem porting NS application from SQL2000 to SQL2005 Joe Webb
5/20/2005 11:25:49 AM
Tarpan -

When you recreated the instance with 2005, did you point to the named
SQL Server instance?

You can specify the instance by:
1) modifying the ICF and ADF, or
2) changing the ReCreate.cmd script to pass parameters into the xml
config files, or
3) set environment variables that the ReCreate.cmd script can pickup
and pass to the config files.

Is this a single server deployment? Are all components (SQL Server,
SQLNS components, and IIS) running on the same box? More
specifically, is the IIS application on the same box as SQLNS
instance?




--
Joe Webb
SQL Server MVP


~~~
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 Fri, 20 May 2005 06:50:03 -0700, tarpan
[quoted text, click to view]
Re: Problem porting NS application from SQL2000 to SQL2005 tarpan
5/23/2005 6:45:15 AM
[quoted text, click to view]

Yes. Otherwise it does not work.

[quoted text, click to view]

Yes. So far. Some day it will be split to the several servers. But so far
everything runs on the same server.


[quoted text, click to view]
AddThis Social Bookmark Button