SQL Server Installation Normal service starts normally but cannot connect

Source: Internet
Author: User

Recently installed the SQL2008R2 version of the server, found a crazy problem, I think, with SQL for many years, from version 2005 to version 2012 from the installation to use is very skilled, unexpectedly by the 2008 version is stumped

To the server normal installation, SQL2008R2 Enterprise version (here Express version is the same), all normal, but when the connection, first the server name does not automatically jump out, and then I entered the (Local), no, and then I entered the installation of the time I set the name or not

Both Windows authentication and SQL Server authentication have been tried.

Then suddenly remembered that, before the 2010 version, it was necessary to set the TCP/IP protocol into the Configuration tool, because the default is disabled, such as:

Confident run to set up, and then the service restarted, even the server restarted, thought the problem will be solved, and then found the same error, 555555555

Later Baidu for a long time, finally found a paragraph, the server name is written on: computer name \ The instance name you created when you installed SQL Server

finally know why, after the 2005 version, the default is not the (Local) server name, but the computer name \ The instance name that you created when you installed SQL Server

Fortunately this problem did not waste too much time, otherwise I really want to wall, I every time the computer from 2005 to 2012 version of the experience of the pro, unexpectedly never notice these details, recorded to remember

SQL Server Installation Normal service starts normally but cannot connect

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.