SQL 2000 Replication to a SQL 2005

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

interflex@hotmail.com - 29 Jul 2006 02:40 GMT

We have a few replicated accounts, all have been using SQL 2000. One
of the clients the other day decided to upgrade their SQL server
without telling us, hence our replication stopped. I tried to get a
client connection to their server but was unsuccessful. Is there a
client tool or something else I can install on my Windows 2000 Server
with SQL 2000 running on it to get the replication back up and running?

Thanks for responses.

Reply to this Message

Hilary Cotter - 29 Jul 2006 14:54 GMT

What error message are you getting? Can you enable logging? If you can give
us the error message we should be able to solve the problem without
installing extra software.

Signature

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

> We have a few replicated accounts, all have been using SQL 2000. One
> of the clients the other day decided to upgrade their SQL server
[quoted text clipped - 4 lines]
>
> Thanks for responses.

Reply to this Message

interflex@hotmail.com - 29 Jul 2006 21:29 GMT

The clients server is one of my registered server under client
connections and was working fine before they switched to SQL 2005.
When I go into SQL 2000 Enterprise Manager and select the server I
receive a warning dialog box stating the following:

"A connection could not be established to clientsql\clientsql"

"Reason: To connect to this server you must use SQL Server Management
Studio or SQL Server Management Objects (SMO).."

"Please verify SQL Server is running and check your SQL Server ......"

Thanks

> What error message are you getting? Can you enable logging? If you can give
> us the error message we should be able to solve the problem without
[quoted text clipped - 15 lines]
> >
> > Thanks for responses.

Reply to this Message