Click here to Skip to main content
15,903,203 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
Hello developers,

I am going to develop an LAN Server based application in which -

1. Application will be installed on client PC which will connected to LAN.
2. Database will be in LAN Server computer.
3. I will use SQL Server 2008
4. Front-end will be in C# or VB

Problem -

1. How to configure sql server to connect through LAN?
2. What will be the connection string?

Please give me proper solution.

Thanks in advance

  1. You need to configure SQL Server to allow remote access: How to configure SQL Server 2005 to allow remote connections[^]
  2. The best resource for how-tos on connections strings for me is SQL Server connection strings[^]

— Manfred
Share this answer
Dear Friend,

You can give connection string like this:-

Data Source=computer-name;
Initial Catalog=abcd;
Persist Security Info=True;
User ID=sa;

You can give server computer name as data source,
database name as initial catalog,
you can give user ID and password for connecting to the database.

hope you understood.

with regards,

Share this answer

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900