Striim 3.9.4 / 3.9.5 documentation

Configuring an Azure virtual machine running SQL Server

When SQL Server is running in an Azure virtual machine as described in How to provision a Windows SQL Server virtual machine in the Azure portal, do the following before following the steps in SQL Server setup .

  1. Go to the virtual machine's Overview tab.

  2. If there is no public IP address, enable it.

  3. If there is no DNS name, specify one, and make a note of the full name (<DNS name>.<Azure region>.cloudapp.azure.com), as you will need it to configure MSSQLReader.

  4. Go to the virtual machine's SQL Server configuration tab.

  5. Set SQL connectivity to Public (Internet).

  6. Enable SQL Authentication and and specify the login name and password MSSQLReader will use to connect to SQL Server.

  7. Make note of the Port setting, as you will need it to configure MSSQLReader.

  8. Go to the Overview tab and click Connect.

  9. When prompted, download the .rdb file, open it in Remote Desktop Connection, and connect to the virtual machine using the resource group's user name and password (not the user name and password you specified for SQL Server authentication).

  10. Open the SQL Server Configuration Manager and set the following as necessary:

    • Protocols: Shared Memory enabled, Named Pipes disabled, TCP/IP enabled

    • TCP/IP Properties IP Addresses tab: TCP Dynamic Ports empty, TCP Port matches the SQL Authentication setting

  11. Log out of Remote Desktop Connection and continue with the instructions in SQL Server setup.