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 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?
Also, i will run windows xp on all the machines , on client as well as server.
will there be any problem with this ?
when is windows server2003 used then?