Click here to Skip to main content
15,068,929 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
I have an simple application with database as sqlserver I can deploy and create setup and install it works fine in my machine but it doesn't work in another machine can any one guide me to connection and deploy about windows app and sql server.
Updated 19-Jun-13 0:49am

You need your user to deploy SQL Server, then you need to set up the connection string in your app, and then you need to run SQL to create or attach the DB from there. Using a compact DB that doesn't require a server, like SQLite, is much easier.
Install SQL Server In Your Client PC else if other pc is in the same network, then
give the proper connection string to connect with your server,
Else use some other db like MS ACCESS which is not needed to Server as like Mr. Cristian said..
For accessing the database provide the IP address with port number of your sql configuration server and provide username and password of your sql server created user into your connection string before publish you application then you never have to change the location of your databse.

It is very easy procedure to publish window based application with database. Just Right Click on your project as you see in solution explorer -> Click on Publish -> Select your location where you wants be save published project -> Click on Next -> and at end Click on Finish button. After that you can get whole the publish file of your project over the given location.
There might be some license factor if you are using this for commercial purpose.
Check for 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