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.
How to connect to localDB from VS on arm win 11?
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
-
Bruce (SqlWork.com) 78,086 Reputation points Volunteer Moderator
2023-09-17T02:05:59.1233333+00:00