Wednesday, March 28, 2012

Production Replication and Linked Server Failure

Replication between remote offices, along with linked servers, began failing. Network and server admins indicate that nothing has been changed. The DBA of the remote server also says nothing has been changed. Replication failes with the following message.

The process could not connect to Subscriber 'ProdServer1\Production1'.

SQL Server does not exist or access denied.
(Source: CDB0202\PRODUCTIONLFG (Data source); Error number: 17)

I am able to connect to the remote server using EM and Query Analyzer. I am also able to create linked servers from the local production server to a remote test server.

Any tips on how to troubleshoot this problem?

Thanks, DaveThe problem has been resolved. WINS had expired on the clustered remote server. The network admins don't understand why it happened and can't explain why DNS didn't didn't resolve the name, but at least it is fixed. I'm a bit confused why EM and Query Analyzer did not experience any problems.

Thanks, Dave

No comments:

Post a Comment