Showing posts with label solution. Show all posts
Showing posts with label solution. Show all posts

Friday, March 9, 2012

Migration Problem with NS SQL 2000 to NS SQL 2005

Hello,

I'm traying to migrate a Notification service solution from SQL Server 2000 to SQL Server 2005. The solution works fine on SQL Server 2000, but on 2005 I allways get the message: "The registry entries for the specified instance of Notification Services could not be found". This message shows up everytime when i want to see the Subscriptions of a given Subscriber in my Web-Interface (written in ASP and C#) or when I want to add a new Subscription. News of a existing Subscription are shown without a problem.

So far I know i did follow all the steps to migrate the Database, Application and NS-Instance.

First I upgrated the DB-Files in SQL 2000 to SQL 2005. (Only the DB-file for user and admin Login for the Web-Inteface) Then i attached the DB file on the SQL 2005 server. So far everything works fine and users can log in. Then I edited the ADF-File and chaged all the NOTIFY syntax to INSERT INTO and changed all the paths to the new server-environement. In the Management Studio of SQL 2005 I created a new NS-Instance with the adapted ADF-file and the service is running without problems. At the end I recompiled all the ASP and C# scripts in Visual Studio 2005 with the assemblies of .NET 2.0 and SQL Server 2005.

Does anybody knows why the entries of this existing and running instance in the registry can't be found? The name of the instance is right and is in the registry.

Can anybody help ?

From my replies to your newsgroup posting....


Have you checked with the depreciated features pages of BOL to make
sure your C# code isn't making use of the old way of doing things?
ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/instsql9/html/c4612650-eaa9-443a-a4ef-95d9feaf4976.htm
Can you post the code that's failing?

By the way, I have an article on Simple-Talk.com about upgrading
to SQLNS 2005 from 2000.

http://www.simple-talk.com/2006/04/10/building-effective-sql-server-notification-applications-part-i/
or

http://sqlns.blogspot.com/2006/04/upgrading-to-sqlns-2005-from-2000.html

|||I had the same problem and solved it by changing my reference in VS to point to newest version of microsoft.sqlserver.notification.dll (version 9.0.242.0) and recompile- hope this helps-

Wednesday, March 7, 2012

Migration from SQL2000 to Cluster SQL2005 ?

Hello Everyone,
What is the best solution for my predictament? I'm moving from a single
non-cluster SQL2000 STD environment (Server A) to a clustered SQL 2005 STD
environment (Server B). Seamlessly as possible, how can I migrate the
databases from Server A to Server B? I would like to preserve my instance
name on Server A with the new cluster environment (Server B) if possible.
Thank you
Alex Anderson
You can't do this as an in place upgrade. You are going to have to build
the new cluster, install a SQL Server failover cluster instance, and then
move the databases. The most seamless way would be using a detach/attach or
a backup/restore. You'll have to make sure you take care of the master and
msdb databases as well.
Mike
http://www.solidqualitylearning.com
Disclaimer: This communication is an original work and represents my sole
views on the subject. It does not represent the views of any other person
or entity either by inference or direct reference.
"Alex Anderson" <Alex Anderson@.discussions.microsoft.com> wrote in message
news:BC54F1A0-BEE4-4492-8934-4905C80B8005@.microsoft.com...
> Hello Everyone,
> What is the best solution for my predictament? I'm moving from a single
> non-cluster SQL2000 STD environment (Server A) to a clustered SQL 2005 STD
> environment (Server B). Seamlessly as possible, how can I migrate the
> databases from Server A to Server B? I would like to preserve my instance
> name on Server A with the new cluster environment (Server B) if possible.
> Thank you
> Alex Anderson