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 In...
Microsoft Dynamics GP (Archived)

Management Reporter Installation Error - "Couldn't retrieve the list of available databases: The connection attempt failed."

(0) ShareShare
ReportReport
Posted on by Z.N 920

I am having an issue while installing MR 2012 CU10, under "Database GP Connection Information" no matter what I enter, I get the same error

"Couldn't retrieve the list of available databases: The connection attempt failed."

I checked everything according to a previous post Management Reporter 2012 RU4 GP connection error, the guy says that he opened a case with microsoft and this is bug. I tried his solution to copy and paste the password and still not working

PLEASE HELP !

*This post is locked for comments

I have the same question (0)
  • Ian Grieve Profile Picture
    Ian Grieve 22,784 on at

    Take a look at the Windows Event Log or the Configuration Console as they will contain a more detailed error message.

  • Z.N Profile Picture
    Z.N 920 on at

    nothing at all on event viewer

    I checked everything and no log is kept for that. It seems the window is not checking my authentication against the database, no matter what I write it gives the same error

    at the same time, if i put the same user name and password for sa under the "connect to existing database" section, it retreve the databases

    the link i posted for a very similar issue which ended in a case with microsoft reporting this as a bug, i tried to put the password on notepad and then copy/paste to MR, and not work

    Please your help

  • Ian Grieve Profile Picture
    Ian Grieve 22,784 on at
    Just tried this myself in a new VM and am getting the same error as you are. I have successfully installed CU10 without seeing this problem in the past though so not sure what is causing it now.
  • Mahmoud Saadi Profile Picture
    Mahmoud Saadi 32,738 on at

    I came across this issue several days ago with the release of  GP 2015 as I created a virtual environment (Hyper-V), I am still struggling to find out what's the root cause of this issue

    The scenario that is described by Z.N precisely occurs on my VM, if I enter the credentials on the connect to existing database, the databases are retrieved correctly. The issue is primarily related to the Database GP Connection Information section, it is not doing any check against the database.

    I will keep you posted in case anything new emerges at my side.

  • Suggested answer
    babubaskaran@outlook.com Profile Picture
    babubaskaran@outloo... 12 on at

    This is might be related to ODBC on the client computer that connects to GP has a different name for the SQL server versus companies on MR.  Can you please  try the following.

    1. Start SQL Server Management Studio and log on as the sa user.

    2. Open a new query window and run this statement against the MR database:

    select * from ControlCompany

    You will see each of your companies listed in the Code and Name columns.

    3. Find your company and then to the right of it examine the GLEntityConnectionInformation column. You may find it easiest to copy the cell out to Notepad and view it.

    4. Find the value for the SQL Server. It can be found in this string:

    <EntitySetting Name="SQL Server"> <Value xsi:type="xsd:string">server_name</Value>

    Note the server name.

    5. Open Control Panel and then Administrative Tools. Open Data Sources. If you are using a 64-bit OS, you can go to C:\Windows\SysWow64\odbcad32.exe and then open the ODBC.

    6. Configure the ODBC and note the Server field on the first page. This must match the server name from step 4.

    7. In SQL Server Management Studio, expand the MR database and then expand Tables.

    8. Right-click the ControlCompany table and then select Edit Top 200 Rows.

    9. Update the server name in the GLEntityConnectionInformation column. Update the server name in the following string:

    <EntitySetting Name="SQL Server"> <Value xsi:type="xsd:string">server_name</Value> </EntitySetting>

  • Z.N Profile Picture
    Z.N 920 on at

    babu,

    this is fresh installation, I have no database yet . I am installing MR as described by the guys

    i hope someone give me a solution to this

  • Z.N Profile Picture
    Z.N 920 on at

    this seems a bug right ?

  • Z.N Profile Picture
    Z.N 920 on at

    Anyone ?

  • Suggested answer
    babubaskaran@outlook.com Profile Picture
    babubaskaran@outloo... 12 on at

    Did you look into this from Microsoft KB

    support.microsoft.com/.../2932875

  • Suggested answer
    Ian Grieve Profile Picture
    Ian Grieve 22,784 on at

    I have the same problem with both MRCU9 and CU10 on the server.

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
Community Member Profile Picture

Community Member 2

#2
Victoria Yudin Profile Picture

Victoria Yudin 1

#2
mtabor Profile Picture

mtabor 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans