It would be beneficial to add when creating a connection for Azure SQL Database from Settings > Management and Connection Gateways to have the option of authenticating with Service Principal.
Currently the only option for authenticating for the connection is OAuth 2.0 that it acts as user connection.
When a CICD devops pipeline is used to deploy (like using Fabric CI CD opensource library), The SP doesn't have access to connection and therefore fails.
1 Comment
sukkaurMicrosoft Employee
Status changed:NewtoCompletedCreate a new connection, select SQL server for Connection Type, get the SQL database in Fabric Server name and database name from connection string and select Authentication type service principal.
