6.5 to 2000 upgrade - Logon failure...

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: MaxinNJ (MaxinNJ_at_discussions.microsoft.com)
Date: 12/25/04 

Date: Sat, 25 Dec 2004 13:35:01 -0800

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

Relevant Pages

  • SQL Server Data Drives & Clustering w/local disk drives?
    ... I have a 6 yr old SQL2000 server running on Win2000. ... I have been tasked with setting up these two machines so that the data ... Everything I have been reading so far states that for clustering, ... automatic failover, and mirroring to properly work together, that it ...
    (microsoft.public.sqlserver.clustering)
  • Re: Function key press across network, how?
    ... >>Have a server running on each of the four target machines, listening on a ... >>Then just broadcast a UDP packet from your controlling machine. ... >>be able to address it to all four machines simultaneously. ...
    (comp.programming)
  • RE: Do I need DSClient to run Exchange 5.5 on an NT4.0 box in Windows
    ... It is a good idea to install the DS client on your NT machines. ... Tony ... > server running 5.5? ...
    (microsoft.public.exchange.admin)
  • Re: Dual Core vs Dual CPU
    ... I need to build 2 machines. ... One will be a web server running Apache, ... and the other will be a mail server running Postfix. ... Try some searches in Google like "postfix resource planning" ...
    (alt.comp.periphs.mainboard.asus)
  • Re: chity chatty sharepoint
    ... occurring between the two and the machines have become increasingly more ... sending and receiving most of the network traffic. ... and the sharepoint database running on an other server running w2k. ...
    (microsoft.public.sharepoint.portalserver)