web
You’re offline. This is a read only version of the page.
close
Skip to main content

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) / MR 2012 Cannot connect...
Microsoft Dynamics GP (Archived)

MR 2012 Cannot connect to server

(0) ShareShare
ReportReport
Posted on by Richard Wheeler 75,852 Moderator

Trying to connect to MR from a workstation and we are getting this message.

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

I have followed KB 2737852 but all the server names correct. What else may be causing this? MR Designer works fine on the server but not on any of the workstations.

*This post is locked for comments

I have the same question (0)
  • Leahs Profile Picture
    Leahs Microsoft Employee on at

    1) What is the coordinating error in the Event viewer?

      a)  Please recreate the error message and check the event viewer for error messages.  Go to Administrative Tools >> Event viewer >> Windows Logs >> Application.  Select the error and reply back with the text from the error.

    2)  Are you able to log into the company in Dynamics GP with the same credentials?

  • Richard Wheeler Profile Picture
    Richard Wheeler 75,852 Moderator on at

    MR is failing using Windows credentials. GP users use SQL credentials. Here the log from the event viewer.

    Log Name:      Application

    Source:        Management Reporter 2012 Services

    Date:          9/10/2014 11:08:28 AM

    Event ID:      0

    Task Category: None

    Level:         Error

    Keywords:      Classic

    User:          N/A

    Computer:      GP2010.acaa.local

    Description:

    Microsoft.Dynamics.Performance.Reporting.DataProvider.Service.DirectLinkException: The connection to the Microsoft Dynamics GP database failed. Contact your system administrator. ---> Microsoft.Dynamics.Performance.DataProvider.GeneralLedger.GLConnectionException: The connection to the Microsoft Dynamics GP database failed. Contact your system administrator.

      at Microsoft.Dynamics.Performance.DataProvider.GeneralLedger.GP.Data.DataConnector.CreateConnectionUsingGPCredentials(String dataSourceName, String databaseName, String userName, String password)

      at Microsoft.Dynamics.Performance.DataProvider.GeneralLedger.GP.Data.DataConnector.CreateConnection()

      at Microsoft.Dynamics.Performance.DataProvider.GeneralLedger.GP.Data.DataConnector.OpenConnection()

      at Microsoft.Dynamics.Performance.DataProvider.GeneralLedger.GP.Data.DataConnector.EnsureDatabaseAccess(String dynamicsDatabase, String entityDatabase)

      at Microsoft.Dynamics.Performance.DataProvider.GeneralLedger.GP.GLProvider.HandleConnect(EntitySettingCollection settings, CredentialCollection credentials)

      at Microsoft.Dynamics.Performance.DataProvider.Core.SourceSystemConnection.Open()

      at Microsoft.Dynamics.Performance.DataProvider.Core.SourceSystem.Connect(EntitySettingCollection settings, CredentialCollection credentials)

      at Microsoft.Dynamics.Performance.Reporting.DataProvider.Server.DirectLinkConnectionManager.CreateSourceSystemConnection(Guid providerTypeId, EntitySettingCollection settings, StoredCredential credential)

      --- End of inner exception stack trace ---

      at Microsoft.Dynamics.Performance.Reporting.DataProvider.Server.DirectLinkConnectionManager.CreateSourceSystemConnection(Guid providerTypeId, EntitySettingCollection settings, StoredCredential credential)

      at Microsoft.Dynamics.Performance.Reporting.DataProvider.Server.DirectLinkConnectionManager.CreateSourceSystemConnection(Guid entityId, StoredCredential credential)

      at Microsoft.Dynamics.Performance.Reporting.DataProvider.Server.DirectLinkConnectionManager.CreateSourceSystemConnection(DataServiceConnection connection)

      at System.Lazy`1.CreateValue()

      at System.Lazy`1.LazyInitValue()

      at Microsoft.Dynamics.Performance.DataProvider.Core.AutoExpiringDisposableCache`2.AutoExpiringDisposableCacheItem`2.GetItem(Boolean acquireOwnership)

      at Microsoft.Dynamics.Performance.DataProvider.Core.AutoExpiringDisposableCache`2.GetOrAdd(TKey key, Func`2 createCacheItemValue, Boolean acquireOwnership)

      at Microsoft.Dynamics.Performance.Reporting.DataProvider.Server.DirectLinkConnectionManager.UsingConnection[TResult](DataServiceConnection connection, Func`2 executor)

      at Microsoft.Dynamics.Performance.Reporting.DataProvider.Server.DirectLinkService.<>c__DisplayClassb.<Connect>b__9()

      at Microsoft.Dynamics.Performance.Reporting.Security.Service.SecureServiceBase.SecureExecuteInternal[TResult](Func`1 hasPermission, Func`1 executor)

      at Microsoft.Dynamics.Performance.Reporting.Common.Service.ServiceBase.BaseExecute[TResult](Func`1 executor)

    Component: Microsoft.Dynamics.Performance.Reporting.DataProvider.Server.DirectLinkService

    User: MyDomain\Administrator

    Event Xml:

    <Event xmlns="schemas.microsoft.com/.../event&quot;>

     <System>

       <Provider Name="Management Reporter 2012 Services" />

       <EventID Qualifiers="0">0</EventID>

       <Level>2</Level>

       <Task>0</Task>

       <Keywords>0x80000000000000</Keywords>

       <TimeCreated SystemTime="2014-09-10T15:08:28.000000000Z" />

       <EventRecordID>59180</EventRecordID>

       <Channel>Application</Channel>

       <Computer>GP2010.MyDomain.local</Computer>

       <Security />

     </System>

     <EventData>

       <Data>Microsoft.Dynamics.Performance.Reporting.DataProvider.Service.DirectLinkException: The connection to the Microsoft Dynamics GP database failed. Contact your system administrator. ---> Microsoft.Dynamics.Performance.DataProvider.GeneralLedger.GLConnectionException: The connection to the Microsoft Dynamics GP database failed. Contact your system administrator.

      at Microsoft.Dynamics.Performance.DataProvider.GeneralLedger.GP.Data.DataConnector.CreateConnectionUsingGPCredentials(String dataSourceName, String databaseName, String userName, String password)

      at Microsoft.Dynamics.Performance.DataProvider.GeneralLedger.GP.Data.DataConnector.CreateConnection()

      at Microsoft.Dynamics.Performance.DataProvider.GeneralLedger.GP.Data.DataConnector.OpenConnection()

      at Microsoft.Dynamics.Performance.DataProvider.GeneralLedger.GP.Data.DataConnector.EnsureDatabaseAccess(String dynamicsDatabase, String entityDatabase)

      at Microsoft.Dynamics.Performance.DataProvider.GeneralLedger.GP.GLProvider.HandleConnect(EntitySettingCollection settings, CredentialCollection credentials)

      at Microsoft.Dynamics.Performance.DataProvider.Core.SourceSystemConnection.Open()

      at Microsoft.Dynamics.Performance.DataProvider.Core.SourceSystem.Connect(EntitySettingCollection settings, CredentialCollection credentials)

      at Microsoft.Dynamics.Performance.Reporting.DataProvider.Server.DirectLinkConnectionManager.CreateSourceSystemConnection(Guid providerTypeId, EntitySettingCollection settings, StoredCredential credential)

      --- End of inner exception stack trace ---

      at Microsoft.Dynamics.Performance.Reporting.DataProvider.Server.DirectLinkConnectionManager.CreateSourceSystemConnection(Guid providerTypeId, EntitySettingCollection settings, StoredCredential credential)

      at Microsoft.Dynamics.Performance.Reporting.DataProvider.Server.DirectLinkConnectionManager.CreateSourceSystemConnection(Guid entityId, StoredCredential credential)

      at Microsoft.Dynamics.Performance.Reporting.DataProvider.Server.DirectLinkConnectionManager.CreateSourceSystemConnection(DataServiceConnection connection)

      at System.Lazy`1.CreateValue()

      at System.Lazy`1.LazyInitValue()

      at Microsoft.Dynamics.Performance.DataProvider.Core.AutoExpiringDisposableCache`2.AutoExpiringDisposableCacheItem`2.GetItem(Boolean acquireOwnership)

      at Microsoft.Dynamics.Performance.DataProvider.Core.AutoExpiringDisposableCache`2.GetOrAdd(TKey key, Func`2 createCacheItemValue, Boolean acquireOwnership)

      at Microsoft.Dynamics.Performance.Reporting.DataProvider.Server.DirectLinkConnectionManager.UsingConnection[TResult](DataServiceConnection connection, Func`2 executor)

      at Microsoft.Dynamics.Performance.Reporting.DataProvider.Server.DirectLinkService.<>c__DisplayClassb.<Connect>b__9()

      at Microsoft.Dynamics.Performance.Reporting.Security.Service.SecureServiceBase.SecureExecuteInternal[TResult](Func`1 hasPermission, Func`1 executor)

      at Microsoft.Dynamics.Performance.Reporting.Common.Service.ServiceBase.BaseExecute[TResult](Func`1 executor)

    Component: Microsoft.Dynamics.Performance.Reporting.DataProvider.Server.DirectLinkService

    User: MyDomain\Administrator</Data>

     </EventData>

    </Event>

  • Leahs Profile Picture
    Leahs Microsoft Employee on at

    The error message "Unable to connect to the 'Company Name' company. The connection to the Microsoft Dynamics GP database failed." usually occurs when attempting to set a company as default in Management Reporter.  With the Legacey Provider integration you will be prompted for the Dynamics GP SQL credentials when setting the company as default.

  • Redbeard Profile Picture
    Redbeard 12,931 on at

    I had a problem with a firewall setting at the server last week - MR and GP worked fine on the server and installed from a folder on the server, but couldn't run applications connections on the server.  I had the IT department disable the Firewall for domain only, and it worked fine thereafter.  Now it is up to the IT department to configure the firewall appropriately.

  • Richard Wheeler Profile Picture
    Richard Wheeler 75,852 Moderator on at

    That was my first thought. I checked the server and the Firewall was not turned on. I had turned off the firewall on the workstation just to test and it made no difference.

  • Suggested answer
    Redbeard Profile Picture
    Redbeard 12,931 on at

    I should have known you checked the firewall, I only mentioned it because the IT guy at the company involved in the incident described above as incredulous when I checked that first.  I stopped short of asking whether or not you'd set security for the windows user(s) in MR.

    If you move from Legacy to Data-mart,  it can cause interesting behaviors (I support MR on SL and GP).  It always breaks on Solomon, rarely on GP.  Can you check your security setup, double click on the affected user(s), and check their company access tab.  I seem to remember the data source names changing, between legacy and data-mart deployments.

  • Suggested answer
    sueconrod Profile Picture
    sueconrod 337 on at

    Richard:

    If I get this error, t

    1.   take a look at your connection: Tools>>Connection and make sure that it is pointing correctly.  \\http:TS-CCA-01-###:4712

    2.  Go to a company and add your credentials and then set as default (can you do that as yourself or do you have to use 'sa'

    3.  Go to the console and make sure all your services are running:  Application and Process Service:  If not restart

     

    But normally when I do that I find out what the reason was

  • Suggested answer
    Richard Wheeler Profile Picture
    Richard Wheeler 75,852 Moderator on at

    It appears the issues was with the client. If I go to this client computer and log in to GP as 'sa' and set her password here I can then login into MR. It was not the connection to MR that was the problem is was the connection string to GP. Since the MR GP Legacy client is going away I also decided to deploy the GP Data mart. That would also solve the problem.

  • Community Member Profile Picture
    Community Member on at

    I think you found the cause of the issue. When the 'sa' user works but the individual users don't, that means there is a mismatch between the GP ODBC and the MR connection string. These are the two pieces that are involved in the encryption/decryption process that GP/MR use for GP users. The 'sa' credentials are never encrypted so that is why that account usually works. The data mart provider does not prompt for GP credentials so that is always a valid solution to this issue. If you wanted to resolve it using the legacy provider, you would need to address the mismatch using the KB below.

    https://mbs.microsoft.com/knowledgebase/KBDisplay.aspx?scid=kb;en-us;2737852

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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Stars!

Congratulations to our 2025 Community Spotlights

Thanks to all of our 2025 Community Spotlight stars!

Congratulations to the February Top 10 Community Leaders

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans