Crystal reports showing database login window

Dealy

Hello,

I have these reports that running on the development machine but when I try to load them from different machines I get a database login window which does not allow me to select server or database. As a result the reports are failing to load.

So far I tried the following but none of them works.

1. I set the Connection info inside the code on report Load. Here's the code I'm using:

ConnectionInfo myConnectionInfo = new ConnectionInfo();

TableLogOnInfos mytableloginfos = new TableLogOnInfos();

myConnectionInfo.ServerName = "TSQL";

myConnectionInfo.DatabaseName = "DB";

myConnectionInfo.UserID = "user";

myConnectionInfo.Password = "pass";

mytableloginfos = myReportViewer.LogOnInfo;

foreach (TableLogOnInfo myTableLogOnInfo in mytableloginfos)

{

myTableLogOnInfo.ConnectionInfo = myconnectioninfo;

}

2. I've installed SQL Server 2008 express at the other machines (the db is on SQL2008)

3. I've installed Crystal Report Runtime Engine for .NET

Any ideas what am I doing wrong?

Thank you in advance.

4 Replies

Know the answer? Post it — somebody with the same question will find it here.

Dealy11y ago
Thank you again for the links.

I don't know if I'm missing something but I have tried all the steps that the links show already.

What's weird is when I try to load the report, I get a Database Login Window with the following fields: ServerName: "TSQL", DatabaseName:"", UserID:"user", Password:"". The DatabaseName is blank and disabled so I can't add the database name manually. After that I get the error "Logon failed."

I have installed the application on a Windows Server 2008. When I run the application that is installed on the server from the developer's computer I have no problem loading the report (I don't even get the Database Login Window). When I try the same thing from any other computer I get the Database Login Window.
Saroj Kumar Sahu11y ago
Can u please go through the below link and try.
http://www.sdn.sap.com/irj/scn/go/portal/prtroot/docs/library/uuid/d02f7cd3-f18b-2d10-55ad-dab2200f68fc?QuickLink=index&overridelayout=true&53240414858625

https://social.msdn.microsoft.com/Forums/en-US/31e1cb7c-23ef-48b3-b00e-3deb0bc2a02c/crystal-report-login-problem-on-other-machines?forum=vscrystalreports
Dealy11y ago
First of all thank you for your answer, I've tried all the solutions proposed by the links but none of them works for me.

Any other suggestions?
Saroj Kumar Sahu11y ago
Hi,
Please check the below URL for your reference :

http://aspalliance.com/490_Troubleshooting_Database_Login_Errors_using_Crystal_Reports_with_NET.all

http://aspalliance.com/532_Understanding_the_Login_Failed_Error_in_Crystal_Reports.all

http://stackoverflow.com/questions/17799462/how-to-prevent-database-login-window-in-crystal-report