Starting SQL Server in Azure with Single user mode

Question

Hi All,
Is there a way to start SQL Server in Azure with single user mode with instance not being a VM ?. The sysadmin access is lost and need to get back in. Would the same instructions on a regular instance apply to Azure SQL Server ?

Thanks.

Answer 1

Hello @Calvin Delaney ,

Thank you for reaching out to Microsoft Q&A platform. Happy to answer your question.
In case of a VM, this can be done, as SQL server on VM is just like as on-premises VM. You can refer to the following link for details alter-database-set-single_user-statement-in-sql-server
I have verified in our lab and, it is not supported in SQL PaaS environment.

Please "Accept as Answer" and Upvote if any of above helped so that, it can help others in community looking for remediation for the similar issues.

Answer 2

You should be able to reset that password within the Azure portal on the Overview blade of that Azure SQL Server
There should be a Link/Button "Reset Password" which resets the admin password for that whole server

=> be careful if this server was used by different/several applications and databases and not just one.