SQL Server Blogs - proxy account information

proxy account information - xp_sqlagent_proxy_account check this http://msdn2.microsoft.com/en-us/library/aa260700(SQL.80).aspx to find out if any proxy account is used or not and how toset one. and this one: http://msdn2.microsoft.com/en-us/library/aa260289(SQL.80).aspx to find out when and how to use a proxy account. Permissions Execute permissions default to the public role in the msdb database. A user who can execute this procedure and is a member of the sysadmin fixed role can start any job. A user who is not a member of the sysadmin role can use sp_start_job to start only the jobs he/she owns. When sp_start_job is invoked by a user who is a member of the sysadmin fixed server role, sp_start_job will be executed under the security context in which the SQL Server service is running. When the user is not a member of the sysadmin fixed server role, sp_start_job will impersonate the SQL Server Agent proxy account, which is specified using xp_sqlagent_proxy_account. If the proxy account is not available, sp_start_job will fail. This is only true for Microsoft® Windows NT® 4.0 and Windows 2000. On Windows 9.x, there is no impersonation and sp_start_job is always executed under the security context of the Windows 9.x user who started SQL Server. AND Sets or retrieves the proxy account information used by SQL Server Agent and the xp_cmdshell extended stored procedure when executing jobs or commands for users who are not members of the sysadmin fixed server role. The proxy account is a Microsoft® Windows® account in whose security context the jobs or command prompt commands are run.

Permalink \| Trackback
Location: Blogs Stevan Tosic
Posted by: host	10/15/2008 10:40 AM

Comments (0)