Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase 12»»

Logon failure: unknown user name or bad password Expand / Collapse
Author
Message
Posted Friday, October 17, 2008 10:05 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Thursday, September 23, 2010 10:33 AM
Points: 3, Visits: 38
Hi, I'm completely lost here... I have a SQL Server Agent job that execute a SSIS package. The same job works perfectly at on SQL server but errored out at the other with the "system error: Logon failure: unknown user name or bad password". As far as I can tell, both are setup the same. Here is my setup:

1. Create a credential AccountName to use the credential of a domain account (domain\AccountName).
2. Create a proxy AccountName that utilize the credential created from step 1.
3. In the "Run As" of the SQL Server Agent job step, use the proxy created from step 2.

When I executed the SQL Server Agent job, it prompted failed at one server with this unknown user name or bad password message. I know for sure that the user exists and the password is correct. It failed "before" executing the package. It acts like the SQL Server Agent Service account is unable to use the security context of the proxy account. As I said, the same job works fine at another server. The problem is I cannot find why. The account is sysadmin at both SQL Servers.

Could someone shed some light? Thank.s
Post #587783
Posted Friday, October 17, 2008 5:57 PM
SSChasing Mays

SSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing Mays

Group: General Forum Members
Last Login: Tuesday, August 13, 2013 9:44 AM
Points: 627, Visits: 509
Hey can you post the exact error that you receive while executing the job.

I used to have the same kind of issue .......it used to say ...teh file cannot be found and XML node an dpassword something.........

One thing make sure that on the server that fails, sql agent ( under which the jobs run) have all the rights that it needs to perform in SSIS.
ALos, make sure all the objects that SSIS is using u have on the server, and also enough permissions to do the work for sql agent.

My case was. one of the objcet was missing, and before runnning the job, it was trying to validate things, and thrwoing errors before executing the ssis.
Other time, sqlagebt had no enough permission to delete and archive files........

this was one of my error and if u look at the error it talks all about something............

Executed as user: ADHCSCINT\sqlagt. Microsoft (R) SQL Server Execute Package Utility Version 9.00.3042.00 for 32-bit Copyright (C) Microsoft Corp 1984-2005. All rights reserved. Started: 4:03:20 PM Error: 2008-10-16 16:03:20.68 Code: 0xC0016016 Source: Description: Failed to decrypt protected XML node "DTS:Password" with error 0x80070002 "The system cannot find the file specified.". You may not be authorized to access this information. This error occurs when there is a cryptographic error. Verify that the correct key is available. End Error Error: 2008-10-16 16:03:28.10 Code: 0xC002F304 Source: Rename and Archive flat file File System Task Description: An error occurred with the following error message: "Access to the path is denied.". End Error DTExec: The package execution returned DTSER_FAILURE (1). Started: 4:03:20 PM Finished: 4:03:28 PM Elapsed: 7.547 seconds. The package execution failed. The step failed.


but the actual solution was to give enough rights to sqlagent to move, rename and delete files.
Post #588047
Posted Sunday, October 19, 2008 5:35 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 1:50 PM
Points: 6,191, Visits: 13,340
if running under a sql agent job as sql agent (i.e. a user other than the user who created the project) this is well known. How does the sql agent run the job sucessfully on the other server?
are you using xml config file, server roles\etc, registry or environment variables?


-----------------------------------------------------------------------------------------------------------

"Ya can't make an omelette without breaking just a few eggs"
Post #588239
Posted Monday, October 20, 2008 8:05 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Thursday, September 23, 2010 10:33 AM
Points: 3, Visits: 38
There was not much message to the error. Here it is:

Unable to start execution of step 1 (reason: Error authenticating proxy SDRGE\svcBOKPosPay, system error: Logon failure: unknown user name or bad password.). The step failed.

If I should look at some other places for messages, please let me know...

This proxy account (SDRGE\svcBOKPosPay) is sysadmin on SQL Server database level. It also belongs to administrators group on the server level. So I don't know what else it might need...

The process is setup basically the same. Same SSIS package, same procedure to create all the steps, etc. The proxy account actually has less privilege on the other server that succeeds as it is not a admistrator group member on the server.

I am completely lost... Only thing I can say is that the setup somwhere along the way is different between the two servers, but I cannot figure out where and what...
Post #588574
Posted Monday, October 20, 2008 8:13 AM
SSChasing Mays

SSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing Mays

Group: General Forum Members
Last Login: Tuesday, August 13, 2013 9:44 AM
Points: 627, Visits: 509
Looks like the issue is Proxcy Account.
I had the same issue for sql agent. My DBA was able to figure out the problem. Though they belong to adminstrator group, there might be some explicit kind of some deny permission. One step you can do if possible is Give all th ehighest level of permission, and slowley test each time by removing few permiisons. Or make both the environment exactly the same...........
Post #588579
Posted Monday, October 20, 2008 8:26 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Thursday, September 23, 2010 10:33 AM
Points: 3, Visits: 38
Um. I am not sure what "Give all th ehighest level of permission".. What else can I give? Thanks.
Post #588587
Posted Wednesday, November 5, 2008 2:38 PM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Thursday, June 14, 2012 3:37 PM
Points: 34, Visits: 110
I am having the same problem.

This syntax runs fine with my other SQL server except for my newly installed SQL server. I check all the permission and they all the same.

EXEC master..xp_cmdshell 'MKDIR Servername\test'

Error:

Logon failure: unknown user name or bad password.

Please help...
Post #597712
Posted Wednesday, January 28, 2009 11:46 PM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Monday, June 8, 2009 4:43 AM
Points: 60, Visits: 149
I am also facing the same issue...but my scenario is little bit funny .....the sql server job is running some few days back perfectly but the same job with the same priveleges without changing any information.........it is not working now ......


am completely lost .......please help me out this problem....


the error am getting is .....



Error authenticating proxy.system error: invalid logon bad username or password
Post #645614
Posted Wednesday, February 11, 2009 1:52 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Thursday, June 13, 2013 2:02 AM
Points: 1, Visits: 50
On the machine where it does not work, you are probably running the SQL Agent as a user which is not the default "Local System Account", and on the machine where it DOES work, you are running Agent as local system, right?

I just fixed this by going back to local system for Agent and running steps with proxies when needed. It seems like the domain service account we used for running Agent is not allowed to impersonate the proxy, but the local system account is.

Probably also solvable by allowing the domain service account to delegate.
Post #654527
Posted Thursday, May 28, 2009 2:46 PM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Tuesday, July 15, 2014 8:47 AM
Points: 206, Visits: 325
Hi Friends,

I got same problem today for one of our job after resetting password of a windows account. This job to run SSIS package was running fine till we changed the password. After resetting the password we got following error:

Unable to start execution of step 2 (reason: Error authenticating proxy REDMOND\***ADMIN, system error: Logon failure: unknown user name or bad password.).

I never used Proxy before. After some googling & trial & error, we tried changing the password of respective 'credential' [Security -> Credential] of this proxy. It worked for us.

Hope my experience helps someone else !!!
Post #725470
« Prev Topic | Next Topic »

Add to briefcase 12»»

Permissions Expand / Collapse