Upgrading SQL 6.5 to 2000 then to 2005. Failing at first hurdle. - 01-26-2009 , 08:32 AM
Need some urgent help chaps " at least when you have stopped laughint from
I have inherited a sql 6.5 server running on an old nt4 server. "ok pause
As you can imagine this server is crap, slow,unreliable and all the rest.
Problem is its critical. Being new here I want to get shot of this system
So began the upgrade path for 6.5 "created an SQL 2000 server on a second
machine and have tried to use the SQL server upgrade wizard.All seems to go
ok untill it comes to the Upgrade of the database objects.
It then fails with the error.
Cannot connect to source server.
ERROR: Executing Connect
Error Code: 5416
Error Category: 5400
Source: Microsoft SQL-DMO
Description: [SQL-DMO]SQL Server NT_SQKSERVER must be upgraded to version 7.0
I have hunted the web for solutions and so far come up blank, Could really do
with a solution or alternative upgrade path..
RE: Upgrading SQL 6.5 to 2000 then to 2005. Failing at first hurdle. - 01-29-2009 , 12:32 AM
Check the below quote
"When upgrading SQL Server 6.5 to an instance of SQL Server 2000 on the same
computer, you must have applied SQL Server 6.5 Service Pack 5 (SP5) or later.
When upgrading SQL Server 6.5 to an instance of SQL Server 2000 on a
different computer, you must have applied SQL Server 6.5 Service Pack 3 (SP3)
Check the link below, this could help you in upgrading 6.5 to 2000.
RE: Upgrading SQL 6.5 to 2000 then to 2005. Failing at first hurdle. - 01-29-2009 , 03:22 AM
Thx for the below, But sadly not the cause. We are doing the upgrade/
Database migration between two Computers and both a serviced packed up to the
Hilt. That was one of my first ideas.
This is really becoming a pain. Any other thoughts.
Vidhya Sagar wrote:
Message posted via SQLMonster.com