web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Finance | Project Operations, Human Resources, ...
Answered

GP into Azure

(0) ShareShare
ReportReport
Posted on by

Hello:

Is there any documentation anywhere that speaks toward best practices with moving GP into Azure?

If not, does anyone have any "tips" along these lines?

Thank you!

John

Categories:
I have the same question (0)
  • Verified answer
    Derek Albaugh Profile Picture
    Microsoft Employee on at

    Microsoft-Dynamics-GP-2015-on-Windows-Azure.docx

    This is the only documentation we really have in regards to Microsoft Dynamics GP and Azure. 

    The one thing to keep in mind, as mentioned in the document, is that Dynamics GP is not compatible nor supported with Azure SQL as a service.

    Thanks

  • Community Member Profile Picture
    on at

    Hi Derek:

    Thank you, so much, for the quick response!

    Would SQL have to be kept on-premises, then, if Azure SQL as a Service cannot be used?

    John

  • Richard Wheeler Profile Picture
    75,852 Moderator on at

    Derek, can't you put SQL runtime or standard on an Azure server? From what I have seen Azure is just a server in the cloud and you can put whatever you want on it.

  • Derek Albaugh Profile Picture
    Microsoft Employee on at

    Yes, you can actually get Azure VM templates with SQL already installed on them, which I have used and recommend.

    When you configure the VM, you also configure the SQL Server such as 'sa' password and such.

    It's really no different than an on-premises VM environment, just that it is 'in the cloud', as far as Dynamics GP goes.

    Thanks

  • Suggested answer
    Beat Bucher  GP Geek  GPUG All Star Profile Picture
    28,058 Moderator on at

    John & Richard,

    I've already moved several clients from on-prem or hosted facilities to Azure.. I had never seen the document that Derek posted here before, but everything is by the book and exactly how you're supposed to do it.

    About the licensing, it all depends if you're subscribed to a larger SLA for licensing or not, but in general, it's recommended to pay the licenses directly with the VM's you setup from the Azure store. There are hundreds of Azure Templates all pre-configured with the software, the only difference is that if you take one with SQL installed already, you might have to reconfigure it to fit your very specific needs for GP, as out-of-the-box it's very standard.

    I always recommend a multi-VM approach with the back-end SQL data server and a front-end TS server for the users to connect to. It's likely that the client will be using O365 (now Microsoft 365) licenses for Excel & Word, so there are some particularities to consider when deploying on a TS server, to avoid multiple licensing for each and every user.

    Depending on how large the user count will be, you may want to add a 3rd VM for applications (like MR 2012, Web Services, Integration Services, etc..) to not put all the load on the SQL server.. though it's all about budgeting and costs, since firing up a new VM will add its load of $$$ to the TCO. Most of my small to mid sized businesses get away with a 2-VM's setup.

    The most tricky part is the AADS integration with the existing domain and/or the O365 accounts, and of course securing the whole network in the cloud so only the computers from the internal company network can actually access the Azure environment thru a dedicated VPN setup. If you're not familiar with all things networking and security, you better hire a good Azure network specialist. Or pay Microsoft support to assist you with the setup.

    To get an idea of the TCO, use the Azure cost calculator to get a rough estimate of your monthly bill to come. Microsoft offers some significant rebates if you commit for long term and pay up-front for 1-3 years ahead. The savings can be up to 30% if not mistaken compared to the PAYG (Pays As You Go) model.

    Everything else is pretty much identical with an on-prem setup when it comes to deploy the various services around GP, as described in the document.

    The major difference when using SQL on Azure (and having the VM declared as such), is that you'll be able to leverage the Azure Data backup framework and get all your scheduled backups handled directly by Azure (instead of creating maintenance plans in SSMS), which offers also redundant data storage for a better DR coverage. What you still need to plan locally on the SQL VM is the regular DBCC checks, as this isn't yet offered in the Azure DB maintenance. The annoying thing is that the backup tasks from the Azure side don't offer as much flexibility for the schedule, but they are very fast.

    Since the document is already 5 years old, you may want to dive a little bit more into the various VM sizes that are currently offered on Azure, as they evolve quite frequently. As for the storage space, be careful to chose the proper type (HDD, SSD or Premium SSD) as there is a hefty price tag attached to premium SSD, which turns out to be the default storage type when creating a new VM or storage space. The OS disk running the VM ususally doesn't need to be a premium SSD drive, as there isn't much going on that drive (but again, it depends on how your SQL is setup). Most data drive get pretty descent performance with regular SSD drives and they are 30-50% cheaper than premium SSD's. The biggest cost on every VM is likely to be the licensing of SW and running CPU's. Chose wisely.

    Hope this helps.

  • Community Member Profile Picture
    on at

    Thank you, Beat and Derek!

    John

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Stars!

Congratulations to our 2025 Community Spotlights

Thanks to all of our 2025 Community Spotlight stars!

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 545 Super User 2026 Season 1

#2
Giorgio Bonacorsi Profile Picture

Giorgio Bonacorsi 408

#3
Adis Profile Picture

Adis 267 Super User 2026 Season 1

Last 30 days Overall leaderboard

Product updates

Dynamics 365 release plans