Crystal Report asking for DB login
Posted on 2015-01-24
I am using Visual Studio 2008 with Crystal Report engine provided with VS.
I create couple of reports that display properly in the crystalreportviewer on my development machine.
But, when I publish my site to the production server the report won't open and the system ask for the DB username and password login.
On my development machine I am using window integrated security while on the production server I am using "sa" login to connect to the DB.
I added the following code lines to my code, but the report is still asking for the DB login:
cryRpt.SetDatabaseLogon("sa", "dbadmin", "Hyper_Server", "myDB")
I need help please!