Today, I met a friend who needs to use the MSSQL 2008 database to build the program. This client program needs to run an EXE file. When you connect to the database settings, the server fills in 127.0.0.1, and the connection is never successfully connected.
After using localhost, the connection was successful. Indicates that there is a place between the use of localhost and 127.0.0.1 that cannot communicate. Check the local Hosts file found that localhost has been resolved to 127.0.0.1, then the inference problem should be on the MSSQL 2008 itself configuration.
Open SQL Server Configuration Manager and check that TCP/IP discovery is disabled. and opened him up.
Restart the server, log in to the server, and test the server connection. OK, the connection is successful.
Life needs to be more dynamic, and so is work, so many moves will be found. AC qq:2881064157
Program Software Connection Database unable to use 127.0.0.1