Re: Default Permissions

From: Cindy Gross (cgross_at_online.microsoft.com)
Date: 03/30/04 

Date: Mon, 29 Mar 2004 22:44:32 GMT

If you use Enterprise Manager to choose the account(s) used to start SQL
Server and SQL Server Agent then the permissions will all be granted to
that account automatically.

Cindy Gross, MCDBA, MCSE
http://cindygross.tripod.com
This posting is provided "AS IS" with no warranties, and confers no rights.

Relevant Pages

  • 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)
  • Snapshot Agent account rights
    ... Using SQL Server Agent as the Snapshot Agent account is not a recommended ... If a domain account is used, what rights and ... permissions should it be granted? ...
    (microsoft.public.sqlserver.replication)
  • Re: Replication problems
    ... not yet have any Publications in my Enterprise Manager. ... configure the SQL Server Agent service to start automatically" or "No, ... I always created Databases ...
    (microsoft.public.sqlserver.ce)
  • 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)
  • Re: sql agent service
    ... In Administrative Tools -> Services, ... named SQLSERVERAGENT ... You can also find it in Enterprise Manager under Management ... and then go to SQL Server Agent. ...
    (microsoft.public.sqlserver.security)