Using SSMS, I'm having trouble adding a new login to the server
dbcreator role on my Azure SQL instance.
Here's the syntax I'm using:
CREATE LOGIN test WITH PASSWORD = 'SuperSecret!' ALTER SERVER ROLE [dbcreator] ADD MEMBER [test]
This works fine on a local SQL instance, but in Azure it fails with
Cannot alter the server role 'dbcreator', because it does not exist or you do not have permission.
I've verified that I'm connected to the server using the Server Admin Login credentials, but the problem persists. Internet searches only turn up the above T-SQL code.
How can I add a login to the
dbcreator role in Azure SQL?