Support for 'Active Directory Interactive' authentication

[sachinshahredmane]

problem

Try to connect to an Azure SQL database using the Active Directory Interactive authentication scheme.

open FSharp.Data

[<Literal>]
let connectionString = @"Data Source=asdf.database.usgovcloudapi.net;Initial Catalog=asdf;User ID=abc@def.com;Authentication='Active Directory Interactive';TrustServerCertificate=True;Connect Timeout=30"

do
    use cmd = new SqlCommandProvider<"select * from records", connectionString>(connectionString)

    cmd.Execute(topN = 3L) 

This provides the following error message:

Severity	Code	Description	Project	File	Line	Suppression State
Error	FS3033	The type provider 'FSharp.Data.SqlCommandProvider' reported an error: Cannot find an authentication provider for 'ActiveDirectoryInteractive'.	CopyDataDbToDb	C:\projects2\CopyDataDbToDb\CopyDataDbToDb\Program.fs	7	Active

solution

Ideally, that the authentication scheme is supported

more info

For now, I have copied the DB onto my local machine so I can work with it, but the data will quickly become stale.

What you can do

• I consider contributing the feature
• I consider help in testing the feature

[smoothdeveloper]

@sachinshahredmane, could you confirm you can connect to the same database using a plain SqlConnection from System.Data.SqlClient namespace with the same connection string?

[sachinshahredmane]

I was only able to connect using the Microsoft.Data.SqlClient namespace. Any chance of upgrading to that driver?

[sachinshahredmane]

Well, I just found #374 so I think I will wait to see if/how things develop.

[github-actions]

🤖 This is an automated response from Repo Assist.

Good news on this front — the migration from System.Data.SqlClient to Microsoft.Data.SqlClient is now actively in progress. Microsoft.Data.SqlClient fully supports Azure AD Interactive authentication, so this issue should be resolved once the migration lands.

The work is tracked in:

• PR 🔧 Engineering overhaul: drop .NET Framework, migrate to .NET 9, add Fantomas #444: Engineering overhaul (drop .NET Framework, migrate to .NET 9, add Fantomas)
• Issue Requirements going forward? #445: Active discussion on requirements and migration path — maintainers (@dsyme, @smoothdeveloper) and contributor @daniellittledev are aligned on doing this as a new major version

The short-term workaround remains connecting to the database locally or using a supported auth method with System.Data.SqlClient. For the longer term, watch #445 for progress updates.

Generated by Repo Assist · ◷

To install this agentic workflow, run

gh aw add githubnext/agentics/workflows/repo-assist.md@346204513ecfa08b81566450d7d599556807389f

[smoothdeveloper]

@sachinshahredmane if you have a way to test current master branch, which has a FSharp.Data.MicrosoftSqlClient nuget package, I believe the Active Directory Interactive authentication scheme would work there, but I don't have an easy way to check myself.

Please let us know.