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 |
|
en
Starting Member
1 Post |
 Posted - 2006-07-19 : 15:19:11
|
| I have a Sql Server 2000 (SP3) and I'm trying to setup a transactional Replication to be used with MSDE subscribers. Same server is defined as distributor and publisher. I don't have any subscribers yet. Sql Server/Sql Server Agent services run under domain administrator's account. As soon as I create one publication with single article just for testing, I get this error. Any idea would be greatly appreciated, I can't do anything unless I resolve this. |
|
|
jen
Master Smack Fu Yak Hacker
4110 Posts |
Posted - 2006-07-20 : 01:02:50
|
| check the job history, each replication agent has a corresponding jobusually, you may need to check who is the owner of the job and make sure it has appropriate privileges, I just assign SA since I only have the permission to modify themalso, check for the sqlserveragent connection (right click sqlserveragent in EM then properties)HTH--------------------keeping it simple... |
 |
|
|
|
|
|
Log Reader Agent fails with "could not connect .."