Accessing SQL database, stored in my computer, from other computers using LAN

[DharmendraPlan]

I have a windows application coded in C# using visual studio 2010 Express. My application accesses an SQL database stored in my computer.

What I want to do is to use my application using different computers in our office but still accessing the same database in my computer using LAN.

Is it possible? If yes, what should I do?

Specifically,

What changes should I make in my C# codes that connects to a database?
How should I set-up the computers in our office such that they can connect to the database in my computer through LAN?

[computerfox]

Normally, I would build an API on the central machine. This makes access to the database much safer and easier for the application.

Other than an API, databases use domain/IP and ports. You can try adding an option to give the domain/IP address of the other machine as well as the database credentials.

What exactly are you doing with the application? Are you simply viewing and updating the data or are you doing something unique? There might already be a Windows application that does what you're trying to do already.

Hope that helps.