How to Set remote connection in SQL [Reference]

SQL server 2005 remote connection configuration TCP / ip property.
surface area configuration -- database engine --> remote connections ---> using TCP/It

SQL Server peripheral application configurator-service and connection peripheral configuration- database englie-remote connection-enabled (TCP for remote connection / ip and named pipes)
SQL Server Configuration Manager-SQL2005 network configuration-Enable TCP / ip and named pipes

--Bytes ---------------------------------------------------------------------------------------
Generally, follow the preceding steps.

For other instructions, see:

Sqlserver2005 (express edition), in order to facilitate management, you also need to go to the next manage manager, Microsoft's official website has
After the manage manager is installed Program To connect to sqlserver2005, the following points should be noted.
1 To enable the sql2005 remote connection function, follow these steps,

Configuration tools -> SQL
Server peripheral application Configurator -> Service and connected peripheral application Configurator -> Open the database engine under the MSSQLServer Node
Node. Select "remote connection" first. Next, we recommend that you select "use TCP at the same time. / IP and named pipes ". After confirming, restart the database service.
2 . Change the login setting to SQL Server. And Windows authentication is selected at the same time. The specific settings are as follows:

Manage Manager -> Windows
Authentication (first entry in Windows ), -> Select your data server in object Resource Manager -- Right-click> owner
Sex > Security > SQL Server And Windows authentication is selected at the same time.
3 : Set a user name and password for SQL Server as follows:
Manage Manager -> Windows Authentication > New Query > Sp_password Null , ' Sa123456 ' , ' SA '
In this way, a user with the username SA and password sa123456 is set. The next time you log on, you can use the SQL Server method,
The user name is SA and the password is sa123456.
4 : After completing the preceding three steps, you can write the connection string to the database,
(Server = . \ Sqlexpress; uid = SA; pwd = Sa123456; Database = Master ";

For other versions, perform the following settings:

Program-Microsoft SQL Server 2005 -Configuration tool-SQL Server peripheral application configurator-service and connected peripheral application configurator-
1 , MSSQLServer (Instance name )- Database Engine-remote connection-(set options)
Options below
2 , SQL Server Browser-Service (only local access when stopped)
3 Program-Microsoft SQL Server 2005 -Configuration tool-SQL Server Configuration Manager-network connection protocol - Select the protocol for the instance-enable (shard memory, named pipes, TCP/IP)
Note: The SQL Server Browser program runs on the server as a service. The SQL Server Browser listens for incoming requests to Microsoft SQL Server resources,
And provides information about the SQL server instance installed on the computer.
The SQL Server Browser can be used to perform the following three operations:
Browse available servers
Connect to the correct server instance
Connect to the dedicated administrator connection (DAC) Endpoint
The SQL Server Browser Service (sqlbrowser) provides the Instance name and version number for each instance of the database engine and SSAs.
With Microsoft SQL Server 2005 Install together,
For earlier versions of SQL server running on the computer (from Microsoft SQL Server 7.0 To provide this service.