Dynamics GP Utilities login error

Posted on 2009-02-19
Last Modified: 2012-05-06
We have recently installed Dynamics GP 9.0 onto a fresh Win 2k3 Server.
When we attempt to run Dynamics GP, it brings up the GP Utilities window login.
Regardless of what is entered in the username and password fields (correct or not), a message comes up stating the login failed.
Has anyone experienced this issue before? What login is it expecting here?
We have confirmed the sa username and password as being correct but it doesn't appear to check it.
Question by:IT-CS
    LVL 7

    Expert Comment

    by:James Glaubiger
    Can you please post a screenshot of the error message or the full text of the error?
    LVL 7

    Expert Comment

    by:James Glaubiger
    Also make sure that SQL has been configured correctly for TCP/IP connections.

    Expert Comment

    Was SQL installed in mixed mode?  Also, are you sure that you are using the proper DSN?  Was it a System DSN or a User DSN?  Screen shot would be

    Author Comment

    Hi Guys,

    I've attached GPerror.doc.
    This has the screen shots of what happens when running GP.
    In this instance I have entered the correct sa password and received that pop-up message. This message appers, however, no matter what is entered in the username and password fields.

    The SQL Server has the TCP/IP protocol enabled on the default port of 1433 - what else needs to be checked to "make sure that SQL has been configured correctly for TCP/IP connections."?

    Yes, SQL has been installed in mixed mode. The "LocalServer" is listed under the System DSN (see screenshot in attached) - is that what you mean?

    LVL 7

    Accepted Solution

    Please follow these steps to correctly setup an ODBC to GP.   You cannot use Local Server as the ODBC DNS.
    To set up an ODBC data source connection for SQL Server by using the ODBC data sources, follow these steps:
    1. To open the ODBC data sources window, click Start, and then click Control Panel. 
    2. Double-click Administrative Tools, and then double-click Data Sources (ODBC). 
    3. Click the System DSN tab, and then click Add to create a new ODBC data source. 
    4. Follow the appropriate step:" If the computer is running SQL Server 2000, select SQL Server, and then click Finish. 
    " If the computer is running SQL Server 2008 or SQL Server 2005, select SQL Native Client, and then click Finish.
    5. Provide an ODBC name and description. For "Server," enter the instance of SQL Server to which Microsoft Dynamics GP or Microsoft Business Solutions - Great Plains will connect. Then click Next.
    Note For the information that is required in this step, specify the following parameters:
    Name: Type the name that you want to use for the data source. This name is stored in the ODBC.ini file. If you use process servers, use the same name for the 32-bit ODBC Data Source for all client workstations.
    Description: Type a description of the data source. This field is optional.
    Server: Type the name that you assigned to the instance of SQL Server when you installed Microsoft SQL Server to run together with Microsoft Dynamics GP or together with Microsoft Business Solutions - Great Plains.  
    6. Click the With SQL Server Authentication using a login ID and password entered by the user option.
    Note We recommend that you enter the same name on all the workstations. This includes the server. For example, if you use server_name\instance as the name on the server, use that name on all the workstations. Do not use the IP address on some workstations and the server name on other workstations. 
    7. In the Connect to SQL Server to obtain default settings for the additional configuration options area, type the user name and password for the sa user.
    Note The sa user name and password are not required. However, we recommend that you use them. If the sa user name and password are entered, the credentials are not stored in the ODBC setup. 
    8. Click Client Configuration.  
    9. In the Network libraries section, click TCP/IP. Verify that the instance of SQL Server that you are using for or Microsoft Dynamics GP or for Microsoft Business Solutions - Great Plains appears in the Server alias section and in the Server name section. Verify that the Dynamically Determine Port box is cleared, and then enter the appropriate port number. Click OK, and then click Next.
    10. Clear all the options, and then click Next.
    Note Do not change the default database even if you will use this ODBC for only one company. 
    11. Clear all the options, and then click Finish. 
    12. Verify all the information, and then click Test Data Source. If the connection tests successfully, click OK. 
    13. Click OK two times to exit the ODBC Data Source Administrator. 

    Open in new window


    Author Comment

    Thanks opster,

    Have created ODBC to GP following the steps you outlined. I can now log in to the GP utilities using the new DSN cerated.

    The wizard runs and throws up the following error - actually I've attached the screen shot.

    What would cause this error?

    Author Comment

    This is a different issue that has to do with the collations and the sort orders of the DYNAMICS database and of the company database not matching the collations and the sort orders of the Microsoft SQL Server system databases.

    Will need to investigate that further. This question has been asnwered though - thanks opster.

    Featured Post

    Courses: Start Training Online With Pros, Today

    Brush up on the basics or master the advanced techniques required to earn essential industry certifications, with Courses. Enroll in a course and start learning today. Training topics range from Android App Dev to the Xen Virtualization Platform.

    Join & Write a Comment

    This is a walkthrough guide I wrote whilst upgrading my on-premise MS Dynamics CRM 3.0 deployment to 4.0. This covers the actual installation of the product to a working level for my system, I ran into a lot of issues that the steps below fixed so h…
    Automatically creating a Trello card using data from a Microsoft Dynamics CRM record turned out to be an easy project that yielded great results.  Here's how I did this for an internal team at General Code.
    To add imagery to an HTML email signature, you have two options available to you. You can either add a logo/image by embedding it directly into the signature or hosting it externally and linking to it. The vast majority of email clients display l…
    Internet Business Fax to Email Made Easy - With eFax Corporate (, you'll receive a dedicated online fax number, which is used the same way as a typical analog fax number. You'll receive secure faxes in your email, fr…

    733 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    22 Experts available now in Live!

    Get 1:1 Help Now