How to retrieve data using LAN from one system to another system using ASP.Net

keep your SQL server Database in one Computer and in your connectionString

<add name="ConString" connectionString="Data Source=IPAddress;Initial Catalog=DbName;User ID=userID;Password=Password" />

Now you can accress the Data store in one computer to other.