Forum Discussion

Lee Taylor's avatar
Lee Taylor
Copper Contributor
Nov 30, 2021

SQL Server Authentication

I am developing a new windows console app using .Net Core 6 and I have added a reference to System.Data.SQLServer (version 4.8.3) when I go to connect to my Azure SQL database I supply the same connection string that I would when connecting with .NET Framework, however I get an error saying the the authentication parameter is not recognized. Why would this be different? Is there a different process?

 

The parameter is

Authentication='Active Directory Integrated'

SqlClient

2 Replies

Sort By
  • WilliamXifaras's avatar
    WilliamXifaras
    Copper Contributor
    Jan 17, 2022

    Lee Taylor 

     

    You should get the connection string from Azure.

     

    See section Get ADO.NET connection information.

     

    https://docs.microsoft.com/en-us/azure/azure-sql/database/connect-query-content-reference-guide

     

     

     

    • Lee Taylor's avatar
      Lee Taylor
      Copper Contributor
      Dec 20, 2022
      System.Data.SQLClient is ADO.NET and that is the connection string that I was referring to, however, Microsoft.Data.SQLClient used in .NET Core is different.

Resources