Sinks.MssqlServer with Certificate Based Authentication

[j-cade]

Is there any support for using this sink with a certificated based authentication model? My application uses CBA with Tokens to gain access to Azure SQL Database and I want to extend this access to Serilog logging.

[ckadluba]

Hi @j-cade!

This sink relies on the (Azure) AD Authentication capabilities built into Microsofts SqlClient library.

I have not tested nor ever used this yet, but according to the documentation of SqlClient (https://learn.microsoft.com/en-us/sql/connect/ado-net/sql/azure-active-directory-authentication?view=sql-server-ver16#using-active-directory-default-authentication) if you specify Active Directory Default Authentication, you could use the environment variable AZURE_CLIENT_CERTIFICATE_PATH to specify a certificate.