6.5 to 2000 upgrade - Logon failure...

Hi All,
I am attempting to upgrade my SQL 6.5 databases running on NT4 SP6 to a new
server running Win2003Server and SQL 2000.
The Upgrade Wizard is dying on the Import and Export phase and giving the
error described in KB Article 302850. The cause being a mismatch of users
and permissions between the two machines and the users that are starting the
MSSQLSever service. I attempted to follow the steps listed in this article,
but ran in the problem that I cannot seem to add a domain user from the NT4
machine as a Local Admin on the 2003 Server (no Active directory support I
guess?)
Any other options for me to get this upgrade to happen?
Thanks.
- MaxinNJ
Hi
The solution in:
http://support.microsoft.com/default...b;en-us;818550
is to upgrade your OS on the NT server. You may want to find a third machine
to do this on! Alternatively you may want to try and use the Import
Wizard/DTS or BCP to retrieve the data (and possibly script the database to
get the DDL).
John
"MaxinNJ" <MaxinNJ@.discussions.microsoft.com> wrote in message
news:498B1C83-7395-4604-B6DE-D0CF35A53D9B@.microsoft.com...
> Hi All,
> I am attempting to upgrade my SQL 6.5 databases running on NT4 SP6 to a
> new
> server running Win2003Server and SQL 2000.
> The Upgrade Wizard is dying on the Import and Export phase and giving the
> error described in KB Article 302850. The cause being a mismatch of users
> and permissions between the two machines and the users that are starting
> the
> MSSQLSever service. I attempted to follow the steps listed in this
> article,
> but ran in the problem that I cannot seem to add a domain user from the
> NT4
> machine as a Local Admin on the 2003 Server (no Active directory support I
> guess?)
> Any other options for me to get this upgrade to happen?
> Thanks.
> - MaxinNJ
|||Thanks John - missed that KB article. Well, this at least explains things
Off to find a spare machine and dig up SQL 6.5 disks!
- Max
"John Bell" wrote:

> Hi
> The solution in:
> http://support.microsoft.com/default...b;en-us;818550
> is to upgrade your OS on the NT server. You may want to find a third machine
> to do this on! Alternatively you may want to try and use the Import
> Wizard/DTS or BCP to retrieve the data (and possibly script the database to
> get the DDL).
> John
> "MaxinNJ" <MaxinNJ@.discussions.microsoft.com> wrote in message
> news:498B1C83-7395-4604-B6DE-D0CF35A53D9B@.microsoft.com...
>
>
|||Hi
Make sure it is also service packed to the correct level.
John
"MaxinNJ" <MaxinNJ@.discussions.microsoft.com> wrote in message
news:DF507549-A9B1-40ED-BF65-0EB53DFB0DDC@.microsoft.com...[vbcol=seagreen]
> Thanks John - missed that KB article. Well, this at least explains things
>
> Off to find a spare machine and dig up SQL 6.5 disks!
> - Max
> "John Bell" wrote: