MS Cloud Foundation

Architecture Foundation - Appendix

 

 

 

 

Company / Organization: becke.ch 

Scope: 0.0 {language={en}; document-type={ott}; organization={becke.ch}; interest={business}; domain={architecture}; level={foundation}; technology={ms-cloud,azure,office-365,dynamics-365}}

Version: 1.0.0

File-name: becke-ch--ms-cloud--s1-v1--foundation.odt

Author:   

Copyright © 2024 becke.ch – All rights reserved

 

Document Version History

Version

Date

Author

Description

1.0.0

07.2019

Raoul Becke

Initial version: Changes according to requirements; see table below version 1.0.0.

 

 

Work-Product Version History

Version

Date

Author

Requirements

Components Changed

1.0.0

07.2019

Raoul Becke

Due to its huge size, moved the appendix of document “becke-ch--ms-cloud--s0-v1” see [1] into this separate document.

Document

 

 

 

 

 

Table of Contents

1. Introduction

2. References and glossary

2.1. References

2.2. Glossary (terms, abbreviations, acronyms)

A. Appendix

A.1. Subscription

A.1.1. Trial Subscription (private)

A.1.2. Azure Portal Login

A.1.3. Trial Subscription Expired Subscribe Again

A.1.4. Organization Subscription

A.1.5. Change Subscription Directory

A.2. My Vsiual Studio: Developer License (MSDN): Activate Azure Benefit on Alternate Account

A.2.1. Error: Oops: It appears that you have already used your MSDN benefit for a Microsoft Azure Subscription

A.3. User Management

A.3.1. Create a new Standard User

A.3.2. Log-In & Set Password

A.3.3. Guest User

A.4. Group Management

A.4.1. Create a new Security Group

A.5. Database

A.5.1. Query Editor

A.5.2. nd logins for “MSDN Subscription” but having “...1...v1...” in the name)

A.5.3. AD User: Create Schema and Grant Access To Create Table, Insert, Select

A.5.4. AD Group: Create Schema and Grant Access To Create Table, Insert, Select

A.5.5. Timeout Issues, Query Information & sys.dm_exec_requests

A.6. Logic App

A.6.1. Create

A.6.2. Logic App Designer

A.7. Azure Data Factory – V2: ETL: Extract, Transfrom & Load: SSIS

A.7.1. SQL Server Data Tools (SSDT) – Installation

A.7.2. Call a Web Service using SSIS then Store and Query the Results – NOT WORKING!

A.7.3. Provision the Azure-SSIS Integration Runtime in Azure Data Factory

A.8. Azure Data Factory – V1: EL: Extract & Load: Copy Data

A.8.1. Copy Data (Preview)

A.8.2. Modify & Deploy

A.8.3. Deployment Script

A.8.4. Incremental Load & Data Delay

A.8.5. Performance Improvement aka Reduce Interval below 15 minutes

A.8.6. ERROR & SOLUTION

A.9. Key Vault

A.9.1. Security

A.9.2. Setup

A.10. Power BI

A.10.1. Desktop Installation

A.10.2. Power BI Desktop

A.10.3. Power BI Pro

A.10.4. Assign license to user

A.10.5. Portal

A.10.6. Create Workspace

A.11. Storage Account

A.11.1. Set-Up

A.11.2. File Share

A.11.3. Security

A.11.4. Build-Time: Administration: RBAC

A.12. Azure Container Instance (ACI)

A.12.1. Create Container Instance

A.12.2. Execute a command in a running Azure container instance

A.13. Azure Cloud Services

A.13.1. Creation

A.13.2. Setup

A.14. Create new Directory

 

Illustration Index

Illustration Index

 

 

Index of Tables

Index of Tables

Table 1: References        8

Table 2: Glossary        8

 

1. Introduction

This document gives an overview of the MS cloud offerings with a focus on MS Azure. It is a summary of many different Microsoft Cloud articles spread over the Internet.

This document contains only the appendix moved over from “becke-ch--ms-cloud--s0-v1” see [1].

 

2. References and glossary

2.1. References

 

Reference

Location

Remarks

[1]

HTML, HTML A4, PDF

MS Cloud foundation: Architecture Foundation.

Table 1: References

 

2.2. Glossary (terms, abbreviations, acronyms)

Terms / Abbreviations / Acronyms

Description

DC

Data-center see Error: Reference source not found

Table 2: Glossary

 

 

