Resolving MSSQL 2008 cannot log on with IP

MSSQL 2008 has an instance installed (I installed the instance by default: SQLEXPRESS) and installed the SQL Server Management Studio tool.

The following configuration support is required in order to be able to log on to 2008 with a (local) or IP address:

Open SQL Server Configuration Manager and configure the following:

1, click on the "SQL Server Services" node

Locate the SQL service that we installed: SQL SERVER (SQLEXPRESS), double-click it to open the Properties Settings dialog box, select the built-in account in the login ID, and drop down to select "Network Service": It means for network services, This allows remote clients to restart the SQL Server service, otherwise the restart service function is limited to this computer.

2. Click the SQL Server Network Configuration node.

Click on the "Instance Name Protocol" (mine is the SQLExpress agreement). Can see my example is supported share Memory, Named pipes, TCP/IP, via these several protocols.

Right-click "TCP/IP" to select Enable. Right-click it to select Properties, in the Properties dialog box, switch to the "IP address" card, you can see "IP1", "IP2" ... "Ipall" These categories of IP-specific settings information. First of all, because we currently do not use the "TCP Dynamic port" feature, so the TCP dynamic port for these types of IP is set to null (if it is 0, the dynamic port feature is enabled). And because I'm going to set the SQLExpress instance the port that provides the service out to 1433 (consistent with the default service connection port number of the SQL2000), you need to set their TCP port to 1433 for all types of IP ( In fact, just to the Ipall TCP port number set to 1433, the other types are empty, the key is this, hey didn't look carefully before, here the default is 4133. Then the various types of IP "active" and "enabled" are set to Yes. Click "OK" to save the configuration.

3. Click on the "SQL Native client 10.0 Configuration" node (if not, your software may be installed with problems, or there is no client tool installed: SQL Server Management Studio).

Click on "Client protocol" to find "TCP/IP", double-click it to open the Properties dialog box, set "Default port" to 1433 (as long as the configured port number is consistent), set "Enabled" to "yes". Click OK to save the configuration.

4, restart SQLExpress instance.

Directly in the MS-DOS window, netstat-a see if there are 1433 ports open, you know the success is gone, the following further test.