SQLLocal DB 2016 Unable to connect

195 Views Asked by At

I am having issues connected with SQL 2016 MSSQLLocalDb from my application. The system is a Server 2012 and I have just deployed my web application to it. I have installed SQLLocaldb 2016.

Running

sqllocaldb info
gave this response:  The automatic instance MSSQLLocalDB was not created. 

So I created the instance with the name MSSQLLocalDB.

But when I run the application I get this error: Using: Data Source=(localdb)\MSSQLLocalDB

A network-related or instance-specific error occurred while establishing a 
connection to SQL Server. The server was not found or was not accessible. 
Verify that the instance name is correct and that SQL Server is configured to 
allow remote connections. (provider: SQL Network Interfaces, error: 50 - Local 
Database Runtime error occurred. Cannot create an automatic instance. See the 
Windows Application event log for error details.
    ) 

Changing Data source to named pipe gives this error:

Data Source=np:\.\pipe\LOCALDB#7A55F963\tsql\query

A network-related or instance-specific error occurred while establishing 
a connection to SQL Server. The server was not found or was not accessible. 
Verify that the instance name is correct and that SQL Server is configured to 
allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error 
Locating Server/Instance Specified) 

Hear is a screen shot of SQL Server Management Studio (un-able to connect as well) enter image description here

Can someone please help?

I can't open configuration manager either, when I try I get this error.

enter image description here

1

There are 1 best solutions below

7
On

Try browse: Server name -> Brose for more -> Database Engine.