Share Database using between 2 computers in the same room using network connection?

i have developed a desktop application and the data base supposed to be used by the doctor and the nurse in the same room but from 2 different computers , i want to share the data base between them without any net connections to give the doctor the ability to see any changes the nurse do in the data base using the Application the database is made using MSSQL server 2005开发者_如何学Go and Visual Studio 2008 C# this is the first time and i donknow how to make it works

A database is supposed to be a shared resource. A network connection to the database from both computers will be required.

When you connect to the database server, the connection string you provide include a server name. This must be the network name of the server.