Snapshot Agent Security Question


  • Newbie Question: I am trying to set up Snapshot Replication in my lab and tried to set the Snapshot Agent under the security context of the SQL Server Agent service account. But that option is grayed out and the only option available is "Run under the following Windows Account".

    Could any one please tell why this option is grayed out and how to enable it? My team doesn't want to deal with the passwords updates now and then and here's the only the option that I can see that need not have password updates.

    This is SQL Server 2005 hosted on Win2003 server

    I appreciate answer for the question. Thanks a lot.

    Thursday, June 10, 2010 7:01 PM

All replies

  • what is the associated account with the SQL Agent service

    do you have a dedicated windows user account for it ?

    Ahmed ElSangary

    Tuesday, February 21, 2012 3:56 PM