Connection Notes for MS Azure sites

Connection notes for MS Azure Sites:

Database:

A database connection can be made through MS Management Studio using the servername, port and supplier SQL user name and password.

You will need access through MS Management Studio to update the database for upgrades.

Software:

  1. Allow the external IP on Azure

    1. Find out your external IP

      Type “What’s my external IP” into any internet browser.

    2. In the Azure Portal go to Firewall in the SQL Server set up and allow your external IP

      https://exalt.zendesk.com/hc/en-us/articles/360001472755-Adding-an-External-IP-to-your-Azure-resources
  2. Install the software on your local machine

    The software download is available on the support website

    https://exalt.zendesk.com/hc/en-us/articles/360000824315-Current-Software-Release
  3. Add a user to the Insol 6 software

    https://exalt.zendesk.com/hc/en-us/articles/360001506735-Determinig-a-user-s-MS-Windows-Logon-name
  4. Use the UDL Connector to connect to the Azure database

    https://exalt.zendesk.com/hc/en-us/articles/360001449735-Connecting-to-an-MS-Azure-insolvency-database-using-the-software
  5. Pin the software to the Taskbar

    Once the software has been opened with the correct connection and is running, click on the taskbar icon and select “Pin”.

    When you open the software the software remembers the Azure connection.

Templates and documents:

There are several ways to connect to an MS Azure document store, here is one:

  1. Map a drive on your machine

    Run a provided powershell script to run a drive map

    https://exalt.zendesk.com/hc/en-us/articles/360001506775-Mapping-a-drive-to-an-Azure-File-Storage-account
  2. Ensure your computer’s external IP address is added to the Azure Firewall if using IP Blocking

    https://exalt.zendesk.com/hc/en-us/articles/360001472755-Adding-an-External-IP-to-your-Azure-resources
  3. Trusting external document paths

    The trusted site set up is also mentioned here:

    https://exalt.zendesk.com/hc/en-us/articles/360001472755-Adding-an-External-IP-to-your-Azure-resources

Blocked ports

If you have further issues connecting new locations, then this powershell scripts will assist you to ensure ports 1433 (SQL) and 465 (are unblocked).

# test port connection for Database
Test-NetConnection -ComputerName azuresqlservername.database.windows.net -Port 1433

If the ports are blocked:

  1. Check your local machine's Windows firewall settings
  2. Check you modem's firewall settings
  3. Check your service provider's allowable IP settings

 

Have more questions? Submit a request

0 Comments

Please sign in to leave a comment.
Powered by Zendesk