Failed replication

• MickyD

  SSCarpal Tunnel

  Points: 4593

  More actions

  August 31, 2005 at 7:18 am

  #88798

  Today we have changed SQL Server to run under a local machine login , who is in the admin group. This is because of some security accreditaiton we are conducting.

  SQL runs ok , SQL Agent runs ok under this new account. However when trying to run replication jobs they fail.

  Don't know what I have to change \ configure to get them to run under this account ?

  Anyone offer any top tips ?

  Cheers

• Hilary Cotter

  SSCommitted

  Points: 1861

  More actions

  September 1, 2005 at 5:02 am

  #586770

  right click on the agent, select agent properties, and make the job owner sa.

  --

  Hilary Cotter

  Looking for a SQL Server replication book?

  http://www.nwsu.com/0974973602.html

   

  Looking for a FAQ on Indexing Services/SQL FTS

  http://www.indexserverfaq.com