I have created distribution and publisher and have setup the subscriber on a separate server using the following link h ttp://www.techrepublic.com/blog/howdoi/how-do-i-configure-transactional-replication-between-two-sql-server-2005-systems/123. In Fig Q what should I use for the user name and password while setting up the connection to the subscriber. Upon executing the following script
Select d.name, sp.name From sys.databases d Left Join sys.server_principals sp On sp.sid = d.owner_sid AbraEmployeeselfservice database has IMSAoperator as owner. Can I use that or do I have to use a different account. Please advice. Thanks in advance.