SQL Express Installation Problem While Deploy .NET Poject
-
Hi All I have developed an application in which I use SQL Express 2005 All of my reports in the application are linked to database via instance name [MachineName]\OPMS Now I want his SQL Express 2005, so that while deployment of the application, SQL Express 2005 create an instance name "OPMS" instead of SQLExpress which is infact default instance name. Can any one please help me because I am in trouble Regards Muhammad Sharjeel Ahsan
-
Hi All I have developed an application in which I use SQL Express 2005 All of my reports in the application are linked to database via instance name [MachineName]\OPMS Now I want his SQL Express 2005, so that while deployment of the application, SQL Express 2005 create an instance name "OPMS" instead of SQLExpress which is infact default instance name. Can any one please help me because I am in trouble Regards Muhammad Sharjeel Ahsan
First of all, do not hard code connection string. Secondly, you can install another version of SQLExpress with a different instance name.
Farhan Noor Qureshi
-
First of all, do not hard code connection string. Secondly, you can install another version of SQLExpress with a different instance name.
Farhan Noor Qureshi
The connection string is no hard coded, I have placed connection string in App.Config so that user may change that string after deployment, but the problem is that Crystal report hard code the instance name of database E.g. .\SQL2005 After deployment and during running of the application, crytal report search for that "SQL2005" So I want the SQL Express to have a user defined instance name which I first assign to All of report (under push or pull process) and then define that insance name to somewhere so that during installation of my application, tha instance name created while insallation of SQL Express, Please note that default insance name is SQLExpress but I do not need that name at all. More over, if I install SQL Express directly then it asks for instance name but while installing as a pre requisite, it create SQLExpress. Please reply asap Regards