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

Notifications

Announcements

No record found.

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

I have the same question (0)
  • Ankur Patel Profile Picture
    Ankur Patel 35 on at

    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

  • davidf. Profile Picture
    davidf. on at

    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.

  • Verified answer
    davidf. Profile Picture
    davidf. on at

    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.

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…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

#1
mtabor Profile Picture

mtabor 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans