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
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
Thanks Christopher, but this is a brand new install of MR and GP. No companies deleted, but that was a good thought.
Tom
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.
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
André Arnaud de Cal... 291,228 Super User 2024 Season 2
Martin Dráb 230,056 Most Valuable Professional
nmaenpaa 101,156