Problems migrating SQL 6.5 to SQL 2000

Problems migrating SQL 6.5 to SQL 2000

Post by YWxlamFuZH » Wed, 21 Feb 2007 20:33:15


I'm using the "SQL Server Update Wizard" to migrate SQL Server 6.5 databases
to SQL Server 2000.
When I try to connect to export server (SQL 6.5) i get the following error:
"Unable to connect to the Export server. Please verify that you are an NT
Administrator on that machine."
Both servers use 'sa' user.
SQL 6.5 is runnig on Windows NT Server 4.0 and SQL 2000 is running on
Windows Server 2003.
I've tried make 'sa' a member of Replicator group, but it doesn't worked.
Someone can help me?

Thanks
 
 
 

Problems migrating SQL 6.5 to SQL 2000

Post by Hilary Cot » Wed, 21 Feb 2007 21:25:55

What sp of SQL 2000 is running on the Windows 2003 server, it should be at
least sp1.

--
Hilary Cotter

Looking for a SQL Server replication book?
http://www.yqcomputer.com/

Looking for a FAQ on Indexing Services/SQL FTS
http://www.yqcomputer.com/