SQL Server无法连接127.0.0.1

【问题】

连接报错：

An exception of type System.Data.SqlClient.SqlException was thrown.

Additional exception information: A network-related or instance-specific error occurred while establishing a connection to SQL Server.

The server was not found or was not accessible

【解决办法】

1、打开sqlserver服务管理器，开启TCP/IP连接

2、设置TCP/IP中属性的"IP ALL"的端口为1433

3、重启SQL服务就可以用127.0.0.1登录上了