Hi @Hemanth B ,
Hope everything goes well.
Here is a related article which contains steps you can refer to: https://www.mssqltips.com/sqlservertip/5612/getting-started-with-sql-server-2017-express-localdb/
Best regards,
Seeya
SQL Server Exception
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(96, 28.999999999999996%, 19%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EHB%3C/text%3E%3C/svg%3E)
Hemanth B
886
Reputation points
A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connection.(Provider: SQL Network Interfaces, 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.)
I created an app which uses the SQL Server Database tables. When I run it on an external PC without any SQL Server Express tools, I am getting the above error. How can I make every PC install SQL Server Express tools?
SQL Server | Other
-
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(28.799999999999997, 2%, 12%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESX%3C/text%3E%3C/svg%3E)
Seeya Xi-MSFT 16,676 Reputation points2022-05-06T07:00:49.673+00:00 Hi @Hemanth B ,
We have not received a response from you. Did the reply could help you? If the response helped, do "Accept Answer". If it doesn't work, please let us know the progress. By doing so, it will benefit all community members who are having this similar issue. Your contribution is highly appreciated.
Best regards,
Seeya -
Hemanth B 886 Reputation points
2022-05-07T12:48:43.853+00:00 Hi @Seeya Xi-MSFT , I need some time to make everything work out.
-
Seeya Xi-MSFT 16,676 Reputation points
2022-05-20T06:21:21.27+00:00 Hi @Hemanth B ,
Hope everything goes well. I'm concerned about how you're progressing. Have you encountered any new problems or problems solved. If there are new questions you can post them. If you have solved your issue, in order to benefit all community members who are having this similar issue, please choose an answer to accept or vote for the answer you think is useful to you. Your contribution is highly appreciated.
Sign in to comment
3 answers
Sort by: Most helpful
-
Seeya Xi-MSFT 16,676 Reputation points
2022-05-06T09:50:07.09+00:00 -
Seeya Xi-MSFT 16,676 Reputation points
2022-05-05T06:53:53.713+00:00 Hi @Hemanth B ,
Welcome to Microsoft Q&A!
Provider: SQL Network Interfaces, 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 need check if LocalDB feature is installed.
What is more, you can refer to this cocument about connect to LocalDB: https://learn.microsoft.com/en-us/sql/database-engine/configure-windows/sql-server-express-localdb?view=sql-server-ver15#start-localdb-and-connect-to-localdbBest regards,
Seeya
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.-
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(128, 8%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
Anonymous2023-08-25T15:49:03.79+00:00 Hello!
I am having an error message when I try to use LocalDb in Azure Data Studio and when I install the SQL Server Express tool, I don't see the option for LocalDb in there:
What am I doing wrong and why can't I use LocalDB?
Thank you,
Sign in to comment -
-
Olaf Helper 47,616 Reputation points2022-05-05T06:42:38.667+00:00 When I run it on an external PC without any SQL Server Express
If your app utilize a SQL Server database, then it is mandatory to have a running SQL Server instance.
How can I make every PC install SQL Server Express tools?
Not "tools" = SSMS, the database engine is required. If no installation exists, then download the free Express Edition and install it on the client machine.