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.

Crystal ReportsASP.NETC#

Avatar of undefined
Last Comment
nkhelashvili

8/22/2022 - Mon
nkhelashvili

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

Yes, asp.net is connecting to the same database with the same login credentials, sql server managements studio is able to connect too.
nkhelashvili

This is the best money I have ever spent. I cannot not tell you how many times these folks have saved my bacon. I learn so much from the contributors.
rwheeler23
ASKER
Axarydax

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
Axarydax

Log in or sign up to see answer
Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform
Sign up - Free for 7 days
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
See how we're fighting big data
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
ask a question
nkhelashvili

Congrats :)