I have installed the Great Plains Client Application on my desktop and configured the ODBC drive to connect to the SQL Server with sa account and with default database as being the GP company database.
When I open Great Plains with my user account I get a message saying "The Login failed. Attempt to log on again or contact your System Administrator".
I have no problem loggin on to GP from the GP server with this specific user account, only when I try to connect to it from a client GP.
In addition if I enter the sa account in the GP client logon screen I am able to logon. This seems to be the only account that allows access to GP from the client application.
Any ideas? Thank you so much for your input!