Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

SQL Server admin authentication restrictions #55

Open
dsfrederic opened this issue Jan 16, 2023 · 0 comments
Open

SQL Server admin authentication restrictions #55

dsfrederic opened this issue Jan 16, 2023 · 0 comments

Comments

@dsfrederic
Copy link

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?
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant