|
|
|
BLOGS
|
 |
|
|
|
|
|
|
|
|
SEARCH BLOGS
|
|
|
|
|
|
|
|
|
|
DOWNLOADS...
|
|
|
|
|
|
|
|
|
|
BOOKS...
|
|
|
|
|
|
|
|
|
|
Advertisement
|
|
|
|
|
|
|
|
|
|
|
proxy account information - xp_sqlagent_proxy_account
|
|
|
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 |
|
|
|
|
|
|
Announcements
|
|
|
| SQL Server Service Pack Versions - Thursday, October 30, 2008
| Version |
@@VERSION |
MsDtsSrvr.exe File Version |
Registry Version |
Registry Patch Level |
| Release to Manufacturing |
9.00.1399.00 |
9.0.1399.0 |
9.0.1399.06 |
9.0.1399.06 |
| Service Pack 1 |
9.00.2047.00 |
9.0.2047.0 |
9.1.2047.00 |
9.1.2047.00 |
| Post SP1 Cumulative Hotfix |
9.0.2153.00 |
9.0.2153.0 |
9.1.2047.00 |
9.1.2153 |
| Service Pack 2 CTP |
9.00.3027.00 |
9.0.3027.0 |
9.2.3027.00 |
9.2.3027.00 |
| Service Pack 2 |
9.00.3042.00 |
9.0.3042.0 |
9.2.3042.00 |
9.2.3042 |
| Service Pack 2 Rollup 3 |
9.00.3186.0 |
9.00.3186.00 |
9.2.3042.00 |
9.2.3186 |
|
|
|
|
|
|
|