Urgent! Can't upgrage 6.5 to 2000

[FranklinYeung]

Hi all,

Both MS SQL 6.5 & MS SQL 2000 was installed into a Window NT4+SP6 server called 'Test'. Then i execute the Microsoft SQL Server Switch -> SQL Server Wizard, after followed the instruction and entered the password for the "import server" and "export server", system always return the following message

"Window NT only authentication has been detected on your SQL 2000 server, 'Test'. Upgrade requires SQL server authentication. Please enable SQL server and Window NT Authentication on this server and try again"

No matter what I set in the SQL server properties page.. this error return.

What should be changed in both 6.5 server and 2000 server so the the upgrade can be proceed.

As it is very urgent, hope to hear your suggestion..

Thanks in advance.

Franklin

 

[rajeevnandanmishra]

Hi Franklin,

I have not worked with SQL 2000. But i had upgraded my server from 6.5 to 7.0 . That time i was also having something same type of problem. What i had done is following:
1) Change the Connection Property Setting in Enterprise Manager to SQL Authentication/ Standard Security.

2) Then i connect with login id sa and its password (which was same on both servers).

3) Then i did the upgradation. And it completes successfully.

You can try the same. I hope it will be helpful for you.

 

[FranklinYeung]

HI rajeevnandanmishra,

Should i also change the WIN NT sql related-service startup "log on as" setting?

I tried to enter the login id 'sa' and its passowrd in the SQL registration tab in enterprise manager, but when i execute the upgrade function, the problem appears again...

Any idea?

Thanks

 

[rajeevnandanmishra]

Hi,

No, i don't think you require to change WIN NT sql related-service startup.

I don't know much about sql 2K.
You can go through the following link

http://www.microsoft.com/technet/sql/technote/sqlugrd.asp#d

May be it can help in solving your problem.