Connection notes for MS Azure Sites:
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.
- Allow the external IP on Azure
- Find out your external IP
Type “What’s my external IP” into any internet browser.
- In the Azure Portal go to Firewall in the SQL Server set up and allow your external IP
- Install the software on your local machine
The software download is available on the support website
- Add a user to the Insol 6 software
- Use the UDL Connector to connect to the Azure database
- 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:
- Map a drive on your machine
Run a provided powershell script to run a drive map
- Ensure your computer’s external IP address is added to the Azure Firewall if using IP Blocking
- Trusting external document paths
The trusted site set up is also mentioned here:
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:
- Check your local machine's Windows firewall settings
- Check you modem's firewall settings
- Check your service provider's allowable IP settings