January 16, 2012 at 6:55 am
Hi Everyone,
..Firstly, I have to state that I am new to this..
I'm working on sql 2008 r2, trying to set up a proxy account.
This is what I've done thus far :
- set up a credential using a windows domain account
- set up a proxy linking that credential and adding the necessary principals
- I've linked job steps to this new proxy
What else am I missing?
January 16, 2012 at 10:25 pm
helpmewithsql 73993 (1/16/2012)
Hi Everyone,..Firstly, I have to state that I am new to this..
I'm working on sql 2008 r2, trying to set up a proxy account.
This is what I've done thus far :
- set up a credential using a windows domain account
- set up a proxy linking that credential and adding the necessary principals
- I've linked job steps to this new proxy
What else am I missing?
Any error messages?
--Jeff Moden
Change is inevitable... Change for the better is not.
January 16, 2012 at 10:38 pm
Sorry - it says:
Unable to start execution of step 1 (reason: Error authenticating proxy DOMAIN\SQL_Proxy_Username, system error: Logon failure: unknown user name or bad password.). The step failed.
January 16, 2012 at 10:56 pm
January 17, 2012 at 6:15 pm
helpmewithsql 73993 (1/16/2012)
Sorry - it says:Unable to start execution of step 1 (reason: Error authenticating proxy DOMAIN\SQL_Proxy_Username, system error: Logon failure: unknown user name or bad password.). The step failed.
Apologies for the delayed response.
The post that padhis cited has most of the possible answers. For your particular problem, it simply sounds like the CmdShell proxy either wasn't setup correctly or the password for the proxy has been changed on the Windows side of the house.
Go to the link that padhis cited... it covers a whole lot about this in a short period of time with some code examples, to boot.
--Jeff Moden
Change is inevitable... Change for the better is not.
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply