Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics GP (Archived)

Connection failed in GP

Posted on by 450

I having problem login GP after I created new users.

at Server, create new user. (my ODBC setting connecting to server is using IP address. Ex: 10.1.6.248\ERP_DB)

user setting, I uncheck the Advanced SQL Server Options.

 

after created user, I go to workstation machine (ODBC Setting with IP address)

Unable for me to login. Login Failed.

Is anyone know what is the caused for the following problem?

 

 

*This post is locked for comments

  • Victoria Yudin Profile Picture
    Victoria Yudin 22,766 on at
    Re: Connection failed in GP

    Maggie,

    Try this as a test - log into GP as 'sa', then change the password for one of the users in GP (GP | Tools | Setup | System | User).  

    Now try to log into GP as that user.  If it works, the issue is that your ODBC settings (including the name) are not the same on the computer where you originally crated the users and this computer.  Unless they are identical, you will run into issues like this.  

  • Maggie Hong Profile Picture
    Maggie Hong 450 on at
    Re: Connection failed in GP

    yes. Only sa i can login

  • Victoria Yudin Profile Picture
    Victoria Yudin 22,766 on at
    Re: Connection failed in GP

    Maggie,

    Are you able to log in successfully as 'sa' on the workstation?

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,280 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,235 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans