Unable to start execution of step 1 (reason: Error authenticating proxy name. system error: Logon failure: unknown user name or bad password.).  The step failed
I created an SSIS Project in BIDs. The packages are created with domain account and the package protection level is Don’t Save Sensitive. The package work fine on developer server the package is deployed to the QA and the package is executed with a service account that has dbo permission to the database accessed by this packages. A credential and proxy is created for this service account. But this execution failed with this error message: “Unable to start execution of step 1 (reason: Error authenticating proxy name. system error: Logon failure: unknown user name or bad password.). The step failed. Anyone with the idea of how to resolve the issue”. ThanksBI Developer
June 10th, 2011 1:24pm

Looks like the password you entered for the Proxy Account's Credentials is not valid. SQL Server saves that Account and Password and then applies it where appropriate. If the password is NOT the password of the respective account, then things don't work. Has the Account Password changed since you set up the Credentials?Todd C - MSCTS SQL Server 2005 - Please mark posts as answered where appropriate.
Free Windows Admin Tool Kit Click here and download it now
June 10th, 2011 1:43pm

The domain account password used to created the package is different from the service account password used to run the package in QA. How can i give this service account execute right to the package?BI Developer
June 10th, 2011 2:04pm

I believe your issue is answered there: http://social.msdn.microsoft.com/forums/en-us/sqlintegrationservices/thread/706F7558-D238-456D-B1FF-5EB627F0A513 A short excerpt from the link: "set a password for the Credential that is associated with the proxy. To do this, right click on the credential and select properties. Enter and confirm the password for the account"Arthur My Blog
Free Windows Admin Tool Kit Click here and download it now
June 12th, 2011 12:08am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics