I'm having problems getting replication to work in MSSQL 2005. I've create a publisher and subscriber, but when the subscriber is syncing with the publisher, I get the following error:
Agent message code 14080. The remote server "EPSTRM01" does not exist, or has not been designated as a valid Publisher, or you may not have permission to see available Publishers.
The options I used for the publisher are "run under the SQL Server Agent Service account" and "impersonate the process account". I would like to create Process Account to run under Snapshot Agent Security, but I'm not able to get anything
working here. How do I create a process account?
View Complete Post