Home Forums SQL Server 2005 Business Intelligence RS SOLUTION - Logon failure: unknown user name or bad password. (Exception from HRESULT: 0x8007052E) RE: RS SOLUTION - Logon failure: unknown user name or bad password. (Exception from HRESULT: 0x8007052E)

  • my knowlege of most of this is limited.

    but would it help to let you know that the SQL server is running SQL2005 on a MS-Server2003 OS and the server is in Cluster configuration.

    i'm not sure where to go on the SQL Server in order to add the credentials.

    i have ReportExecution as the user name & at one time had the proper credentials to get the reports running from the server, until my own username/password changed.

    again, i think i just need to know where on the SQL Server i need to go to add this user/password combination?

    thanks for your help. i've spent way too many hours trying to get over this hump and start becoming productive again.

    Russ Holt