Connection Notes for MS Azure sites

Connection notes for MS Azure Sites:

Database:

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

If using IP filtering then make sure your admin machine's IP address has an entry in the filter (portal.azure.com/)

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
   
   Ensure you have a fixed IP address to avoid a reset of your modem settings assigning you a dynamic IP address.
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