web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / Login Failed DYNAMICS ...
Microsoft Dynamics GP (Archived)

Login Failed DYNAMICS GP Client via ODBC SQL Server Client

(0) ShareShare
ReportReport
Posted on by Lewis Almonte 290

 I am installing MS-DYNAMICS GP 10.0 client via ODBC using SQL Server Client Connection. This connection works using the SA user and it works flawlessly.

 

My version of DB is MS-SQL Server Standard Edition 2005.

 

We created the DYMAMICS GP user and granted all required permissions (public role, Access to Dynamics and Master SQL server Data Base) and its respective password, but as soon as we start the client installation and configuration and right at the moment of logging in GP, the GP utilities start running but it stops and report the following error:

 

"Your attempt to log in to the server failed because an unknown error occurred when the user ID and Password were being verified. Attempt to login again".

 

We are certain that the user and password are correct, as we have successfully been able to log in to the application directly from the server. So, if I do it from the server the log on works, but doing it from the client the error pops up.

 

What can I do?  

Regards,

 

 Lewis Almonte Hdez.

*This post is locked for comments

I have the same question (0)
  • Mayra Humprey Profile Picture
    Mayra Humprey 3,125 on at

     Hello Lewis,

    What OS are you running?

     Please double check the following steps and let me know:(if it's XP then)

    1.- go to start> control panel> administrative tools> Data origens (ODBC)> DSN system> Add

    2.-  In name= "????" server = 192.168.?.? then> next

    3.-  mark the option with authentication of SQL server>press the cliente configuration button> tick of the "determine the number of the port" > in the port number put 1882 then > next

    4.- tick on connect to SQL server and then write the user id of (SQL) and the password then press > next

    5.-  tick off all the check marks (ANSI and data conversion) then >finish

    6.- Then press the button test data origen twice, make sure it says " completed test ..."

  • Mayra Humprey Profile Picture
    Mayra Humprey 3,125 on at

     after the other steps i sent you then run the microsoft dynamics utilities, make sure no users are logged on

  • Community Member Profile Picture
    Community Member on at

    Are you definately using SQL Server Native Client ODBC.

    Are you on version 10 GP?

  • Lewis Almonte Profile Picture
    Lewis Almonte 290 on at

     Hi.

    Yes, I using SQL Server Native Client ODBC and Microsoft GP 10.0. on MS-SQL Server 2005 Standard Edition.

    I do the test of the ODBC Connection and  all y successfully, but when I tried ti run the GP Utilities with other users created on DYNAMICS GP Server, the login is failed.

    Regards,

     

    Lewis A.

  • Lewis Almonte Profile Picture
    Lewis Almonte 290 on at

     Hello Mayra:

     I have MS- Windows XP 2002 Service Pack 3.

    After this configuration, the connection to run the GP Utilities continue failed with the other users create on GP.

    Question: The password on GP is the same password on MS- SQL Server Database ?

     Regards,

     Lewis

  • L Vail Profile Picture
    L Vail 65,271 on at

    Are you using a 64 or 32-bit machine? The ODBC drivers are different when working with GP.

  • Mayra Humprey Profile Picture
    Mayra Humprey 3,125 on at

     Hello Lewis,

     Please confirm the following:

    1.- Run SQL server management studio express> 

    server type= database engine

    Server name: XXXXX\SQLEXPRESS

    Authentication: SQL Server Authentication

    Login: sa

    Password: xxxxx

     If so then the password of sa (system administrator) is the same of the SQL server database 

    Please keep me posted

     

  • Lewis Almonte Profile Picture
    Lewis Almonte 290 on at

    Hi L Vail:

    I 'm using 32 bit machine.

  • Community Member Profile Picture
    Community Member on at

    Hi Lewis,

    When you say you created the DYNAMICS GP user - hoe did you create the user? Through SQL or Dynamics GP interface? (Its just that you mention assigning rights and this is done automatically when you create the user through Dynamics - Tools >> Setup >> System >> User)

    Best regards,

  • Lewis Almonte Profile Picture
    Lewis Almonte 290 on at

    Hi Ian:

     Yor are rirght !!..

    I create de user Throught DYNAMICS GP Interface.

    Regards,

     

    Lewis Almonte

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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

#1
mtabor Profile Picture

mtabor 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans