SQL Server Replication
-
I am trying Transactional Replication between SQL Server 2005 SE and SQL Server Express installed on a client machine. I am getting "Uninitialized Subscription" status on Replication monitor. The error message is like "The job failed. Unable to determine if the owner (DOMAIN\Joseph.Thomas) of job ACR-MANGO-October10-OCT-10 Pub-ACR-ANJILI\SQLEXPRESS-35 has server access (reason: Could not obtain information about Windows NT group/user 'DOMAIN\Joseph.Thomas', error code 0x5. [SQLSTATE 42000] (Error 15404) The statement has been terminated. [SQLSTATE 01000] (Error 3621))." The steps i followed are 1. Create a publication in SQL Server 2005 SE. I could successfully create Publications on Server. The security setting i gave are SnapShot Agent Process: Run Under SQL Server Agent Service Account Connect to publisher: By Impersonating the process account 2. Create subscription on SQL Server Express Distribution Agent Security:Run under SQL Server Agent Service account Connect To Distributor:By Impersonating the process account Connect To the Subscriber:By Impersonating the process account Sync Schedule Agent Location: Distributor Run Continuously 3. Add a new login for the SQL Server Express user in SQL Server 2005 SE. Give role as sysadmin Please advise Thanks