SQL Server 2008 Express how to turn on remote access _mssql2008

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. SQL SERVER Express version of which the default is to turn off network access, but it is not unsupported, but also can support some network functions, for the general system, its network function is sufficient.

Here's a little bit about the SQL SERVER 2008 Express Open Network access feature

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

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

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.

The above is to tell you how to open SQL Server 2008 Express Remote Access, I hope to help you learn.