locked
Password did not match that for the login provided RRS feed

  • Question

  • User-196219249 posted

    Hello,

    I have researched and researched but yet found a solution regarding error message “18456, Severity: 14, State: 8”, reason: password did not match that for the login provided.

    Basically I have developed an asp.net website to host crystal reports with a login and roll membership. It is a pretty simple website that will allow management and other employees to view certain reports for the company depending on their roll.

    I’m using 4.0 Framework with SAP Crystal Reports in VS 2010. My ODBC connection “both unit and system testing” is a 32 bit driver set to SQL server authentication using a login ID and password. The website is hosted on Windows Server 2008 R2 Standard using IIS 7.5.

    The website is configured on IIS 7.5 to use the 4.0 Framework and its pipeline mode to use “Classic”. My site’s application pool is set on “NetworkService”.

    The username is NOT a domain name, but a username we created on SQL Server “SQL Server 2008 R2” for accessing specific databases.  We have used this username in many websites currently in production and had no issues with it.

    My database log indicates “Login failed for user 'xxxxxx'. Reason: Password did not match that for the login provided. [CLIENT: 999.99.9.999]. Error: 18456, Severity: 14, State: 8.

    The password is not wrong because we are using this username with the same password in other websites that work perfectly. I don’t know if this is a Crystal Reports issue or a webserver issue.

    Please let me know what I can do to fix this annoying problem.

    Tuesday, August 4, 2015 12:35 PM

All replies

  • User-1716253493 posted

    xyz789

    I don’t know if this is a Crystal Reports issue or a webserver issue.

    Simply create copy the page, remove the crystal report from one of them. See what happend with both pages.

    Tuesday, August 4, 2015 9:34 PM
  • User-196219249 posted

    Thank you for responding back oned_gk.

    I guess I need to be more specific about my questioning regarding Crystal Reports or the Webserver.

    The roll membership is working perfectly. I can login and see the reports with data, but the problem is when I change the values of my parameters for the report. For an example if I want to see the expense report for the month of April, it will say “Error – Database logon failed” within the Crystal Report Viewer object. My web page is still intact therefore it never redirects me to that ugly aspx error message page.

    The database log indicates login failed for user ‘MySqlUsername’. Password did not match for the login provided. I know the password is correct due to other program we run using these exact same credentials and that is why I thought there might be a setting within IIS application pool not picking up the right password or a Crystal reports installation mishap.

    Does this explanation make more sense now?

    Wednesday, August 5, 2015 9:36 AM