Computer operating system is WIN10 Chinese version, the newly installed English version of SQL Server 2008, the Pure default installation, did not make any changes.
After you install SQL Server 2008, you find that you can only log on by using the default machine name:
If you log in with 127.0.0.1, the following error will be reported:
After querying the Internet, I found that the named pipes in SQL Server Configuration Manager could solve the problem, but there was no egg ...
So began to try their own solution, after a try, Kung fu is not a conscientious ah! Finally found, the following steps to paste out:
The first step is to turn on TCP/IP. Because this protocol is not enabled by default after loading sql:
The second step is to set the port of "IP All" for the properties in TCP/IP to 1433. As we all know, the default port for SQL Server is 1433, but it is not known why the default installation does not have this item.
Then, restart the SQL service to log on with 127.0.0.1:
Troubleshoot problems with SQL Server 2008 not connecting to 127.0.0.1