Thursday, 16 August 2018

Unable to access SQL after straight install from Azure

So you get your new VM and you see SQL installed. You try to connect to SQL and dont know the sa password. So you use the Windows domain account but cannot get in either.

Reason is because the domain may not have been setup yet so you need to connect with the local admin account.


  • Thus you sign in to the machine as the local admin account. 
  • Sign in to SQL. 
  • Change the Properties to Mixed Mode. 
  • Then enable the sa user in security. 
  • Then set the password.

No comments:

Post a Comment