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.

 All Forums
 SQL Server 2000 Forums
 Import/Export (DTS) and Replication (2000)
 replication between 2 SqlServers

Author  Topic 

Asteroid
Starting Member

13 Posts

Posted - 2005-03-11 : 06:26:54
Hi again,
This time i am facing a probelem in snapshot Replicating between two sql servers running in our work group.

I am running the sql server and it's agent in new account of belonging to administrator group. Now the distributior and publisher are on same machine and I guess are configured right.

The second sql server as is registered in my sever group list. I can access databases of that in Enterprize manager and can update or change them.

Now when i configure it as a subscriber through Wizard all goes fine and a succes mesage is displayed but the replication process fails.

It logs an error: The process could not connect to subsriber.

More over the snapshop agent prompts that "A snap shot with x articles finished success fully"

Do I am violating any net work problems.

More over : We are working Work group LAN.
and the replication process at same server to different databases work fine. (I mean distributoir, publisher and subsriber resides on the same machine)

Please any help
Regards

jen
Master Smack Fu Yak Hacker

4110 Posts

Posted - 2005-03-13 : 21:35:18
the replication is not yet completed. the snapshot was successfully generated (distributor side) and failed to be applied at the subscriber side.

check this post on how to change the account information on the subscriber side.

http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=46729&SearchTerms=replication

--------------------
keeping it simple...
Go to Top of Page
   

- Advertisement -