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 |
|
dhw
Constraint Violating Yak Guru
332 Posts |
 Posted - 2003-01-29 : 19:41:55
|
| I have set up (or attempted to set up) a snapshot replication from SQL2000 to MSDE. I configured the publisher and distributor as the same server and have set it to allow for anonymous pull subscriptions. On my subscriber (MSDE) I set up a pull subscription that starts to run and then fails. From the job history log I see:Category:COMMANDSource: Failed CommandNumber: Message: exec sp_helpdistpublisher N'SECURE.IOMEDEX.COM'Category:SQLSERVERSource: HANTANumber: 14080Message: The remote server does not exist or has not been designated as a valid Publisher.The remote server does not exist or has not been designated as a valid Publisher. The step failed.I made sure to set up the publisher/distributor server as a remote server on the MSDE server. Is there something else that might cause the job to fail?Thanks...dhw |
|
|
dhw
Constraint Violating Yak Guru
332 Posts |
Posted - 2003-01-30 : 10:52:42
|
| okay...well, I was able to get the replication working. The problem, appears to be with the reference to the server name. When I use the server's name to set up the pull subscription it works fine. However...I was hoping to be able to use a reference like 'secure.company.com' or even an ip address. I can register, via enterprise mangager, using both of these methods and access the server without any problems. The folks that will be connecting over the internet will not be part of the windows domain...and therefore, the server name won't be accessible (or won't resolve) whereas, they can connect using the fully qualified name ('secure.company.com') or even an ip address. I am new to replication ... so I am probably missing some important pieces of knowledge.thanks,dw |
 |
|
|
|
|
|
Replication Fails...