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.
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.
Member
87 Points
255 Posts
Password did not match that for the login provided
Aug 04, 2015 12:35 PM|xyz789|LINK
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.
ODBCRDOODBCADO;IIS7.5;ApplicationPool;web.config
All-Star
52663 Points
15716 Posts
Re: Password did not match that for the login provided
Aug 04, 2015 09:34 PM|oned_gk|LINK
Simply create copy the page, remove the crystal report from one of them. See what happend with both pages.
ODBCRDOODBCADO;IIS7.5;ApplicationPool;web.config
Suwandi - Non Graduate Programmer
Member
87 Points
255 Posts
Re: Password did not match that for the login provided
Aug 05, 2015 09:36 AM|xyz789|LINK
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?
ODBCRDOODBCADO;IIS7.5;ApplicationPool;web.config