Skip to main content

Notifications

Microsoft Dynamics GP (Archived)

MR2012 CU7 New install

Posted on by

Hello,

I am doing a new install for MR and having issues in the configuration console.

The only thing unusual about this install is that SQL lives on a non-default port, (1469).

When I get to the Dynamics GP connection information and click the dropdown to choose DYNAMICS, it comes back with the message "Couldn't retrieve the list of available databases: The connection attempt failed"

My ODBC is configured with Server Name, 1469 and I am able to use this to get into GP2013.

I've specified the same connection in the Configuration Console for the database server and I'm using the sa account.

Has anyone seen this before? there are no events in Event viewer or SQL error logs.

I was going to open a support case, but thought I would check with the community first.

 

thanks everyone.

*This post is locked for comments

  • Amit Thakkar Profile Picture
    Amit Thakkar on at
    RE: MR2012 CU7 New install

    In a word, the reason that we get this error message is the client stack could not receive SSRP response UDP packet from SQL Browser. It's easy to isolate the issue. Here are the steps:

    1) Make sure your server name is correct, e.g., no typo on the name.

    2) Make sure your instance name is correct and there is actually such an instance on your target machine. [Update: Some application converts \\ to \. If you are not sure about your application, please try both Server\Instance and Server\\Instance in your connection string]

    3) Make sure the server machine is reachable, e.g, DNS can be resolve correctly, you are able to ping the server (not always true).

    4) Make sure SQL Browser service is running on the server.

    5) If firewall is enabled on the server, you need to put sqlbrowser.exe and/or UDP port 1434 into exception.

    Please verify other option from this link.

    blogs.msdn.com/.../sql-network-interfaces-error-26-error-locating-server-instance-specified.aspx

  • Tom Keller Profile Picture
    Tom Keller on at
    RE: MR2012 CU7 New install

    Thanks Christopher, but this is a brand new install of MR and GP. No companies deleted, but that was a good thought.

    Tom

  • Christopher Wan Profile Picture
    Christopher Wan 155 on at
    RE: MR2012 CU7 New install

    Have you deleted any companies through SQL in the past. I have seen this issue before and the Dynamics database was looking for companies that were no longer in SQL. I ran the clear companies script from Partnersource and that resolved the issue. If you are doing this in live make sure that you backups before proceeding.

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

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Community AMA December 12th

Join us as we continue to demystify the Dynamics 365 Contact Center

New! Quick response templatesâš¡

Save time with the new custom templates!

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,228 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,056 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans