betr-io / terraform-provider-mssql

Terraform provider for Microsoft SQL Server
https://registry.terraform.io/providers/betr-io/mssql/latest
MIT License
35 stars 28 forks source link

SQL Server admin authentication restrictions #55

Open dsfrederic opened 1 year ago

dsfrederic commented 1 year ago

I've been trying to add my Azure Data Factory managed identity user with this provider.

The terraform execution was successful but I've not been able to authenticate from within ADF. So I've tried to run the SQL commands "manually" with SQL Admin account and I've stumbled across this error:

Principal 'adf-cbi-dev-02' could not be created. Only connections established with Active Directory accounts can create other Active Directory users.

Since I'm using the same user in Terraform I was wondering 2 things:

  1. Why does this provider do not fail with the same error?
  2. Is my ADF managed identity correctly assigned these roles?