Login failure issue with Crystal reports connecting to SQL Server 2005

satishrjay

Hi All,

My application uses "crystal reports" control to integrate some reports that can be viewed from within the application.

I'm getting a login failed (due to bad password SQL State 8) error when I bring up the report from within the application. The report runs fine outside the application with the same username password.

- I've checked several times to make sure that I'm passing the correct username/password from the application.

- All letters in the password are lower case. There is not case-sensitive issue.

- I printed the username and password on a pop-up to see what values are passed , and they are correct.

- A single test page that uses the same version of "Crystal Reports" control , using the same username/password, brings up the same report works fine.

I guess , my question is:

Is there a way to trace the login failure event on the SQL Server side to see what is the value of the password that is being sent by crystal reports control

I'm using Crystal Reports XI with sp2.

SQL Server 2005.

I appreciate the help.

Thanks,
Satish

Madhu K Nair

I don't think you can find out the password being passed by the application. Of course you can get the login name

Madhu

Adam D. Turner

What do you mean..."outside the application "

It sounds like it's using impersonation or windows authentication.

Please post your connection string without the login and password.

Adam

satishrjay

When I say "outside the application", I mean creating a test asp page that passes the hardcoded username and password to the crytal report control, and pull a specified report. This page has nothing to do with the application.

I'm using SQL Server authentication, and the connection string is fine because the application is able to connect to the database. I read the connection string and send the parameters to the crystal report control in the application.

Thanks,

Satish