Configure service account in Azure SQL Server

Good morning,

I have an SQL Server running on an Azure Virtual Machine, and I’ve been tasked with creating a ‘Service Account’ and configuring the SQL Server services (SQL Server and SQL Server Agent) to use this new account. Currently, my SQL Server is configured as follows:

As you can see, the ‘Log On As’ is set to use the default accounts. My goal is to replace these with custom service accounts.

I have a few questions:

1.- Are ‘Service Accounts’ a concept in Azure? In our on-premises environment, our SQL Server uses service accounts created by our domain administrators. I’m wondering if it’s possible to create similar service accounts within the Azure tenant where the VMs are hosted.

learn.microsoft.com/en-us/sql/database-engine/configure-windows/configure-windows-service-accounts-and-permissions?view=sql-server-ver16 I have read that in Azure offers the following options:

• Managed Service Accounts
• Group-managed service accounts
• Virtual accounts

However, I’m unsure which option is best suited for my needs and how to get started.

2.- How do I create a Service Account that can be used in the Virtual Machine to configure SQL Server via SQL Server Configuration Manager?

Thanks in advance,

Cristopher Aguilera