How to troubleshoot SQL Server 2014 cannot connect to (local)

When you use SQL Server 2014 for your initial installation, you may encounter situations where you cannot connect to (local). So, how do I fix this problem?

steps to readTools/Materials

• SQL Server 2014

Method/Step

2. 1

   Open SQL Server Configuration Manager --SQL Server Network configuration --The protocol for the instance name (my instance name is SQLExpress).

   Steps to read
4. 2

   Enable Named Pipes and TCP/IP in the sqlexpress protocol .

   Steps to read
6. 3

   Click the SQL Server service to restart SQL Server (SQLEXPRESS) .

   Steps to read
8. 4

   Reopen SQL server Management Studio , server type Select Database engine , server name (local) \ Instance name or computer name \ Instance name (the computer is named your computer name, the instance name is typically SQLExpress or the instance name that was created when you installed SQL), and authentication is selected for Windows authentication.

   Steps to read
10. 5

    Click Connect , then you should log in.

How to troubleshoot SQL Server 2014 cannot connect to (local)