Skip to main content

SQL Server LocalDB Connection Failure

A
Written by Ashok P
Updated over 3 months ago

The issue being discussed in this article is:

You receive the following error when using SI:

D-Tools SI cannot connect to your SQL Server LocalDB on your machine.

Error: 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 the SQL Server is configured to allow remote connection. (provider: SQL Network Interfaces, error:50 - Local Database Runtime error occurred. Error occurred during LocalDB instance startup: SQL Server process failed to start. )

SQL Server LocalDB may not be correctly installed on your machine.

The following is the screenshot of the error:

sql localdb connection failure.jpg

The following is the resolution:

1/ Close SI.

2/ Open the Command Prompt on your machine and run the following two commands:

  • sqllocaldb stop mssqllocaldb

  • sqllocaldb delete mssqllocaldb​

3/ Delete the following two folders:

  • C:\Users\username\AppData\Local\Microsoft\Microsoft SQL Server Local DB\Instances\MSSQLLocalDB

  • C:\Users\username\AppData\Roaming\D-Tools\SIX\Data\Databases

4/ Relaunch SI.

If you cannot resolve this issue, please open a Support Ticket.

Did this answer your question?