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 |
|
raja
Starting Member
18 Posts |
 Posted - 2005-01-07 : 00:41:27
|
| HiI have two servers Server A and Server B. A is the Publisher and Distributor and B is the Subscriber. Both servers are in the same domain.Now i need to have a Transactional replication with immediate updating Subscriber, but when i create a push subscription the status of the MS DTC service is unknown in the subscriber and the replication fails too.Is this because of improper security setting ??can anyone solve this for me ??Thanks in Advance ! |
|
|
jen
Master Smack Fu Yak Hacker
4110 Posts |
Posted - 2005-01-07 : 02:28:21
|
| is the sqlserveragent running on the publisher?what's the reason for the replication to fail? check for job history--------------------keeping it simple... |
 |
|
|
raja
Starting Member
18 Posts |
Posted - 2005-01-07 : 03:23:07
|
| Yes, the Sql server agent is running on the publisher |
|
|
|
RoyalSher
Yak Posting Veteran
95 Posts |
Posted - 2005-01-07 : 06:54:57
|
| Do you have MS DTC service running in your subscriber?RoyalSher.*********The world is the great gymnasium where we come to make ourselves strong. |
|
|
|
raja
Starting Member
18 Posts |
Posted - 2005-01-07 : 07:12:43
|
| YES |
|
|
|
RoyalSher
Yak Posting Veteran
95 Posts |
Posted - 2005-01-07 : 07:29:46
|
| Can you paste the errors? You can check in Distribution Agent History. May be that would help us to stream down the possible cause.RoyalSher.*********The world is the great gymnasium where we come to make ourselves strong. |
|
|
|
|
|
|
Transactinal Replication