«
»

Dynamics GP Utilities and Server Name Change Problems

During the login process on the Microsoft Dynamics GP software, we are able to choose a server to connect to, but actually using ODBC connection name.

However, it seems that the Dynamics GP Utilities uses the name of the server itself and not the ODBC name, so we should change the server name using the following commands:

sp_dropserver old_name
GO

sp_addserver new_name, local
GO

This doesn’t take effect until the SQL Server is stopped, and then re-started. Then SELECT @@SERVERNAME should return the server name, and the Dynamics GP Utilities should get past the login process.

Tags: ,

This entry was posted on Tuesday, March 10th, 2009 at 8:52 am and is filed under Dynamics GP Development. You can follow any responses to this entry through the RSS 2.0 feed. You can leave a response, or trackback from your own site.

One Response to “Dynamics GP Utilities and Server Name Change Problems”

  1. odbc server Says:
    March 24th, 2010 at 2:54 pm

    [...] system might be in RDBMS like Oracle or ERP’s like SAP. One of the examples is Leave Management …Dynamics GP Utilities and Server Name Change Problems …During the login process on the Microsoft Dynamics GP software, we are able to choose a server to [...]

Leave a Reply