How can I fix "error: 52 - Unable to locate a Local Database Runtime installation. Verify that SQL Server Express is properly installed and that the Local Database Runtime feature is enabled."

Question

Hello, i am trying to connect my SQL server to a MVC application, i have connected it to Visual Studio(image 1).

Even though I have done this every time I try enter "update-database" in the Package Manager Console it comes back with the error mentioned in the title. I dont know what I can do to fix this, i have tried searching through the internet but still cannot fix it. Any help would be great!

Answer 1

Hi @r2qn,

You didn't describe exactly how to connect to the database.

You can check whether the database connection is successful through Server Explorer.

error: 52 - Unable to locate a Local Database Runtime installation. Verify that SQL Server Express is properly installed and that the Local Database Runtime feature is enabled.

You can check whether SQL Server Express Setup is installed.

Visual Studio

SQL server

Links that may be helpful:

Creating a Connection String and Working with SQL Server LocalDB

Connect to a database in Visual Studio

Best regards,
Lan Huang

---

If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.