This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(112.00000000000001, 59%, 20%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJ%3C/text%3E%3C/svg%3E)
I need to change the server-level account in my SQL Azure resource to a different user/login. Is this possible?
An Azure relational database service.
You can have more than one account, so why not just create a new one for this user/login?
@Saraswathi Devadula I appreciate your help! I can't seem to add the other account to 'sysadmin' role, so I don't think that's going to work. I'm executing the ALTER statement as the current server-level admin.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(166.4, 95%, 26%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESD%3C/text%3E%3C/svg%3E)
Hello James
Could you please the details requested in the private message for further troubleshooting.
Hi James,
You may change the server admin password by navigating to your logical server in the portal and clicking Reset password. To do this you can use below link to navigate to list of SQL logical servers:
https://portal.azure.com/#servicemenu/SqlAzureExtension/AzureSqlHub/DatabaseServer
Click on your server, similar to below:
Next click Reset password:
Please enter new password twice to confirm and click Save.
Thanks.
-TP
Hi James, unfortunately you cannot "demote" the server admin user on Azure SQL Database. You can only change the password.
Authorize database access to SQL Database, SQL Managed Instance, and Azure Synapse Analytics
https://learn.microsoft.com/en-us/azure/azure-sql/database/logins-create-manage
If you give more details about your requirements I may be able to suggest a different way to accomplish your goal. Each flavor of SQL has its own limitations and this is one specific to Azure SQL Database PaaS service.
Hello James
The name of the Server admin account can't be changed after it has been created.
Please follow the below steps to create a new SQL login and give it the same privileges.
Connect with your existing admin (for example in SSMS) and run:
-- create a new SQL login
CREATE LOGIN [NewAdminLogin] WITH PASSWORD = 'Strong!Passw0rd'; GO
-- add it to the sysadmin server role
ALTER SERVER ROLE sysadmin ADD MEMBER [NewAdminLogin]; GO
To drop the login:
DROP LOGIN [OldAdminLogin];
GO
https://learn.microsoft.com/en-us/sql/relational-databases/security/authentication-access/create-a-login?view=sql-server-ver17#create-a-login-using-sql-server-authentication-with-t-sql
https://learn.microsoft.com/en-us/sql/t-sql/statements/alter-login-transact-sql?view=azuresqldb-current
https://learn.microsoft.com/en-us/sql/t-sql/statements/alter-server-role-transact-sql?view=sql-server-ver17
Hope that helps you switch over to the “new” server-level account. If this doesn't help you, please let me know will assist you with further troubleshooting.