Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
Author |
Topic |
srinii2005
Starting Member
6 Posts |
Posted - 2009-03-20 : 11:32:31
|
Hello guys,I am trying to execute BCP from SQL Server 2000,but i am getting the foll error.."xp_cmdshell failed to execute because current security context is not sysadmin and proxy acount is not setup correctly. For more information, refer to Book Online, search for topic related to xp_sqlagent_proxy_account."But i have given permission to execute the bulk copy..do i require any other permission as well?can anyone please help me with this? |
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2009-03-20 : 12:07:04
|
have you given the permission to service aount that runs xp_cmdshell? |
|
|
srinii2005
Starting Member
6 Posts |
Posted - 2009-03-20 : 14:10:35
|
What exact permissions needs to be given there...i have given permission only for executin BCP.. |
|
|
|
|
|