Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Database Login window on Client Machine...


I have application running SAP crystal report for vs 2010,

the reports shows fine on development machine (backend: sql server 2008 R2, OS: windows server 2003 R2)

however when i run same application on client server 64 bit machine (backend: sql server 2008 R2, OS windows enterprise server 2008), shows database login windows , i have installed 32 and 64 bit cr runtime also on client server, ran application on both 32 bit and 64 bit mode vis IIS7 and tried patched the server with CRforVS2010 runtime SP1 with no luck...

i am using OLD DB (ADO) while designing crystal reports on development machine....also verified sql native client for sql server 2008 exists on client server....

does CR for 2010 does not support window enterprise server 2008..??? OR i m making mistake somewhere...??.i am stuck in this for 5 days plz help......


here is my code...

  public ReportDocument LoadReport(string reportName)
            rd = new ReportDocument();
            THFConnection.SQLConnection = Global.ConnString;
            rd.FileName = reportName; //Set Report Path

            ConnectionInfo connectionInfo = new ConnectionInfo();
            connectionInfo.ServerName = THFConnection.ConnInfo.ServerName;
            connectionInfo.IntegratedSecurity = THFConnection.ConnInfo.IntegratedSecurity; ;
            connectionInfo.DatabaseName = THFConnection.ConnInfo.DatabaseName;
            connectionInfo.UserID = THFConnection.ConnInfo.UserName;
            connectionInfo.Password = THFConnection.ConnInfo.Password;

            foreach (CrystalDecisions.CrystalReports.Engine.Table mytable in rd.Database.Tables)
                TableLogOnInfo tableLogonInfo = mytable.LogOnInfo;
                tableLogonInfo.ConnectionInfo = connectionInfo;
            foreach (ParameterField pf in rd.ParameterFields)
                if (pf.Name == "@SessionID")
                    rd.SetParameterValue("@SessionID", Global.SessionID);
            return rd;

Former Member

Hi Amit,

You are still using the native client:


Provider=SQLNCLI10 is what it should be using.

You need to update the reports themselves either in the report designer or using the ReplaceConnection function.

Also, I'm not sure if SQL Express has a client or what MS supports so it may be an issue. MS forums may know if it's supported.

Thank you


0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question