Create SQL Server VM and necessary databases in a tenant subscription

Step A below allows to create a new SQL Server VM in Azure Stack for the given tenant subscription, SQL admin credential and 3 new databases necessary for VConnect RP installation.

If you have an existing SQL server, you can choose to use that SQL server instead of creating newly. Ensure SQL server authentication is enabled and you have ANY valid SQL server authentication credential available. Proceed to Step B to ensure enabling necessary port and create appropriate new databases before proceeding to the installation.

HOST VM

On AzS Development Kits, sign in to the physical host.

On multi-node integrated systems, the host must be a system that can access admin and tenant endpoints.

Step A. Create all new SQL Server VM and necessary databases in a given tenant subscription

  1. Go to the install folder that was unzipped and used in the previous installation step AzureStack Certification Authority certificate (c:\CloudAssert\VConnectMSM)

  2. Open a new elevated (administrative) PowerShell console and change to the above directory where the files have been extracted (c:\CloudAssert\VConnectMSM). Use a new window to avoid problems that might arise from incorrect PowerShell modules that are already loaded on the system.

  3. Run SetupSqlServer.ps1 and specify the required parameters

.\SetupSqlServer.ps1 -DefaultProviderSubscriptionId "" -AdminArmEndpoint "" -ServiceAdminDirectoryTenantName "" -ServiceAdmin "" -ServiceTenantDirectoryTenantName "" -TenantSubscriptionId "" -ServiceTenant "" -VmLocalAdminUser "caadmin" -VmLocalAdminPass '' -SqlDbName "" -SqlUser "" -SqlPass '' -SetupBillingAndDacm $True -BillingDatabaseName "CloudAssert.Billing" -DacmDatabaseName "CloudAssert.Dacm"

Eg:
.\SetupSqlServer.ps1 -DefaultProviderSubscriptionId "26ec7c55-594d-432f-a728-2c072b942acd" -AdminArmEndpoint "https://adminmanagement.redmond.corp.contosotest.com" -ServiceAdminDirectoryTenantName "contosotest.onmicrosoft.com" -ServiceAdmin "cloudassert@contosotest.onmicrosoft.com" -ServiceTenantDirectoryTenantName "contosotest.onmicrosoft.com"-TenantSubscriptionId "80de4d0c-ae28-46eb-aab7-fc10aa92cebb" -ServiceTenant "cloudassert@contosotest.onmicrosoft.com" -VmLocalAdminUser "caadmin" -VmLocalAdminPass 'TestPass@1234' -SqlDbName "CloudAssert.VConnect" -SqlUser "cadbadmin" -SqlPass 'TestPass@1234' -SetupBillingAndDacm $True -BillingDatabaseName "CloudAssert.Billing" -DacmDatabaseName "CloudAssert.Dacm"

SQL server installation and database creation may take 20-30 minutes.

4. Once deployment successfully completes and VM successfully created, Go to All Resources -> Select the SQL Virtual Machine just created and note down the Public IP Address. (This is needed during installation to be passed to the scripts.)

5. Remote in to SQL server -> SSMS -> Login using the SQL server authentication credential provided in the above script during creation [Ensure the mode of signing in is SQL server authentication and NOT windows authentication]

6. Verify following 3 databases are successfully created

7. Verify SQL Inbound Rule is configured

Go to Windows Firewall -> Inbound Rules -> Verify SQL Inbound Rule for 1433 exists

New SQL Server and necessary components are successfully created, please proceed to Deployment.

Step B. If using existing SQL Server, ensure inbound rule and necessary databases are created to proceed

  1. Remote in to SQL server -> Windows Firewall -> Inbound Rules. Verify a SQL inbound rule allowing port 1433 exists

2. If above rule is not present, follow below steps to create a new inbound rule

3. Remote in to SQL server -> SSMS -> Login using the SQL server authentication credential [Ensure the mode of signing in is SQL server authentication and NOT windows authentication]

4. Create 3 new databases named CloudAssert.VConnect, CloudAssert.Billing, CloudAssert.DACM

In SQL Server -> Databases -> Right Click -> New Database...

Last updated