What Default 'sa' SQL Admin user Password

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

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
0 comments No comments
{count} votes

Accepted answer
  1. Deleted

    This answer has been deleted due to a violation of our Code of Conduct. The answer was manually reported or identified through automated detection before action was taken. Please refer to our Code of Conduct for more information.

    1 deleted comment

    Comments have been turned off. Learn more

0 additional answers

Sort by: Most helpful