Skip to Content
0

Crystal Report - SQL SERVER ERROR while opening report for first time

Mar 02, 2017 at 11:13 PM

84

avatar image
Former Member

Getting this error when ever I try to preview report for first time in Crystal Report. Same thing is happening when I try to open report from Java Application. I am passing correct password. Logon Error: 18456, Severity: 14, State: 8. Login failed for user '@@@@@@'. Reason: Password did not match that for the login provided.

This error is for password mismatch, but the report still opens after giving this error.

Not able to find the reason why this error is coming. Is this the problem of crystal report?

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

2 Answers

Don Williams
Mar 02, 2017 at 11:16 PM
-1

You may have saved the report with data. Click on File and uncheck the Saved Data... option.

Try again now, if it prompts for log on info and that fails you either do not have permission to access the tables being used or your password has expired.

Check with your DBA to test your account.

Don

Show 3 Share
10 |10000 characters needed characters left characters exceeded
Former Member

Report is not saved with data. This problem is coming when I am using sub-reports

Error: 18456, Severity: 14, State: 8. Logon Login failed for user ''.

Reason: Password did not match that for the login provided.

If I remove the sub-report error dose not come. I have checked the sub-report data connection it is correct.

0

How about your language settings? This got me once, default keyboard was set to French so it failed every time.

If you hit the refresh button and enter the info does that work?

CRD does not keep passwords in the RPT files.

What version of SQL are you using and which client?

Don

0
Former Member

Language is set to English. I am using Microsoft SQL server 2014.

0
Don Williams
Mar 15, 2017 at 03:20 PM
0

Try opening CR Designer and log onto the DB first, then open the report and preview.

If it prompts for log on info something is not correct.

Share
10 |10000 characters needed characters left characters exceeded