I have a new install of Dynamics GP2015 in a terminal server environment, installed on SQL Server 2012 using SQL Server Authentication. The 'sa' login works fine when launching SQL Management Studio but when attempting to login to GP I receive the following:
All other users can log in including DYNSA. In addition, I'm not able to add companies in the new install of Management Reporter which I assume is related.
Thanks in advance!
Debi
*This post is locked for comments
Verify that your sa password is 15 characters or less.
Same problem facing after new installing Dynamics GP 2015 with SQL 2014 ,error says " this login failed Attempt to log in again or contact your system administrator kindly guide me .... :( :(
your SQL Server sa password ? You need to entered there.
How you created ODBC?
Tks
Sandip
I just checked GP 2010 and GP 2010 Utilities login windows and they also have the same login issue than GP 2013 and GP 2015.
Here there is a link of a post related to this problem which give further explanation of the problem:
Great post Sandip!
As you know Dynamics GP and Dynamics GP Utilities each has its own dictionary, therefore 2 fields from 2 different files with different Datatypes which SHOULD be the same.
I thought it was just a GP 2015 issue, but you mentioned in your post it is also a GP 2013 R2 issue.
I wonder if the problem also exists in GP 2010.
Just for your information I was facing same issue few days before. I have documented in my blog. : sandipdjadhav.blogspot.com/.../dynamics-gp-sql-password-something.html
Why utilities allow to enter password more than 15 character?
Tks
Sandip
No problem, I am glad you solved the problem
That was it, I changed the password to 13 characters and I'm in. Thanks for the information and the quick response.
Change the password to no more than 15 characters. This should solve your problem, it worked for me.
There is a mismatch between the keyable length for the login password between Dynamics GP Utilities login and Dynamics GP login windows.
The maximum length of the datatype for the password in the Dynamics GP Utilities login window is 30, while the maximum length of the datatype for the password in the Dynamics GP login window is 15, therefore you have to go for the shortest length.
Please Verify this answer if it has been useful to you. This could help others trying to solve the same or similar problem.
#1
André Arnaud de Cal...
292,516
Super User 2025 Season 1
#2
Martin Dráb
231,317
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (
