SQL Server does not allow remote connection Solution

General method:

Http://support.microsoft.com/kb/914277/zh-cn

It allows local and external TCP/IP and namepipe connections in the "peripheral environment configuration" to enable SQL Server Web browser, disable Windows Firewall or set sqlserver as an exception in Windows Firewall.

I found that the SQL Server server address can be a domain name, such as www.baidu.com. In particular, if the port of the connected SQL Server server is not 1433 by default, the connection address should be separated by commas (,), and the port number should be written, such as 123.123.123.2, 2000 or www.baidu.com, 2000