Link to home
Start Free TrialLog in
Avatar of Axarydax
AxarydaxFlag for Slovakia

asked on

Crystal Reports always showing login prompt

Hello Experts,

I have a problem with Crystal Reports. It always shows a dialog that prompts for database login and password

We are using SQL Server 2005 Express as .\sqlexpress, there is a database with some login and password.

We have a report with no subreports and we're trying to display it in asp.net CrystalReportViewer (or in WinForms application too). Everything works on our developer and production machines. On this new demonstration machine it doesn't.

We set database login in code, the database login works when tried from sql management studio or asp.net.

On this demo machine, when I load web application or windows application with report, it shows screen prompting for database login/password. When I fill it out and click OK, it shows the same screen. It doesn't matter if I enter correct or incorrect credentials.

I am really at my wit's end and can't figure out what could be wrong.
I repeat, everything works fine on all other machines. I can't reproduce this error on any other machine.

Avatar of nkhelashvili
nkhelashvili

Are you sure that connection works on demo machine?  Have you checked it from sqlcmd?
Avatar of Axarydax

ASKER

Yes, asp.net is connecting to the same database with the same login credentials, sql server managements studio is able to connect too.
No, that does not help - my problem is that I know the login/password is correct, I have verified it with other tools but Crystal Reports still can't connect. It seems to me that somehow Crystal Reports engine cannot connect to sql server, because it acts the same with correct or incorrect login.
ASKER CERTIFIED SOLUTION
Avatar of Axarydax
Axarydax
Flag of Slovakia image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Congrats :)