How to connect database over local area network SQL Server 2008

Question

I want to connect my db on SQL Server 2008 over local area network I want to put it on one computer on the LAN so any computer on the network can access it what should I do please give me correct steps

Answer 1

In a Client-Server scenario, you will have the SQL Server installed on your server machine.

Clients will be the computers accessing that SQL Server using a client software (can be SQL Server Management Studio, web/forms application, Excel worksheet, etc).

Each of the client will provide you a way of making a connection to the SQL Server Instance running on the server. From server you will need IP Address or Servername along with SQL Server Instance name. They both combined form host name.

Data Source = ServerName\InstanceName
Note: Instance name not required for default instance.

User name: You need to add user from domain or a sql server authenticated user under security tab (SSMS) on the SQL Server.

Password: Corresponding password.

Note: Once you add a user to SQL Server Instance, do not forget to attach the user to databases you want the user to access and provide appropriate role(s).