Geek Answers Handbook

How to connect a database on a SQL Server 2008 LAN

I want to connect my db to SQL Server 2008 over a local network. I want to place it on one computer on the local network so that any computer on the network can access it, what should I do, please give me the right steps.

+5
source share
2 answers

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

Clients will be computers accessing this SQL Server using client software (may be SQL Server Management Studio, an application for web applications and forms, an Excel worksheet, etc.).

SQL Server, . IP- SQL Server. .

= _\_
. .

: , SQL Server, (SSMS) SQL Server.

: .

. SQL Server , , .

+7
  • SQL Server 2008 ( SQLServer)
  • ( )
  • .

SQL Server - .NET, :

server=SQLServer;database=YourDatabase;User ID=YourUser;Pwd=top$Secret
+4

More articles:


All Articles