Q:

How to Access Database hosted on localhost sql server 2008r2 by another computer in LAN

I created a windows form application in which I used an SQL server database.  
It is working fine on my computer.  Now I want to run this application on another computer that is connected with LAN with my computer.  
The problem is both application must share the same database.  I don't want to host my database online. 
Please tell me how to access the same database from different computers by using LAN or another technique. 

A:

You will have to set up the SQL server to allow access from within the LAN. 
You may also have to set up the firewall on your server to allow access to the SQL server port(s), usually 1433 1434 for MS SQL server. 
Then point your application on the client machines to the server's IP address within your lan.  Usually something like 192.168.xxx.xxx

