betr-io / terraform-provider-mssql

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

mssql: login error: Login failed for user '<token-identified principal>' #76

Open JoshDouglasOU opened 5 months ago

JoshDouglasOU commented 5 months ago

azure_login { tenant_id = var.base_info.tenant_id client_id = data.azurerm_key_vault_secret.sqladdusersclientid.value client_secret = data.azurerm_key_vault_secret.sqladduserstoken.value }

i'm grabbing the client id and secret from kv. this the id of the service principal that has AD read rights this service principal is in the group that is MS Entra Admin on the server

my error is mssql: login error: Login failed for user ''