I have a simple .net windows form which inserts user input into sql database. Now i want to run sql server only on one system and connect the other three systems to the main system on which sql is installed and then run the application on all the three client machines. From all the 3 client machines the data (user input) would be inserted into the sql database?
Please guide me how to deploy this? I am a beginner in SQL. So, please if anybody can , then do mention the urls of websites开发者_Go百科 also where i can find more information about this task.
i guess, do i have to make an exe file of my windows form and install it on all client machines and server as well? after that how do i connect the client machines with the sql database on the server machine?
There are two parts to it.
Design
- Your SQL Server will be installed on a single machine. This machine should be accessible via the other machines.
- Your application (Windows/Web) will use a connection string to connect to the SQL Server
Implementation - You can create an application (Windows/Web) and deploy it to all client machines. In the application settings, you can mention the SQL Server instance/credentials as per the connection string.
精彩评论