We had a recent error message come up when attempting to set the default company within management reporter. The message stated the following:
“Microsoft Management Reporter 2012 error when you sign in to a company: “The connection to the Microsoft Dynamics GP database failed.”
The sa user was still able to access the companies, yet any other GP user was not. Access rights were confirmed for both the GP users and domain users within Management Reporter.
In researching this error the following cause was discovered:
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.
The following link provides instructions on how to correct this situation. Once we performed these steps all the users previously setup in Management Reporter were able to access their companies.