June 5, 2006 at 7:01 pm
Hi
We are in process of upgrading the SQL server 2000 Notification Instances to SQL Server 2005. We are doing "Side-by-Side Upgrade" on a new 64-bit server.
We are following the instructions as per the document
"SQL Server 2005 Upgrade Technical Resource Guide".
Following are the steps we have completed:
1. Install SQL Server 2005 Database Engine/Notification Services on a new server
2. Installed .NET framework 2.0 on new server (64-bit machine)
3. Taken backup of existing Notification Databases i.e. MyAppNSMain, MyAppNSApp.
4. Restored the backups on the new server.
5. Run NSControl repair command
NSControl repair -name ABCPress -database ABCPressNSMain _
-schema dbo -server ServerName
6. Run NSControl upgrade
NSControl upgrade -name MyInstance -server MyDbServer
This step gives error that Instance must be disabled. When we try to disable the instance using
nscontrol disable -name myinstance -server myserver
It gives error:
The assembly version does not match the database version.
Assembly Version: 9.0.242.0
Database Version: 2.0.3008.0
Please let us know if we are missing any step.
Thanks
Gagan
June 7, 2006 at 8:38 am
It is either a corrupt file or the databse does not have a reference for the assembly. Try restoring the databse again and/or re-register the assembly.
Joshua Perry
http://www.greenarrow.net
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply