How to connect to localDB from VS on arm win 11?

Erik Martines Sanches 36 Reputation points
2023-09-16T23:29:32.12+00:00

I've installed SQL Server Express 15.0.4153.1. Now in arm Visual Studio (see version below), I'm unable to connect to (localDB)\MSSQLLocalDB from Server Explorer -> Data Connections -> Add Data source -> Microsoft SQL Server -> Data Provider: Microsoft SqlClient Data Provider for SQL Server. Then, Server name: (localdb). WIndows authentication. Test Connection produces this error

Unable to load DLL 'Microsoft.Data.SqlClient.SNI.arm64.dll': The specified module could not be found. (Exception from HRESULT: 0x8007007E).

I'm on arm Win 11 Pro Insider Preview. build 25201.

My VS Info:

Microsoft Visual Studio Community 2022

Version 17.7.4

VisualStudio.17.Release/17.7.4+34031.279

Microsoft .NET Framework

Version 4.8.09032

Installed Version: Community

Visual C++ 2022 00482-20500-16978-AA995

Microsoft Visual C++ 2022

ASP.NET and Web Tools 17.7.273.65229

ASP.NET and Web Tools

Azure App Service Tools v3.0.0 17.7.273.65229

Azure App Service Tools v3.0.0

Azure Functions and Web Jobs Tools 17.7.273.65229

Azure Functions and Web Jobs Tools

C# Tools 4.7.0-3.23416.8+43b0b05cc4f492fd5de00f6f6717409091df8daa

C# components used in the IDE. Depending on your project type and settings, a different version of the compiler may be used.

Microsoft JVM Debugger 1.0

Provides support for connecting the Visual Studio debugger to JDWP compatible Java Virtual Machines

NuGet Package Manager 6.7.0

NuGet Package Manager in Visual Studio. For more information about NuGet, visit https://docs.nuget.org/

Razor (ASP.NET Core) 17.7.3.2333001+0ab18affdf2a37647768d0e25f5f021bee6257a1

Provides languages services for ASP.NET Core Razor.

SQL Server Data Tools 17.7.10.1

Microsoft SQL Server Data Tools

Test Adapter for Boost.Test 1.0

Enables Visual Studio's testing tools with unit tests written for Boost.Test. The use terms and Third Party Notices are available in the extension installation directory.

Test Adapter for Google Test 1.0

Enables Visual Studio's testing tools with unit tests written for Google Test. The use terms and Third Party Notices are available in the extension installation directory.

TypeScript Tools 17.0.20829.2001

TypeScript Tools for Microsoft Visual Studio

Visual Basic Tools 4.7.0-3.23416.8+43b0b05cc4f492fd5de00f6f6717409091df8daa

Visual Basic components used in the IDE. Depending on your project type and settings, a different version of the compiler may be used.

Visual F# Tools 17.7.0-beta.23314.10+e612cf93b989503c89e3a5830090062b7ab5e143

Microsoft Visual F# Tools

Visual Studio IntelliCode 2.2

AI-assisted development for Visual Studio.

Developer technologies | Visual Studio | Other
SQL Server | Other
0 comments No comments
{count} votes

Accepted answer
  1. Bruce (SqlWork.com) 78,086 Reputation points Volunteer Moderator
    2023-09-17T02:05:59.1233333+00:00

    There is no arm version of Sqlserver. You are running the intel version under amd64 emulation. I don’t believe LocalDb is supported in this configuration. Also the visual studio tools have not been ported yet. You can use Sqlserver Management Studio under emulation, or native azure data studio.

    1 person found this answer helpful.

0 additional answers

Sort by: Most helpful

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.