Roy,

I don't want you to think that I forgot about you or anything. I've been working through some various experiments, but they all seem to bring me back to the...

Yes, the publisher is SQL 2000. I am trying to do a PUSH transactional subscription. My distributor, which is the same machine as the subscriber is SQL 2008....

If it makes you feel any better, the first page was basically not me. 🙂 Anyway, thanks again for sticking with me!

Anyway, I tried that as one of my...

the dtwservice that we talked about earlier

LOL! Good point!

Anyway, turns out that it didn't help at all. It still fails at the same SP, so it really just can't see them. I logged...

Thanks for pointing me to sp_browsereplcmds. Is it possible that replication would get hung up if it's trying to insert a PK into a table that already has that...

Yes, it all does. This is how we started. 🙂

Patrick

Roy,

Thanks for hanging with me all day on this! I assumed that the logins always defaulted to master, but apparently that's not the case.

Unfortunately, that gets me back...

Thanks for pointing me to the event viewer. Here is the error it's been throwing for 5 hours:

" ALPHA\dtwservice

Reason: Failed to open the...

I should probably clarify that is my distributor.

Patrick

I've been through everything that I can possibly fathom being used as a login and I'm still getting the following:

"

2010-11-30 18:49:04.606 Status: 0, code: 1007, text: 'The process could not...

Ah! The repl_distributor in the linked servers is using distributor_admin as its login, whereas everything else is pointed to ALPHA\SqlAgent2005Prod. Is that OK, or do I need to...

Yep, that seems to work just fine. As a side note, I checked into the jobs that were failing and I am getting this error:

"Agent message code 20084. The...

It is both of those things. 🙂 It is a domain that is sysadmin on both the publisher and the distributor/subscriber (since they're both on the same machine)

Roy,

Checked all of that out and it looked fine, but everything had frozen due to the HDD filling up. I purged that to free up about 500 GB, then...