What Default 'sa' SQL Admin user Password

asked 2021-10-25T04:22:44.237+00:00
Vilas Bhoge 21 Reputation points

Hi All,

I have created Azure VM with Win Server 2016 and SQL server 2016 from image available from Azure Custom Images .
Now when VM is created a Default SQL instance gets created to which we can Login with SSMS with Windows authentication mode.

Now if i need to login with 'sa' user with SQL Server Authentication mode i can't as i don't have 'sa login password ' and few my apps requires 'sa' user password.

I would like to know what is default password set for 'sa' user whenever we create Azure VM using Base Image from Custom Image Gallery.

The only option for me would be to then create seperate Named Instance where i get option to set 'sa' login password during creation step, but this is extra effort which i need to avoid .

I am functioning as Azure APAC Tech lead and this is frequent question as our Tools requires sa login pwd , hence would like to know what default 'sa' login pwd.

Best Regards -
VB

SQL Server on Azure Virtual Machines
Azure SQL Database
No comments
{count} votes

Accepted answer
  1. answered 2021-10-25T05:25:51.087+00:00
    Pradeep Kommaraju 2,516 Reputation points

    Hi @Vilas Bhoge

    Thanks for reaching out to Microsoft Q&A Platform ,

    Unfortunately , This is by design and no specific password is created by default for 'sa' user

    https://learn.microsoft.com/en-us/azure/azure-sql/virtual-machines/windows/security-considerations-best-practices#manage-accounts

    143276-image.png

    Please do let me know if you have any further questions on the same .
    Also request you to accept the answer if you don't have any further questions ,So that it is useful for the entire community .

    Thanks & Regards,
    Pradeep

    No comments

0 additional answers

Sort by: Most helpful