SQL 6.5 to 2K Upgrade Problem

[Ken Cowin]

Have a 6.5 box with 5 or so user db's that I am trying to run the 2K upgrade wizard on. The 2K box is with the default instance with some existing unrelated db's already there.

Get thru the menus of the wizard (no 6.5 errors detected on final screen)and when the upgrade is performing, get an error on the processing logins section. Error in log file - 'LOGONIDS: Unable to open output file'. I choose not to transfer the Server Configuration during the wizard. There is only the sa login on the 6.5 box.

Any clues ?

[MAK]

you can find the actual error in the log file created.
look for .log and .err file


Microsoft SQL Server\MSSQL\Upgrade\

[Ken Cowin]

MAK,

The log file had this in it which did not get me any farther. I also tried changing the 6.5 sa password to blanks, but got the same results.

Thanks

##### Monday, March 24, 2003 - 13:34:53 #####
Task
Preparing SQL-DMO for upgrade Complete 13:32:25 13:33:46
Verify - Exporting 6.5 Schema Complete 13:33:47 13:33:52
Verify - Exporting 6.5 Row Counts Complete 13:33:53 13:34:32
Export Server Settings from Master Complete 13:34:33 13:34:34
Export Logins Error 13:34:34 13:34:36
##### Monday, March 24, 2003 - 13:35:04 #####
Task
Export Logins Error 13:34:54 13:34:55

[MAK]

Script all the logins in 6.5 and drop all the logins in 6.5 server except SA. then try upgrading it.

[Ken Cowin]

MAK,

Dropped all the logins in 6.5 and got the same error. Also tried setting the sa password to blanks, but same results.

The 6.5 and 2K boxes are on 2 different domains, but the LAN gods here (I know little in this area (domains, active directory, etc) say that since I am using an account that is defined in both domains with the same password and with active directory, it should appear as if the boxes were in the same domain. Still though, I recreated the 6.5 SQL databases, logins, etc on my notebook which is in the same domain as the 2k box and was able to get thru the upgrade wizard successfully.

This was a preliminary upgrade this time and will need to do the final upgrade in a week or so. I will use my notebook as a go-between then if I cannot figure out what this problem is.

Thanks.