Proxy Account

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Lianne Kwock - 13 Oct 2005 18:52 GMT

I was trying to enable non-sysadmin account to exec xp_cmdshell through the
setup of the SQL Agent proxy account in SQL Server Agent --> Properties -->
Job system; however I got an message said: Unable to set the SQL Agent proxy
account because of the reason listed below. 'Error executing extended stored
procedure: specified user can not login'.

I am using SQL Server 2000 8.00.194.

Any help is highly appreciated.

Thanks,
Lianne

Reply to this Message

Mike Epprecht (SQL MVP) - 13 Oct 2005 21:03 GMT

Hi

Install at least SQL Server 2000 Service Pack 3 as your machine is totally
vulnerable to Slammer Virus.

And for your problem:
http://groups.google.com/group/microsoft.public.sqlserver.server/browse_thread/t
hread/123ba3ade4b96a13/c9fa3308118c4795?lnk=st&q=SQL+Agent+proxy+error+login&rnu
m=1&hl=en#c9fa3308118c4795

Regards
--------------------------------
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland

IM: mike@epprecht.net

MVP Program: http://www.microsoft.com/mvp

Blog: http://www.msmvps.com/epprecht/

>I was trying to enable non-sysadmin account to exec xp_cmdshell through the
> setup of the SQL Agent proxy account in SQL Server Agent -->
[quoted text clipped - 11 lines]
> Thanks,
> Lianne

Reply to this Message

Sue Hoegemeier - 15 Oct 2005 17:57 GMT

In regards to the error, this can happen when the startup
account for SQL Server doesn't have the proper permissions.
If you change the accounts through Enterprise Manager, the
permissions and rights are taken care of for you. If not,
you need to go through and verify the correct rights and
permission. You could reset the service accounts through
Enterprise Manager or go through the following article to
check the permissions for the account:
HOW TO: Change the SQL Server or SQL Server Agent Service
Account Without Using SQL Enterprise Manager in SQL Server
2000
http://support.microsoft.com/?id=283811

-Sue

>I was trying to enable non-sysadmin account to exec xp_cmdshell through the
>setup of the SQL Agent proxy account in SQL Server Agent --> Properties -->
[quoted text clipped - 8 lines]
>Thanks,
>Lianne

Reply to this Message