Problems migrating SQL 6.5 to SQL 2000
in [Replication]
|
Prev: murge process could not clean up the subscription
Next: Merge Agent failed - Error number: MSSQL_REPL-2147199402)
From: alejandro on 20 Feb 2007 06:33 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
From: Hilary Cotter on 20 Feb 2007 07:25
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.nwsu.com/0974973602.html Looking for a FAQ on Indexing Services/SQL FTS http://www.indexserverfaq.com "alejandro" <alejandro(a)discussions.microsoft.com> wrote in message news:5790A0A5-C59C-42C8-8650-D83FEEB4B872(a)microsoft.com... > 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 |