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 |
|
ranvir_2k
Posting Yak Master
180 Posts |
 Posted - 2014-10-07 : 06:10:03
|
| I'm trying to run a job that kicks off a batch file.I need to use a proxy to do this (for security reasons).However the job keeps on failing with the following error:Error authenticating proxy MyServer\myuser, system error: ConnGetProxyPasswordThe account being used is a local account as opposed to a domain account.The password for the credential is correct, and I have granted the proxy CmdExec permissions. The account has local admin rights on the server and sysadmin rights in SQL Server.Even if I run a simple command like ipconfig, it doesn't work.Does anyone have any idea what the issue could be? |
|
|
ranvir_2k
Posting Yak Master
180 Posts |
Posted - 2014-10-07 : 06:59:03
|
| Any advice? I can't find much on the net about this. |
 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2014-10-07 : 11:56:34
|
| Try RDP'ing to the server and logging in with those credentials. There perhaps is a prompt appearing at login time.Tara KizerSQL Server MVP since 2007http://weblogs.sqlteam.com/tarad/ |
|
|
|
ranvir_2k
Posting Yak Master
180 Posts |
Posted - 2014-10-08 : 07:23:32
|
| I fixed the issue. I had to add the SQL Server Agent service account in the 'Replace a process level token' in Local policies. |
|
|
|
|
|
|
SQL Server Proxy not working