SQL Server LocalDB on Windows on ARM

Patric 0

Hello,

i have a Samsung Book 4 Edge with Snapdragon mostly for Software development. I try to install the Sql Server Express Edition, that not work! But i can install the LocalDB-Version and can connect with SSMS and Windows Connection (Sql Server connection will not work). I also can restore a Backfile from a Sql Server Express Edition and all data are available.

Now i try to scaffold the database for work with VS 2022 in a Blazor Wasm. But i get the following 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 that SQL Server is configured to allow remote connections. (provider: SQL Network Interfaces, error: 56 - Unable to load the SQLUserInstance.dll from the location specified in the registry. Verify that the Local Database Runtime feature of SQL Server Express is properly installed.)
 ---> System.ComponentModel.Win32Exception (193): %1 ist keine zulässige Win32-Anwendung.

How can i fix this error??

Erland Sommarskog 110.2K Reputation points

2024-08-07T21:55:38.77+00:00

Well, if LocalDB actually runs on ARM (I would not expect that), the fix is simple: correct the connection string.
LucyChenMSFT-4874 4,335 Reputation points

2024-08-12T02:46:49.6033333+00:00

Hi @Patric,

Could you please tell us if there is any new progress on this issue?

We are still very concerned about your issue!

In addition, I don't want to nag you, but maybe the answers below are helpful. May I humbly suggest that please accept Answer if they helped.

Your action would be helpful to other users who encounter the same issue and read this thread.

The links and methods we provide will also help them resolve their issue or follow up this issue with us together!

Thanks for your understanding. Your encouragement and recognition are the driving force for our progress!

Best regards,

Lucy Chen
LucyChenMSFT-4874 4,335 Reputation points

2024-08-16T06:48:43.15+00:00

Hi @Patric,

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,

Lucy Chen
Grant Erickson 0 Reputation points

2024-09-04T20:32:39.18+00:00
I am running Windows 11 ARM, SSMS 20.2, VS 17.11.2 with .NET 8. I had the same issue. Here is how I got it working with LocalDb.

Install LocalDb via installation media. You can download SQL Express and then get the installation media for LocalDb.

Install SSMS.

You should now be able to connect to LocalDb with a regular server name: (LocalDB)\MSSQLLocalDB

At this point, SSMS works with LocalDb, but you probably still can't connect via a .NET application. The key is to use named pipes.

Run this command SqlLocalDB.exe info MSSQLLocalDB

The last entry of this result will be the named pipe name. It will be something like this: np:\.\pipe\LOCALDB#C3E89C14\tsql\query

If you insert this into your .NET application's connection string, it should connect.

You can also use this to connect to LocalDb using SSMS.

I hope that helps get things going until MS can get a full version of SQL Server that runs natively. BTW: you will be missing features like full-text search, large databases, etc. All the limitations of LocalDb vs full SQL Server.

1 answer

LucyChenMSFT-4874 4,335 Reputation points

2024-08-08T06:16:33.5666667+00:00

Hi @Patric,

Thanks for your reaching out and welcome to Microsoft Q&A!

i have a Samsung Book 4 Edge with Snapdragon mostly for Software development. I try to install the Sql Server Express Edition, that not work!

If you actually run on ARM, unfortunately, as of now, Microsoft SQL Server does not support ARM architecture. This means you won't be able to install SQL Server directly on your device.

Now i try to scaffold the database for work with VS 2022 in a Blazor Wasm. But i get the following error:

For the error message, please check out Erland's comment!

I hope this helps! If you have any more issues or need further assistance, feel free to share with us!

Best regards,

Lucy Chen

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.

https://docs.microsoft.com/en-us/answers/support/email-notifications
Please sign in to rate this answer.
LucyChenMSFT-4874 4,335 Reputation points

2024-08-14T06:56:02.94+00:00

Hi @Patric,

Could you please tell us if there is any new progress on this issue?

We are still very concerned about your issue!

In addition, I don't want to nag you, but maybe the answers below are helpful. May I humbly suggest that please accept Answer if they helped.

Your action would be helpful to other users who encounter the same issue and read this thread.

The links and methods we provide will also help them resolve their issue or follow up this issue with us together!

Thanks for your understanding. Your encouragement and recognition are the driving force for our progress!

Best regards,

Lucy Chen

LucyChenMSFT-4874 4,335 Reputation points

2024-08-21T05:30:48.3033333+00:00

Hi @Patric,

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,

Lucy Chen

LucyChenMSFT-4874 4,335 Reputation points

2024-08-28T06:30:34.3166667+00:00

Hi @Patric,

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,

Lucy Chen

LucyChenMSFT-4874 4,335 Reputation points

2024-09-02T02:04:57.79+00:00

Hi @Patric,

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,

Lucy Chen
Sign in to comment

Use comments to ask for clarification, additional information, or improvements to the question.

Share via

SQL Server LocalDB on Windows on ARM

1 answer

Your answer