2.2.0.0.0.A. Appendix
2.2.0.0.0.A.1. Subscription
2.2.0.0.0.A.1.1. Trial Subscription (private)

  1. 1.Go to “https://azure.microsoft.com/en-us/free/ “ 

 

  1. 2.Click on link “Start free” you will then be redirected to “https://login.microsoftonline.com/common/oauth2/authorize “ 

     

 

 

 

  1. 3.Click on link “Use another account” 

 

  1. 4.Click on link “Create a new Microsoft account” you are then redirected to page: “https://signup.live.com/signup “ 

 

 

  1. 5.Enter the following information: 

    1. a.Email:   

    2. b.Pwd: e… 

    3. c.Optional De-Select “Send me promotional emails from Microsoft” 

  2. 6.Click on button “Next” 

 

 

 

  1. 7.Check you email account: 

Email

From: Microsoft account team <account-security-noreply@accountprotection.microsoft.com>

To:
 

Subject: Verify your email address

 

Microsoft account Verify your email address To finish setting up your Microsoft account, we just need to make sure this email address is yours. To verify your email address use this security code: 8... If you didn't request this code, you can safely ignore this email. Someone else might have typed your email address by mistake. Thanks, The Microsoft account team

 

 

  1. 8.Enter the code you received via Email and click “Next” 

 

 

  1. 9.Enter the characters you see on the captcha and click “Next” you are then redirected to page “https://account.azure.com/signup “ 

 

 

  1. 10.Enter the information “About you”: 

    1. a.Country Region: Switzerland 

    2. b.First Name: Microsoft 

    3. c.Last Name: Cloud (ms-cloud—s0-v1) 

    4. d.Email:   

    5. e.Work Phone: 004179… 

    6. f.Organization Optional: Leave Empty 

  2. 11.Identity verification by phone: 

    1. a.Switzerland (+41) 

    2. b.79… 

    3. c.Enter the message you received into the text message field: 785… 

  3. 12.Identity verification by card: 

    1. a.Payment method: New Debit/Credit Card 

    2. b.Card number: … 

    3. c.Expiration date: 07/2018 

    4. d.CVV: … 

    5. e.Name on card: Raoul … 

    6. f.Address line 1: S... 3 

    7. g.Address line 2: [empty] 

    8. h.City: Elgg 

    9. i.State/Province/Distrinct: [empty] 

    10. j.Postal Code: 8353 

  4. 13.Agreement – click on “Agree” - you are then redirected to page: “https://account.azure.com/signuplanding/Index “ 

 

The subscription is active and you can proceed to the following main administration pages:

 

2.2.0.0.0.A.1.3. Azure Portal Login

  1. 1.Navigate to “http://portal.azure.com” which redirects you to “https://login.microsoftonline.com “ 

 

  1. 2.Enter your credentials: 

    1. a.User:   

    2. b.Password: ... 

  2. 3.You are then redirected to: https://login.live.com/ 

 
2.2.0.0.0.A.1.5. Trial Subscription Expired Subscribe Again

  1. 1.Follow the steps described in chapter A.1.1 but when reaching step “https://account.azure.com/signup ” you get the message: “You already used your one free trial or you are not eligible for it.”: 

 

  1. 2.Trying with a different user: ms-cloud--s0-v2 

BUT after the last step getting the error message: “We cannot proceed with signup due to an issue with your account. Please contact support.”

 
2.2.0.0.0.A.1.7. Organization Subscription

 

https://account.azure.com/organization

 

Domain Name: Handling Insufficient: The domain name handling in Microsoft Azure is insufficient – see chapter Error: Reference source not found.

 

  1. 1.About you 

    1. a.FIRST NAME: Microsoft 

    2. b.LAST NAME: Cloud (ms-cloud—s0-v1) 

    3. c.CONTACT EMAIL ADDRESS:   

    4. d.ORGANIZATION NAME (OPTIONAL): becke.ch 

  2. 2.Your login and country information: 

    1. a.DOMAIN NAME: beckech (.onmicrosoft.com) “check availability” (see issues above) 

    2. b.NEW USER ID: ms-cloud--s0-v1 (@beckech.onmicrosoft.com)  

    3. c.COUNTRY/REGION: Switzerland 

    4. d.CREATE NEW PASSWORD: E… 

    5. e.CONFIRM NEW PASSWORD: E… 

  3. 3.Your mobile number and verification: 

    1. a.Your mobile number and verification: Switzerland (+41) 

    2. b.SEND TEXT MESSAGECALL ME: 79 ... (You get an SMS from +447781470659) 

    3. c.Verify: 155... 

  1. 4.You are redirected to: Log-In to Microsoft Azure: https://login.microsoftonline.com : 

 

