Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / gp 2010 login from cli...
Microsoft Dynamics GP (Archived)

gp 2010 login from client failed

(0) ShareShare
ReportReport
Posted on by sean gp 85

 

server1: gp 2010/sql 2008/r2 

server2: gp2010/r2/terminal server

client1: gp2010/win7 64bit

1. all systems configured 32bit odbc with user sa. odbc testing returns ok on all computers

2. i can login to gp using user id 'sa' from all computers. 

3. from gp/tools/setup/system/user, create new user, 'user1'

4. i can login to gp as 'user1' from server1

5. but i can not login to gp as 'user1' from server2 or client1

 

here is tracing from odbc sql log on client1 

 

Dynamics.exe" D 1fa8-1f18 ENTER SQLConnectW 

HDBC                0x00F9ECA0

WCHAR *             0x027A1E68 [      -3] "Dynamics GP 2010\ 0"

SWORD                       -3 

WCHAR *             0x732C8BB4 [      -3] "******\ 0"

SWORD                       -3 

WCHAR *             0x732C8BB4 [      -3] "******\ 0"

SWORD                       -3 

Dynamics.exe" D 1fa8-1f18 EXIT  SQLConnectW  with return code -1 (SQL_ERROR)

HDBC                0x00F9ECA0

WCHAR *             0x027A1E68 [      -3] "Dynamics GP 2010\ 0"

SWORD                       -3 

WCHAR *             0x732C8BB4 [      -3] "******\ 0"

SWORD                       -3 

WCHAR *             0x732C8BB4 [      -3] "******\ 0"

SWORD                       -3 

DIAG [28000] [Microsoft][SQL Server Native Client 10.0][SQL Server]Login failed for user 'user1'. (18456)

have been working on this for 2 days and no progress. 

thank u for ur help

 

 

 

*This post is locked for comments

  • Harry Saryan Profile Picture
    Harry Saryan 190 on at
    Re: gp 2010 login from client failed

    Stupid question, are you using SQL Express version by any chance-?  If so, make sure SQL protocol TCP/IP is enabled. Also make sure SQL Server Browser service is running.  I understand the ODBC test passes, but make sure your ODBC connection is not using 'Integrated Windows Authentication", and make sure there are no default databases assigned to the ODBC.

    And last but not least, do you think the ports on the server are either being used by some other service OR the ports are maybe being blocked by a FW-?  Stop any security services, and try again.

  • Beat Bucher GP Geek GPUG All Star Profile Picture
    Beat Bucher GP Gee... 28,021 Super User 2024 Season 1 on at
    Re: gp 2010 login from client failed

    Hi Sean,

    You'll hit here a big problem related to the encryption algorythm that is used by GP and SQL 2008... The Native SQL client that you use from the client workstation can connect to the server with the password where it was created.. not  to the other one. Do a search accross the Microsoft KB, you'll be able to find about the encryption of the password which uses the Server's name in the algorythm...

    I'll try to find the article if I have some time.

    HTH,

  • Victoria Yudin Profile Picture
    Victoria Yudin 22,766 on at
    Re: gp 2010 login from client failed

    Sean,

    Based on your description, I am assuming client1 connects to server2 via rdp, then you go into GP on server2?  If so and you are able to connect on server2 as 'sa', but not another GP user, that would suggest your ODBC is not named exactly the same on server2 as it is on server1, where you created the user.

    To test this - log into GP on server 2 as 'sa' and create a brand new GP user.  Now log into GP as that new user on server2 - should work with no problem.  Now try logging into GP as that new user on server1 - should not work.  

    The fix is to create a new ODBC on server2 with the same exact name as the ODBC on server1.

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,214 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans