Snapshot Agent account rights

Using SQL Server Agent as the Snapshot Agent account is not a recommended
best security practice. If a domain account is used, what rights and
permissions should it be granted ?


.

Relevant Pages

  • Re: Default Permissions
    ... If you use Enterprise Manager to choose the accountused to start SQL ... Server and SQL Server Agent then the permissions will all be granted to ... This posting is provided "AS IS" with no warranties, and confers no rights. ...
    (microsoft.public.sqlserver.security)
  • Win2k and SQL2k security
    ... Does anyone know a url to a white paper that explains what ... rights the Sql Server Agent needs in order to create ... operating system and Active Script jobs not belonging to ... rights in order to run these types of jobs. ...
    (microsoft.public.win2000.security)
  • SQL Server Agent Proxy Account / XP_CMDSHELL
    ... I am trying to run the xp_cmdshell and am calling it with osql from a batch ... permissions and all works OK there as well. ... In reasearching this issue I should be able to set the sql server agent ...
    (microsoft.public.sqlserver.security)
  • Re: Could not Bulk insert beacuse file could not be opened
    ... Does the SQL Server agent account have ... rights to access this file? ... "MMSqlserver" wrote in message ...
    (microsoft.public.sqlserver.fulltext)
  • Re: Win2k and SQL2k security
    ... think complete local admin rights would be necessary, ... >> Does anyone know a url to a white paper that explains what ... >> rights the Sql Server Agent needs in order to create ... >> operating system and Active Script jobs not belonging to ...
    (microsoft.public.win2000.security)