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.
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.
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.
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 ControlCompany
CU13 or later
select * 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>