Microsoft KB Archive Search

Notice: This website is an unofficial Microsoft Knowledge Base (hereinafter KB) archive and is intended to provide a reliable access to deleted content from Microsoft KB. All KB articles are owned by Microsoft Corporation. Read full disclaimer for more details.

  1. Home
  2. Microsoft Management Reporter 2012 error when you sign in to a company: “The connection to the Microsoft Dynamics GP database failed.”

Microsoft Management Reporter 2012 error when you sign in to a company: “The connection to the Microsoft Dynamics GP database failed.”

View products that this article applies to.

Symptoms

When you select a company in Microsoft Management Reporter and try to log on, you receive the following error message:

Unable to connect to the 'Company Name' company. The connection to the Microsoft Dynamics GP database failed. Contact your system administrator.


If you use the sa user, you can successfully sign in to the company. 

↑ Back to the top

Cause

The server name that is listed in the ODBC on the client computer that connects to GP has a different name for the SQL Server in it versus what is listed in the Company Settings in Management Reporter.

↑ Back to the top

Resolution

Note Before you follow the instructions in this article, make sure that you have a complete backup copy of the database that you can restore if a problem occurs.


There are two methods to resolve this error message.  If the first method does not resolve the error, you must continue with the second method.

Method 1

  1. On the computer that was having the issue, open Control Panel and then click Administrative Tools .  Select Data Sources (ODBC).
  2. When the ODBC window is open, click the System DSN tab and highlight the GP ODBC, then click Configure .
  3. Note the server name that is listed in the first window under the question for "Which SQL Server do you want to connect to?" Note the server name that is listed here.
  4. After you note the server name in the ODBC, open Management Reporter 2012 Configuration Console.
  5. Click ERP Integrations. The GP integration will be listed. Select the integration and verify that the server name is correct.


Method 2
  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


    CU13 or later

    select * from Reporting.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>


↑ Back to the top

Keywords: kbmbsmigrate, kbmbspartner, kbsurveynew, kb

↑ Back to the top

Article Info
Article ID : 2737852
Revision : 1
Created on : 1/7/2017
Published on : 10/7/2015
Exists online : False
Views : 306