Using Azure Trial Free account to practice on their lab tutorials. I'm not clear on steps 5 and 6 of Exercise 4 on this Azure Official Lab. When I login using ADSQLAdmin it says (as expected) account does not exist.

4. From the Azure Active Directory blade, create a new Azure AD user with the following
• Name: ADSQLAdmin
• User name: ADSQLAdmin@<your_Azure_AD_domain_name>
• Profile: Not configured
• Properties: Default
• Groups: 0 groups selected
• Directory role: User
• Password: click Show Password to view the auto-generated password 
5. Start another Internet Explorer InPrivate Browsing session and navigate to the Azure
Portal at https://portal.azure.com.
6. Sign in with the ADSQLAdmin account and, when prompted, change its password to
  • Did you join the server to the domain? – Todd Wilcox Nov 22 '17 at 21:50
  • @ToddWilcox How do we do that?. The lab did not mention it. Also, so you know: I'm using Azure Free Account for trial. – nam Nov 22 '17 at 22:08
  • @ShengbaoShui Which dll would that be? Maybe, you could point to a link. – nam Nov 22 '17 at 23:37
  • @nam You could check my answer. – Shui shengbao Nov 23 '17 at 1:16

You need create a user name ADSQLAdmin in Azure Active Directory.

enter image description here

enter image description here

enter image description here

  • Got it (thanks). So in step 6 (of my post) I needed to use user name as ADSQLAdmin@xxxx.onmicrosoft.com wherexxxx is the default directory name that in my case was my Microsoft loginname appended with hotmail. For example if I am logging in to Azure with my MS email as JohnDoe@hotmail.com then xxxx would be JohnDoehotmail. Then in step 6, I logged-in to Azure using ADSQLAdmin@JohnDoehotmail.onmicrosoft.com and it prompted me to change my password from old password (similar to the one shown in your screenshot) to a new password. – nam Nov 23 '17 at 15:54

Your Answer

By clicking "Post Your Answer", you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.