Visual Studio 2022 ARM - SQL Server Object Explorer (Microsoft.Data.SqlClient.TdsParser threw an exception)

Question

Visual Studio 2022 ARM - SQL Server Object Explorer (Microsoft.Data.SqlClient.TdsParser threw an exception)

John 20

I am attempting to connect to ANY SQL server database via VS 2022 ARM's SQL Server Object Explorer - it simply states Microsoft.Data.SqlClient.TdsParser there an exception. I also get the same exception when using the EF Core Powertools. My consulted with my friend Google, but can't seem to find anything concrete. I am on an M2 MacBook Pro Max with 64GB RAM on Parallels on Windows 11 / Visual Studio 2022 latest version. Would be grateful with the assist!

Seeya Xi-MSFT 16,586 Reputation points

2023-04-28T01:36:58.2566667+00:00

Hi @John,

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

2 answers

Your answer

Seeya Xi-MSFT 16,586 Reputation points

2023-04-28T01:36:58.2566667+00:00

Hi @John,

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

Answer 1

Tony Chow 5

@Seeya Xi-MSFT

The SQL Server is running on a intel-chip server, but the loading of the data from a ARM based client failed.

I can run SSMS on the same client machine without an issue, it was able to connect to the database on the intel server. but somehow Visual Studio failed at doing so.

To be precise, there seems to be an issue with Microsoft SQL Server when using the .NET Framework Data Provider for SQL Server.

@Tim Tankka @Herwig Ranger

Please also go upvote on the following link to let the dev team how many users are being affected.

https://developercommunity.visualstudio.com/t/Visual-Studio-2022-ARM-Connection-to-S/10395725#T-ND10420526

Thanks

Yaniv C 15 Reputation points

2023-09-07T12:35:34.03+00:00

I dont understand how microsoft can say that they are ready to run on ARM and advertise that VS can run on Macs and NOT have this stuff ready? What do you expect people to build? Hello World applications all day?
SHR 1 Reputation point

2023-12-04T16:10:31.6033333+00:00

Hi,

Four months later and many VS versions later and there is not an working version or workaround from Microsoft!

Let me remember the scenario:

Mac chip (silicon) with MS SQL Server 2022-latest or Azure-Sql-Edge, running in Docker
Windows 11 running in Parallels with Visual Studio 2022 latest version (18.2)
Using Server Explorer to connect to Sql Server (ip, port number)
with SQL Server Authentication gives error:
"The type initializer for 'Microsoft.Data.SqlClient.TdsParser' threw an exception"

The odd thing is that in the very same scenario, there is no problem using MSS Management Studio or Azure Data Studio (from the Windows OS), to connect to the database!

Any help on this would truly welcome, since with this error it's not possible to use mac machines (silicon chip) as an developing environment with MS SQL Server.

Answer 2

Seeya Xi-MSFT 16,586

Hi @John,

So far, SQL Server is not supported to run on ARM. Please see this document:

https://learn.microsoft.com/en-us/sql/sql-server/install/hardware-and-software-requirements-for-installing-sql-server-2022?view=sql-server-ver16

User's image

Best regards,

Seeya

If the answer is the right solution, please click "Accept Answer" and kindly upvote it.

Tim Tankka 5 Reputation points

2023-06-04T00:21:07.05+00:00

I have the same issue as John. We are trying to connect to a SQL server using the VS server explorer - add connection. I need it for EF Core. I have SSMS installed and use it every day. My current workaround is to create a project and configure EF Core on a non ARM workstation, check it in and sync it to my ARM, where it compiles and runs fine.

Tim
Tony Chow 5 Reputation points

2023-06-17T22:01:17.9+00:00

Hi, I understand that ARM version of Windows 11 does not allow SQL Server to be installed, but right now I am trying to connect to another server that have SQL server installed. However, it is giving me the Microsoft.Data.SqlClient.TdsParser unexpected error.

I can use SSMS to connect to that server and run SQL script without an issue, but it seems Visual Studio is not able to do that….

any suggestions is welcomed… thanks
Herwig Ranger 0 Reputation points

2023-07-19T10:36:48.89+00:00

I have exactly the same problem!
Yaniv C 15 Reputation points

2023-09-07T12:39:43.5233333+00:00

So microsoft basically advertises its ready to run on arm and that developers can use visual studio for mac but the only apps they can build is 'Hello World'.
Erik Martines Sanches 36 Reputation points

2023-10-07T19:09:59.8833333+00:00

I have this issue as well. I have VS2022 on Arm Win 11 trying to connect to MSSQL Server 2022 on x64 Win 10. In fact, other software besides VS manages this connection, such as MSSMS and Azure Data Studio.

Share via

Visual Studio 2022 ARM - SQL Server Object Explorer (Microsoft.Data.SqlClient.TdsParser threw an exception)

2 answers

Your answer