Troubleshoot problems with SQL Server 2008 not connecting to 127.0.0.1

Source: Internet
Author: User

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

Related Article

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.