Configuring a Microsoft Dynamics GP Data Mart integration fails when you specify a nondefault SQL Server port

Symptom
When you try to configure a Microsoft Dynamics GP Data Mart integration by using Microsoft Dynamics GP 2013 SP2 and Microsoft Management Reporter 2012 and then specify a port number other than 1433 in name field for the instance of Microsoft SQL Server, the configuration fails. Additionally, you may receive the following error message:

Couldn't retrieve the list of available databases: The connection attempt failed.
Cause
Dexterity Shared Components SP2 (12.0.270.0) made a change to the Microsoft Dynamics GP logon function that is used by Management Reporter that removes the port number in the connection details and tries to make the connection to the instance of SQL Server over the default port of 1433.
Resolution
To effectively circumvent the issue, use one of the following methods, depending on whether the instance of SQL Server on which the Microsoft Dynamics GP databases reside is using a named instance:
  • If the instance of SQL Server on which the GP databases reside is using a named instance, follow these steps:
    1. In SQL Server Configuration Manager, start the SQL Server browser service.
    2. Open port 1434 (UDP) in the firewall for the instance of SQL Server.
  • If the Microsoft Dynamics GP instance of SQL Server is using a default instance together with a nondefault port, create a SQL Server alias on the server on which Management Reporter 2012 is installed. To do this, follow these steps:
    1. Select Start, click Run, type cliconfg.exe, and then press Enter. Note If MR is installed on a 64-bit server, you must create a 32-bit and 64-bit alias.
      • For 32-bit, go to C:\Windows\System32\cliconfg.exe
      • For 64-bit, go to C:\Windows\SysWOW64\cliconfg.exe
    2. In Client Network Utility, click the Alias tab, and then click Add.
    3. On the Add Network Library Configuration page, select the TCP/IP radio dial, and then enter a name for the SQL Server alias. For example, type MRConnect.
    4. Enter the SQL Server name.
    5. Click to clear the Dynamically determine port check box, enter the port number for the instance of SQL Server, and then click OK.
    6. Enter the Microsoft Dynamics GP Data Mart integration information in the configuration console for Management Reporter 2012 by using the alias that you created for the Microsoft Dynamics GP SQL Server field.
More Information
Dexterity Shared Components SP1 (12.0.232.0) does not cause this issue if a nondefault port is being used to connect to the instance of SQL Server.
Properties

Article ID: 2932875 - Last Review: 05/05/2016 15:46:00 - Revision: 3.0

Microsoft Dynamics GP 2013

  • KB2932875
Feedback