Azure Stack Dev Kit (Version 20171020) Part 3 - ADFS Mode : Config MSSQL Paas Provider

[Microsoft/Azure Stack] - Azure Stack Dev Kit (Version 20171020) Part 1 - ADFS Mode : Install On Hyper-V Nested Virtual Machine and Lower Memory

[Microsoft/Azure Stack] - Azure Stack Dev Kit (Version 20171020) Part 2 - ADFS Mode : Register Azure Stack with Azure Subscription

MSSQL Paas 구성을 진행한다.

자세한 내용은 https://docs.microsoft.com/en-us/azure/azure-stack/azure-stack-sql-resource-provider-deploy 링크를 참고한다.

1. MarketPlace에서 Windows Server 2016 Core 버전, GUI 버전 2개를 다운받는다. 

2. Azure Stack Dev Kit 호스트 서버에서 SQL resource provider binaries file 을 다운받아 실행하면 압축을 해제하게 된다.

3. 스크립트 실행, 2번에서 압축해제 경로 및 패스워드 정보만 변경해도 무방하다.

Powershell

# Install the AzureRM.Bootstrapper module, set the profile, and install AzureRM and AzureStack modules #Install-Module -Name AzureRm.BootStrapper -Force Import-Module -Name AzureRm.BootStrapper Use-AzureRmProfile -Profile 2017-03-09-profile #Install-Module -Name AzureStack -RequiredVersion 1.2.11 -Force Import-Module -Name AzureStack -RequiredVersion 1.2.11 # Use the NetBIOS name for the Azure Stack domain. On ASDK, the default is AzureStack $domain = "AzureStack" # Point to the directory where the RP installation files were extracted $tempDir = 'C:\TEMP\SQLRP' # The service admin account (can be AAD or ADFS) $serviceAdmin = "azurestack@azurestackadmin" $AdminPass = ConvertTo-SecureString "P@ssw0rd1" -AsPlainText -Force $AdminCreds = New-Object System.Management.Automation.PSCredential ($serviceAdmin, $AdminPass) # Set the credentials for the Resource Provider VM $vmLocalAdminPass = ConvertTo-SecureString "P@ssw0rd1" -AsPlainText -Force $vmLocalAdminCreds = New-Object System.Management.Automation.PSCredential ("sqlrpadmin", $vmLocalAdminPass) # and the cloudadmin credential required for Privileged Endpoint access $CloudAdminPass = ConvertTo-SecureString "P@ssw0rd1" -AsPlainText -Force $CloudAdminCreds = New-Object System.Management.Automation.PSCredential ("$domain\cloudadmin", $CloudAdminPass) # change the following as appropriate $PfxPass = ConvertTo-SecureString "P@ssw0rd1" -AsPlainText -Force # Change directory to the folder where you extracted the installation files # and adjust the endpoints .$tempDir\DeploySQLProvider.ps1 -AzCredential $AdminCreds -VMLocalCredential $vmLocalAdminCreds -CloudAdminCredential $cloudAdminCreds -PrivilegedEndpoint 'azs-ercs01' -DefaultSSLCertificatePassword $PfxPass -DependencyFilesLocalPath $tempDir\cert

4. SQL resource Provider 가 정상 등록되었는지 확인

 4.1 adminportal에서 리소스 그룹 점검

5. SQL Hosting Server 생성

 5.1 adminportal에서 Virtual Machine을 생성

 5.2 Public IP는 Static, VM생성된후에 DNS 이름을 추가로 구성

6. SQL 설치

 6.1 Default 설치

7. Add SQL Hosting Server

8. Create Plan, Offer

9. Tenant 사용자 생성

10. Tenant 사용자 계정으로 portal 접속

11. database 생성

12. database 연결 확인