Unable to import Azure SQL database with Service Principal

Filip Bieleszuk 0 Reputation points
2023-07-14T13:48:07.97+00:00

Hi,

I have Azure SQL Server with Azure Active Directory authentication only setting enabled

Azure Active Directory admin is a Service Principal.

I am not able to restore database from backup when providing Service Principal name as Active Directory admin user name and its secret as Password.

Received error:

An error occurred while communicating with the SQL Server using AdPassword-login: Could not discover a user realm.

I am getting the same error both from Azure Portal and when using Azure CLI to restore the database.

At the same time I can use above Service Principal in Azure DevOps Pipelines to connect to database without any issues.

Would you be able to help with that?

Best regards,

Filip

Azure SQL Database
{count} votes

1 answer

Sort by: Most helpful
  1. Alberto Morillo 34,461 Reputation points MVP
    2023-07-14T14:35:29.0166667+00:00

    As you can read on this forum thread, Azure users have reported through the years that Import-Export operations with a service principal does not work. You always get the error you shared with us.


Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.