Need some urgent help chaps " at least when you have stopped laughint from
shock"

I have inherited a sql 6.5 server running on an old nt4 server. "ok pause
for laughter"

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

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



HELP PLEASE

Hi,

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)
or later."

Check the link below, this could help you in upgrading 6.5 to 2000.

http://www.microsoft.com/technet/pro...y/sqlugrd.mspx

Thanks,
Vidhya Sagar

"deyes" wrote:

HI Vidyha

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
http://www.sqlmonster.com/Uwe/Forums...setup/200901/1