SQL Server 2008 Express Remote Access settings method

The Visual Studio Express and SQL Server Express series are the foundation for Free Program development environments and SQL databases, bringing the gospel to a wide range of learning enthusiasts, as well as using them for simpler system development without worrying about copyright issues. Where the SQL Server Express version by default is to turn off network access, but it is not unsupported, but also can support some network features, for the general system, its network features enough, I would like to tell you about SQL Server 2008 Express the steps to open the network access feature.

1. Open SQL Configuration Manager from the Start menu, as shown in figure.

2. Select the SQL Network Configuration->sqlexpress protocol, select the TCP/IP on the right. This protocol defaults to disabled state, right click to select Enable, set it to Enabled.

3. Right-click on TCP/IP, select Properties, and open the Properties page for TCP/IP. All of the Protocols in the Protocol tab are set to "no" by the original "yes". Then select the IP Address tab, which lists all of the IP addresses for this computer, set the enabled and active for IP addresses that can be accessed remotely to set to Yes, and set the TCP port number to 1433 to tcp/ The IP dynamic port is set to 0. As shown in the figure.

4. Restarting the SQL service allows you to remotely access the database.