SQL Server 2005 Express TCP/IP remote access settings sql Server 2005 Express is a low-end solution for Microsoft databases and is widely used in the development of small applications and Web applications. However, the SQL Server 2005 Exrpress only allows native access under the default installation, so it is necessary to enable the network Access feature, and now let me briefly introduce you. 1. Confirm that SQL Server 2005 Express and database service have been successfully installed. After the installation is complete, you can view the database service and other configuration information by using the tools that are installed with SQL Server 2005 Express SQL Server Config Manager. shows that the database service is enabled. 2. View SQL Server Express 2005 Network configuration information (SQL Server 2005 networks configuration――> protocols for SQLEXPRESS). By default, the status of Named Pipes and TCP/IP in the list on the right is disable, which is not enabled. Right click on these two items, in the pop-up menu, select Enable both protocols, such as. 3, Double-click on the TCP/IP protocol to pop up the dialog box. Modify the dialog box protocol the "Listen All" entry in the property page is set to "no". In the IP Address property page, modify the properties of the IP addresses that you want the database service to listen on, modify the Enabled property to Yes, modify the TCP Dynamic ports property to NULL, the TCP port entry is empty under the default installation, and now modify the port 1433 to listen to us. The modified state is as shown in;       IP1: Native Ipport:1433 ipall:127.0.0.1port:1433 4, startup management tool The admin interface is shown below: Select Surface area Configuration for Services and Connection option 5, Modify the remote connection property of data engine, as shown in the modified properties:   6, After completing the above operation, the database service needs to be restarted for the modification to take effect, and the operation can complete the restart of the database service. After 7, restart, You can enter the following command in the command Window "netstat -na" command to view all the ports that the server listens to, if the 1433 port of our device is listening, we enable the SQL Server 2005 Express network operation successfully. Of course, you can also use the Telnet command to verify that the database operation is successful. Use the netstat command operation as shown in.
SQL Server 2005 Express TCP/IP remote access settings
