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