I did a little experiment of creating a Microsoft Azure Virtual Machine running SQL Server 2008 and installing a Sage MAS 500 Database onto it. From within the Virtual Machine I was able to successfully register the database.
Using instructions provided by Microsoft, I was able to have the Azure Virtual machine be recognized by my local network. Doing this allowed me to connect a local client to the Azure VM machine successfully and run various tasks.
As it appears this configuration does work, recommend that Sage verify/document this and support this type of configuration as many companies may find value in being able to host their Sage 500 databases on Microsoft Azure.
by: Louis D. | over a year ago | 6 - General Enhancements
Comments
This is cool. Did you hit any hurdles along the way? Have you tried using Azure SQL DB (PaaS)?
The only hurdle I ran into was that I had to install the database utilities onto the virtual SQL Server to get it to install the database. Once I did that, I was able to create and register the database as if the machine existed in my network. Connecting to it using the Sage Client Utility was pretty straight forward as well.. Connecting to it from the Sage 500 client on my local machine, I ran a few tasks and BIE's and it seemed to work fine, but I am just one user working with Demo data. More extensive testing would need to be done to see what the impact of multiple users doing multiple transactions does to the performance. I leave that up to Sage as they would need to do that as part of their process to determine if they would support this type of configuration.