Post reply

Login Failed: Logon failure: unknown user name or bad password. (Exception from HRESULT: 0x8007052E)

  • June 7, 2006 at 7:58 am

    #171078

    Hi. i get this error when running a report from within SQL 2005 RS (with SP1) - it's strange as it's only just started happening, when everything used to work fine.

    Any ideas on a fix for this?

    Thanks in advance,

    David

  • June 7, 2006 at 8:07 am

    #642274

    Check that your login is not locked, or expired.

    Also check that the password for the service matches the domain password.

    Did domain passwords for service accounts change recently?

     

  • June 7, 2006 at 8:12 am

    #642277

    Hi. I've checked the Execution Account from within Report Services Configuration, and the username and password matches the UID in Active Directory.

    Also, the reports are being run against an Oracle DB, so the when browsing to the Data Source through HTTP, the username can not be \username. Oddly enough though, it I try to retype the password, and then hit Apply, it says that the password is invalid? I know this is not true, as I'm running the report from within VS2005 on my laptop, against the same data set and it works fine. Only when I deploy to the server and then try and run it from there do I get this error.

    Does this make sense?

  • June 7, 2006 at 8:50 am

    #642294

    Found it on another forum.... I just disabled the Execution Account from Reporting Services Configuration and it all worked fine.

    Thanks for your help anyway.

    David

  • September 13, 2007 at 12:48 pm

    #733594

    Thank you so much. I had the same issue and resolved it by dis-abling the execution account.

    Razi, M.
    http://questivity.com/it-training.html

  • November 6, 2008 at 3:47 pm

    #895263

    Hi can anyone please help me.... I have the same error:

    when I run this query:

    User Server01

    EXEC master..xp_cmdshell 'MKDIR \\Server02\FolderName'

    it retuned me this error:

    Logon failure: unknown user name or bad password.

    if I run this command in command prompt in server01

    MKDIR \\ServerName\FolderName

    It goes fine...

    Just in SQL returned error...

    but if I use this instead:

    Use Server02

    EXEC master..xp_cmdshell 'MKDIR \\Server01\FolderName'

    it also works fine.

    It just server01 can't access any of my server using SQL.

    Please help me. I been dealing with this for a week now.

    Thanks!

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply