Results 1 to 2 of 2
  1. #1
    Join Date
    Jan 2003
    Posts
    95

    Unanswered: 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, Dave

  2. #2
    Join Date
    Jan 2003
    Posts
    95
    The 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

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •