Hi
Alexandre Von Mühlen •Thankyou for using Microsoft Q&A platform and thanks for posting your query.
From the description of your question, it seems that you are trying to create a login and a user for serverless sql pool and you are getting an error during that process. Please let me know if that is not the case.
Kindly make sure that you are trying to create the login using the master database while you are connected via the active directory ID. You can use the following syntax to create the login:
CREATE LOGIN <login_name> WITH PASSWORD = '<enterStrongPasswordHere>';
GO
Additionally, you may also need to provide User.Read.All
, GroupMember.Read.All
and Application.Read.All
API permissions to the user managed identity assigned to the Azure SQL Database instance
For more details, kindly visit the following resources:
Create Login and User for Server less SQL Pool in Azure Synapse Analytics
Hope it helps. Kindly accept the answer if it was helpful. Thankyou.