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 |
|
rushdib
Yak Posting Veteran
93 Posts |
 Posted - 2004-01-29 : 18:39:24
|
| Hi,We have 1 distributor and a publisher on the same machine. Currently we use Window authentication to talk to different subscribers on different servers. We use merge and transactional replication.We are adding a new subscriber. Fot this SQL Server, we have to use SQL authentication (with sa username). Now I was able to create a publisher (transactional) and pushed a new subscription to the subscriber. The changes to the tables are going from publisher to subscriber, but not from subscriber to the publisher. The queue reader is failing. Queue reader aborting. The step failedI think the problem is publisher is not authenticating the subscriber. But I don't know where to add that. Can someone please help me?Thank you,Rushdi |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2004-01-29 : 18:57:20
|
| What is the error? You'll find it in the Replication Monitor on the distributor server.Tara |
 |
|
|
rushdib
Yak Posting Veteran
93 Posts |
Posted - 2004-01-30 : 08:45:07
|
| The following error is in the queue readerThe queue reader is failing. Queue reader aborting. The step failed |
|
|
|
|
|
|
Replication problem