SQL Server cannot log in to SQL console

SQL cannot log on to the SQL console

= = = Problem description

A domain-joined SQL production server, login repeatedly failed to view the error message after the prompt "in the SQL Server connection is established and network-related or instance-specific errors, the server was not found." Beginning to feel that there is a problem with the login name, in view of the user's server name, I used the., local, the name of the computer to log in to SQL, failed, the user said he has been using this server name, customers, you can not question him. Just do it. (1047 is the SQL port number)

650) this.width=650; "src=" Http://s1.51cto.com/wyfs02/M00/82/DB/wKioL1dis4uBAPNyAAAaISDjQws142.png "title=" QQ picture 20160616220605.png "alt=" Wkiol1dis4ubapnyaaaaisdjqws142.png "/>

Cause analysis of = = =

There are several possible causes for the error:

1. Service not started

2. Network configuration TCP/IP is not turned on in SQL configuration

3. The above two points to a class of problems, the second type of problem is the name of the instance

= = Solution

1. Telnet sqlserver:1047 Port Port Open, service is no problem

2. Open the SQL Configuration Management tool TCP/IP is also on, check that the properties inside are normal

3. The user SQL database is not the default instance used, only the default instance can log on without entering the instance name

4. Enter the Local\ DB instance name and log in normally, and the figure is entered. \scds, problem solved

650) this.width=650; "src=" Http://s5.51cto.com/wyfs02/M01/82/DB/wKioL1ditaLAc85HAABBwpWtyHE805.png "title=" Qq20160616221514.png "alt=" Wkiol1ditalac85haabbwpwtyhe805.png "/>

= = = Summary

I don't know about him. How to log in without entering the instance name, do not get the customer's description at the beginning of the wrong way to solve the problem

This article from "Sameold" blog, reproduced please contact the author!

SQL Server cannot log in to SQL console