Click here to Skip to main content
15,892,059 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
Hello,
I have created an application based on sql server...in which username and password are required to access sql server database and tables...
but i want to install this application on another system where no sql srever is present (OR server username and password are different)...so if i install this app..it would definately give an error regarding connection problem...
how can i avoid this problem....plz help me.....
Posted

Sorry for my late reply on this.

To create a setup for your application, you need to add a new project to your solution of the type Set up and Deployment. Under Visual studio installer we can create new set up project.
Use the below link,
http://aspalliance.com/622_StepbyStep_Process_of_Creating_a_Setup_and_Deployment_Project[^]

I remember on vs2012 we don't have this feature anymore, but version less that 2012 we do have.
 
Share this answer
 
Hi Dinesh

You can visit this url and i hope , your problem will be solved from there.http://www.aspmemo.net/2012/10/creating-and-restoring-sql-server-2008.html[^]
Thanks.
 
Share this answer
 
how to create set up

and for the sqlserver proble use sqlserverce compact edition in your code you just have to mention connection string in your code once so there will not be any eror of path for con string or server name
here is small demonstration
click here
 
Share this answer
 
If I understand your problem, you are installing your app on a separate machine which is not having SQL server database on it. And you want that application to still connect the DB.

Yes, you can do that if at least the machine having the DB is on same domain where your application is present. Else you can restore the database on the same machine where you have the application.
 
Share this answer
 
Comments
[no name] 4-Mar-13 5:53am    
tell me the solution bro...how could i achieve this...???

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900