microsoft / microsoft/vscode-mssql

[Bug]: Unable to load DLL 'Microsoft.Data.SqlClient.SNI.dll' when connecting with windows authentication.

Open
#22,012 0 comments 0 reactions 0 assignees View on GitHub

Nobody has claimed this yet.

Area - Connection Bug User-filed
Dominant language
TypeScript
Stars
1.9k
Forks
610
Avg merge
2d 3h
Merged PRs (30d)
97

Description

### Description

After upgrading to MSSQL update v.142 i get the following error

Image

Regressing back to 1.41 fixes the issue.

### Steps to Reproduce

1.Upgrade to 1.42
2.Connect to SQL Server With windows authentication

### Affected Area

- [x] Connection dialog (SQL Server | Azure browse/Fabric browse)
- [ ] Query editor
- [ ] Query results panel
- [ ] Object Explorer
- [ ] GitHub Copilot integration
- [ ] Preview/Edit data
- [ ] Table Designer
- [ ] Schema Designer
- [ ] Schema Compare
- [ ] Local SQL Server Container provisioning
- [ ] SQL database in Fabric provisioning
- [ ] DACPAC/BACPAC export/import
- [ ] SQL Database projects
- [ ] Query Plan Visualizer
- [ ] Other (please describe below)

### If you selected "Other", please describe the affected area

_No response_

### Environment Information

VS Code version: 1.117.0
MSSQL version: 1.42
OS Windows 11 Enterprise 24H2

### Confirmation

- [x] I have searched existing issues and couldn't find a match
- [ ] I want to work on this issue

Contributor guide

No contributing guide indexed for this repository

First steps

  1. Read the whole issue, then the project's contributing guide.
  2. Comment on the issue to say you are picking it up — it saves two people doing the same work.
  3. Fork the repository and make your change on a branch.
  4. Open a pull request that references the issue number.

Research direction

Start by reproducing the failure from the connection dialog using Windows authentication on Windows 11 with MSSQL extension 1.42, then compare behavior with 1.41. Trace the connection-dialog path and the Microsoft.Data.SqlClient.SNI.dll loading failure; done means the same connection succeeds on version 1.42.

Written by the indexing model from the issue text.

Assessment

Tech stack
sql, typescript
Domain
databases, operating-systems
Issue type
Bug
Difficulty
3/5
Estimated time
1-2 days
Activity status
Quiet
Clarity
Mostly clear
Newbie friendliness
48/100

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.