Hi,
We are running SQL Server 2000 SP2 on Windows 2000 SP1.
I want users other than 'sa' to be able to run the xp_cmdshell extended stored procedure. I gather that, in order to do this I need to specify a valid NT account as a proxy account for the 'xp_cmdshell' to run under.
I've tried this in Enterprise Manager (Jobs/Properties) and by using the 'xp_sqlagent_proxy_account' extended stored procedure, but each time get the following error:
'Error executing extended stored procedure: Specified user can not login'
The NT account I'm specifying is valid - I can even log on using it. I have tried giving it Domain Admins/Local Admins - you name it. The password is correct, but this error keeps coming.
Can anyone help? I've actually browsed through the internet and noticed other people have had the same problem but no solution appears to have been found, yet.
Regards,
JJayUK
We are running SQL Server 2000 SP2 on Windows 2000 SP1.
I want users other than 'sa' to be able to run the xp_cmdshell extended stored procedure. I gather that, in order to do this I need to specify a valid NT account as a proxy account for the 'xp_cmdshell' to run under.
I've tried this in Enterprise Manager (Jobs/Properties) and by using the 'xp_sqlagent_proxy_account' extended stored procedure, but each time get the following error:
'Error executing extended stored procedure: Specified user can not login'
The NT account I'm specifying is valid - I can even log on using it. I have tried giving it Domain Admins/Local Admins - you name it. The password is correct, but this error keeps coming.
Can anyone help? I've actually browsed through the internet and noticed other people have had the same problem but no solution appears to have been found, yet.
Regards,
JJayUK