Accessing sql server 2008 database through LAN

this very common question and its solution is very simple you have to add the IP address of that server in your connection string. for example sqlconnection con = new sqlconnection("data source=" 10.1.137.111\sqlserver;initial catlog=SMSsoftware;user id=sa;password=khan@123")

u can browse system using server name and connect using sql server authentication...