SQL Server LocalDB Connection Failure

Symptoms

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

There are various reasons this error could occur but it is likely that this is a carryover issue from a sector size issue documented here.

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 and error should not occur.

Contact Support

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