Remote access and 1433 port opening must be provided.

Please refer to port 1433 of. Sql Server 2005 was opened and connected remotely in 2005.

How to open the 1433 port of sql server 2005

Configuration tool->; Sql Server configuration manager->; Protocol of MSSQLSERVER

Check whether the TCP/IP protocol has been started. If yes, right-click the menu, select "IP address" in the paging menu, and set the TCP port in "IP 1" and "IP2" to 1433.

Change "Enabled" to "Yes"

Configuration tool->; Sql Server configuration manager->; SQL Native Client configuration->; Client protocol->; transmission control protocol (TCP)

Select Properties in the TCP/IP right-click menu, and confirm that Default Port is 1433 and Enable is Yes.

SQL Server 2005 Remote Connection

Configure TCP/IP properties.

Surface area configuration->; Database engine->; Remote connection-> Use TCP/IT

SQL Server Surface Area Configuration-Service and Connection Peripheral Configuration-Database English-Remote Connection-Enabled (TCP/IP and Named Pipes for Remote Connection)

SQL Server Configuration Manager -SQL 2005 Network Configuration-Enable TCP/IP and Named Pipes

-

Usually press the button above.

For additional instructions, see the following:

Sqlserver2005 (Express Edition), in order to facilitate management, you need to go to the next manage Manager. Microsoft's official website has

After installing the Manager, connect sqlserver2005 in the program. The following points should be noted.

1. Open the remote connection function of sql2005 as follows.

Configuration tool->; Structured query language

Server peripheral application configuration device->; Surface area configurator for services and connections->; Open the database engine under the MSSQLSERVER node.

Node, select "Remote Connection" first, and then suggest selecting "Using TCP/IP and Named Pipes at the same time". After confirmation, just restart the database service.

2. The login settings are changed to SQL Server and Windows authentication, and the specific settings are as follows:

Management manager->; window

Authentication (first entry through windows),-> Select your data server in Object Explorer-right click >; belong to

Sex > security > select both SQL Server and Windows authentication mode.

3. Set the user name and password in Sql server mode, as follows:

Management manager->; Windows authentication & gt new query & gtsp_password is empty,' sa 123456',' sa'

In this way, a user with user name sa and password sa 123456 is established. The next time you log in, you can use Sql server.

The user with user name sa and password sa 123456 has entered the database.

4. After completing the above three steps, you can write the connection string and enter the database smoothly.

(Server =. \ \ sqlexpressuid = sapwd = sa 123456； database = master "；

For other versions, make the following settings

Program —Microsoft SQL Server 2005— Configuration Tools —SQL Server Surface Area Configurator—Surface Area Configurator for Services and Connections—

1, MSSQLserver (instance name)-database engine-remote connection-(set options)

The following options

2.SQL Server browser-service (local access only when stopped)

3. Program —Microsoft SQL Server 2005— Configuration Tool —SQL Server Configuration Manager —clnp— Select the protocol corresponding to the instance—Enable (partitioned memory, named pipe, TCP\IP).

Note: The SQL Server browser program runs as a service on the server. The SQL Server browser listens for incoming requests for Microsoft SQL Server resources.

It also provides information about the instance of SQL Server installed on the computer.

SQL Server Browser can be used to perform the following three operations:

Browse available servers

Connect to the correct server instance

Connect to a dedicated administrator connection (DAC) endpoint

The SQL Server Browser service (sqlbrowser) provides an instance name and version number for each instance of the database engine and SSAS.

SQL Server Browser is installed with Microsoft SQL Server 2005.

This service is provided for earlier versions of SQL Server running on this computer (starting from Microsoft SQL Server 7.0).