Click here to Skip to main content
Rate this: bad
good
Please Sign up or sign in to vote.
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 27-Feb-13 20:09pm
Rate this: bad
good
Please Sign up or sign in to vote.

Solution 2

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.
  Permalink  
Rate this: bad
good
Please Sign up or sign in to vote.

Solution 3

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.
  Permalink  
Rate this: bad
good
Please Sign up or sign in to vote.

Solution 4

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
  Permalink  
Rate this: bad
good
Please Sign up or sign in to vote.

Solution 1

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.
  Permalink  
Comments
Dinesh92 at 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)

  Print Answers RSS
0 OriginalGriff 587
1 Sergey Alexandrovich Kryukov 479
2 Maciej Los 305
3 Mathew Soji 195
4 Richard MacCutchan 145
0 OriginalGriff 7,356
1 Sergey Alexandrovich Kryukov 6,712
2 DamithSL 5,461
3 Manas Bhardwaj 4,916
4 Maciej Los 4,475


Advertise | Privacy | Mobile
Web01 | 2.8.1411023.1 | Last Updated 29 Apr 2013
Copyright © CodeProject, 1999-2014
All Rights Reserved. Terms of Service
Layout: fixed | fluid

CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100