Microsoft SQL Server Long Express Remote access settings detailed, 100% successful article _ Practical tips

Overview

Microsoft SQL Server Express Edition is a low-end solution for Microsoft databases, is free, and can be released free of charge, and its database capabilities are sufficient for general enterprise applications. However, the default installation allows only local access, not remote access. In order to solve this problem, there are many articles on the Internet, but not all, if you do, most of them have only completed a part of the function, but not completely successful. I checked a lot of information, several times want to give up, and finally successfully configured, now write this paper detailed description of SQL Server, Express Edition Enable network access for your reference.

Preparation: 1, install SQL Server Edition Express and enable database services, 2, install SQL Server Management Studio Express.

Operation Steps

First, configure remote Access Protocol (TCP) and enable ports:

For detailed instructions, please refer to Xiang Yilong'sSQL Server Express remote Access settings method , which is written in very detail and with graphics and text. Thank Xiang Yilong friends.

Added: 1, in the above "3rd" to enable the TCP protocol, in addition to enabling the server's extranet IP, but also enable 127.0.0.1 and Ipall ports are set up. 2, is also the above "3rd step" to enable the TCP protocol, it is recommended to set a static port, three to set the port to be unified.

Second, enable SQL Server and Windows authentication mode:

1. Open SQL Server Management Studio Express (Note that when writing this article, I used the SQL Server Enterprise version of the manager, the operation is the same). Server name (Nbfuqin in figure) right, select Properties (as shown below), open the Server Properties dialog box.

2. In the Server Properties dialog box, select Select Page/security, choose Server Authentication as SQL Server and Windows Authentication mode, and click OK to restart the database service. As shown in the following figure.

Add SQL Server logins or Open SA remote access:

The default SA for SQL Server Edition Express is not allowed to log on. So you can either turn on the sa login or create a new login name.

1. New Login Name: Open SQL Server Management Studio Express and select server name/security/login name, right-click to select New login, as shown in the following figure. Open the Sign-in name-New dialog box.

In the Login name-New dialog box, select the General tab, and then create a new login name, and be aware thatSQL Server authentication is selected. As shown in the following figure.

Select the Status tab to ensure that login is granted in the enabled state, whether connection to the database engine is allowed, or not.

2. Enable SA: In login, select the SA, right-click Properties, set the password in general, enable log on in status, and grant "Allow connections to the database engine."

Add

1. Unlike other versions of SQL Server 2005 (the server is "server IP or name"), the SQL Server Edition Express-logged server is "server ip\sqlexpress,1433"　　(The server name is also available instead of IP), and the following 1433 is the port that is enabled for the first step. 2, if it is XP as a server, but also in the firewall to open the corresponding port (of course, you can also shut down the firewall), such as 1433 ports.

Conclusion

The above is the entire configuration process of detailed procedures, welcome everyone to exchange. I would also like to thank my brother Zhao.