Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
DBADave
Constraint Violating Yak Guru
366 Posts |
 Posted - 2003-09-08 : 16:08:41
|
| 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 |
|
|
DBADave
Constraint Violating Yak Guru
366 Posts |
Posted - 2003-09-08 : 16:46:29
|
| 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 |
 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2003-09-08 : 17:25:03
|
| EM and Query Analyzer were probably fine due to aliases being created on the client. If you create an alias with the IP address, you will not need to use DNS or WINS to get to it.Tara |
|
|
|
DBADave
Constraint Violating Yak Guru
366 Posts |
Posted - 2003-09-09 : 08:21:20
|
| No aliases existed on the client. |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2003-09-09 : 11:55:26
|
| You could also have entries in your HOSTS or LMHOSTS file. Other than that though, I am out of ideas.Tara |
|
|
|
|
|
|
Production Replication and Linked Server Failure