question

BHOGEVilas-6779 avatar image
0 Votes"
BHOGEVilas-6779 asked PradeepKommaraju-MSFT answered

What Default 'sa' SQL Admin user Password

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

azure-sql-databaseazure-sql-virtual-machines
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

1 Answer

PradeepKommaraju-MSFT avatar image
0 Votes"
PradeepKommaraju-MSFT answered

Hi @BHOGEVilas-6779

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://docs.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


image.png (78.8 KiB)
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.