Login: ms-cloud--s0-v1@beckech.onmicrosoft.com

Password: E...

 

 

  1. 5.You are redirected to: Account Azure: https://account.azure.com  

 

  1. 6.About you: 

    1. a.* Country/Region: Switzerland 

    2. b.* First Name: Microsoft 

    3. c.* Last Name: Cloud (ms-cloud—s0-v1) 

    4. d.* Email address for important notifications:   

    5. e.* Work Phone: 79 ... 

    6. f.Organization (Optional): becke.ch 

 

 

 

 

  1. 7.Identity Verification by phone: 

    1. a.Switzerland (+41) 

    2. b.79 ... (“Send text message”) (You get an SMS from +447781470659) 

    3. c.Verify: 572... (“Verify Code”) 

 

 

 

 

  1. 8.Identity Verification by card: 

    1. a.Payment method: New Credit/Debit Card: VisaMasterCardAmerican Express (Your card will not be charged, though you might see a temporary authorization hold.) 

    2. b.* Card number: 3776 … 

    3. c.* Expiration date: 07/2018 

    4. d.* CVV: … 

    5. e.* Name on card: Ra… 

    6. f.* Address line 1: So… 

    7. g.Address line 2 (Optional): [empty] 

    8. h.* City: E… 

    9. i.State/Province/District (Optional): [empty] 

    10. j.* Postal Code: 8... 

 

 

 

 

  1. 9.Agreement: 

    1. a.Select: “I agree to the subscription agreement, offer details, and privacy statement.” 

    2. b.Optional: Select: “Microsoft may use my email and phone to provide special Microsoft Azure offers.” 

 

Welcome:

 

Get started with your Azure subscription: https://portal.azure.com

 

AND the good thing is that even I already had a trial subscription previously (see above) which has expired. I could again get a trial subscription:

 
2.2.0.0.0.A.1.9. Change Subscription Directory

There exist 2 different ways to change the subscription directory:

 
 
 

 

 

 

2.3.0.0.0.0.1. My Vsiual Studio: Developer License (MSDN): Activate Azure Benefit on Alternate Account

Chrome (or Firefox): Always use the Chrome (or Firefox) Browser to e.g. avoid „strange” SSO behavior of IE.

Email: Wait for your confirmation of the MSDN Platform Subscription:

 

My Vsiual Studio: Developer License (MSDN): https://my.visualstudio.com/subscriptions

Log in with your business account.

Go to “Subscriptions” and click on “Add alternate account”:

 

Go to “Benefits” and copy the hyperlink on “Activate”: https://account.windowsazure.com/signup?offer=MS-AZ... (DO NOT CLICK ON THE HYPERLINK!)

 

Close all browsers.

Log-In with your private account: https://my.visualstudio.com/

Enter the hyperlink (you copied previously) in the browser: https://account.windowsazure.com/signup?offer=MS-AZ...

 

Select: “I agree to the subscription agreement, offer details, and privacy statement” and click on “Purchase”

DONE – you can now click on “Or get started with your Azure subscription”: https://portal.azure.com/

 

SUCCESS:

 
2.3.0.0.0.0.1.1. Error: Oops: It appears that you have already used your MSDN benefit for a Microsoft Azure Subscription

If you get the error: Oops: It appears that you have already used your MSDN benefit for a Microsoft Azure Subscription:

 

Solution: You need to go to your respective MSDN Subscription responsible, delete your MSDN Subscription and assign it new. You will then get again an Email and can start as described in the previous chapter.

 

 

2.3.0.0.0.0.2. User Management
2.3.0.0.0.0.2.1. Create a new Standard User

We create a new Standard User for the DB Access:

 

Create a database active directory user for DB Access:

Create a database active directory user for DB Access that is member of group db-user-group--s0-v1:

 

Create another user as db administrator:

 

Create user for account access:

 

Create user for key vault access:

 

2.3.0.0.0.0.2.2. Log-In & Set Password

http://portal.azure.com

 

 

 

 

 

 

2.3.0.0.0.0.2.3. Guest User

  1. 1.Click on “Users” 

 

  1. 2.Click on “+ New Guest User” 

 

  1. 3.Enter the user details: 

 

  1. 4.In the email invitation click on the button “Get Started”: