Microsoft Management Reporter 2012 error when you sign in to a company: “The connection to the Microsoft Dynamics GP database failed.”
If you use the sa user, you can successfully sign in to the company.
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.
- On the computer that was having the issue, open Control Panel and then click Administrative Tools . Select Data Sources (ODBC).
- When the ODBC window is open, click the System DSN tab and highlight the GP ODBC, then click Configure .
- 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.
- After you note the server name in the ODBC, open Management Reporter 2012 Configuration Console.
- Click ERP Integrations. The GP integration will be listed. Select the integration and verify that the server name is correct.
- Start SQL Server Management Studio and log on as the sa user.
- Open a new query window and run this statement against the MR database:
select * from ControlCompanyCU13 or laterselect * from Reporting.ControlCompany
You will see each of your companies listed in the Code and Name columns.
- 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.
- 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.
- 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.
- Configure the ODBC and note the Server field on the first page. This must match the server name from step 4.
- In SQL Server Management Studio, expand the MR database and then expand Tables.
- Right-click the ControlCompany table and then select Edit Top 200 Rows.
- 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>
Article ID: 2737852 - Last Review: 10/07/2015 18:17:00 - Revision: 1.4
- kbmbsmigrate kbsurveynew KB2737852