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

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Microsoft Dynamics GP (Archived)

Using Data Mart with GP2010 on SQL Server 2005

(0) ShareShare
ReportReport
Posted on by

We have a customer that is setting up a test environment for testing the FRx to MR conversion. They will be installing MR on its own server running at least Windows Server 2008 and SQL Server 2008.

My question is this. Their GP installation is currently running on SQL Server 2005. Looking at the MR 2012 system requirements, under Data Mart database, it states that

"Microsoft SQL Server 2008 or newer is required for the data mart database, system database and the company database for the ERP". So what I am reading is that although SQL Server 2005 is supported for GP2010, if you want to run MR using the data mart, your GP2010 install needs to be running on SQL Server 2005. Is this true?

Thanks

Bill

*This post is locked for comments

I have the same question (0)
  • Suggested answer
    Mahmoud Saadi Profile Picture
    32,738 on at

    You do need to have SQL server 2008 for sure. As for Dynamics GP, you should have a minimum of Dynamics GP 2010 R2 or 2013

  • Suggested answer
    soma Profile Picture
    24,410 on at

    William Routh,

    SQL Server 2005 is support for GP 2010, however if you want to use Management Reporter with using Data Mart, your GP 2010 need to be running  on Microsoft SQL Server 2008 or later.

    Hope this helps!!!

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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

#1
mtabor Profile Picture

mtabor 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans