|
|
Posted by John Bell on 08/06/06 11:36
Hi
I have never used the wizard to upgrade from 6.5 as I tend to use BCP as
this gives you better overall control. A guess would be the directory or
share permissions are not correct.
John
"rdraider" <rdraider@sbcglobal.net> wrote in message
news:FMwAg.2140$kO3.1362@newssvr12.news.prodigy.com...
> Hi,
> I am trying to use the Upgrade Wizard in SQL 2000 to upgrade a SQL 6.5 db
> to 2000. I am only choosing to update a single database, not system
> objects.
> The Upgrade wizard connects to SQL 6.5, checks the db, creates the db on
> SQL 2000 with all tables and imports users from SQL 6.5. The problem
> comes when it tries to bring over the actual data. I get an error:
> "Couldn't connection to the export machine!" in the out log file.
> The in log file reports login failed.
> Both SQL services were running at this point, the login via SA must be
> working since it copies over the 6.5 db structure and users.
> The SQL 6.5 machine is NT 4. The 2000 machine is Windows Server 2003. I
> was logged in as domain admin when running this. I tried playing with the
> "SQLUpgrade" DSN that was created on the SQL 2000 machine to use SA or
> windows authentication, both fail.
>
> Any ideas?
> Thanks.
>
>
Navigation:
[Reply to this message]
|