Development Matters Blog

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.