Skip to main content

Notifications

Announcements

Check out the New Agent Creator Community
Announcing new navigation menus and the Engage with the Community forum!
News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / Management Reporter 20...
Microsoft Dynamics GP (Archived)

Management Reporter 2012 RU4 GP connection error

(0) ShareShare
ReportReport
Posted on by davidf.

I installed the MR2012 RU4 on a 2008r2 server. The version on MR2012 is 2.1.1033.30.

 I'm on GP2010 version 11.00.2197.

This is a fresh install, not an upgrade.

 I have verified the firewall port is open.

The Application and Process services are running. But when I try to add the GP Data Mart or GP Legacy connections it errors out with " Couldn't retrieve the list of available databases: The connection attempt failed. "

I have tried various usernames - SA, the Management Reporter account, my own username. 

One thing different on my configuration is we're using a named instance on the database. So the database server is " DATABASE\greatplains " instead of just " DATABASE ".

Something wierd is it doesn't really seem to be verifying the username and password. For example I could enter ILIKEPUPPIES as the username and password and get the same error as when I put in the correct username and password.

Anyone else having this same problem? 

Thanks,

DavidF.

*This post is locked for comments

  • Verified answer
    davidf. Profile Picture
    davidf. on at
    RE: Management Reporter 2012 RU4 GP connection error

    Finally opened a case. It ended up being the password bug. The workaround is to type out your password in notepad, then cut&paste it into the password field.

  • davidf. Profile Picture
    davidf. on at
    RE: Management Reporter 2012 RU4 GP connection error

    Yes, SQL Server Browser is running. On the MR2012 server I have GP client installed also and can connect to the database.

    I just created new ODBC connections with 32bit and 64bit ODBC to test your question.

  • Ankur Patel Profile Picture
    Ankur Patel 35 on at
    RE: Management Reporter 2012 RU4 GP connection error

    Hi DavidF,

    Check the SQL Server Browser service to see if it running, if not  start the service. Can you create a new ODBC connection to the named instance of SQL server?

    Thanks,

    APatel

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

News and Announcements

Check out the New Agent Creator Community
Announcing new navigation menus and the Engage with the Community forum!

Quick Links

Jainam Kothari – Community Spotlight

We are honored to recognize Jainam Kothari as our June 2025 Community…

Congratulations to the May Top 10 Community Leaders!

These are the community rock stars!

Announcing the Engage with the Community forum!

This forum is your space to connect, share, and grow!

Leaderboard >

Last month Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans