I'm really in a bind here and don't know what to do. We are new users of Dynamics GP and don't have much experience. Our installation is part of a solution from a third party but they're not much help.
In my test system, when I sign on as DYNSA, I get "This login failed. Attempt to log in again or contact your system administrator". I signed on to GP as sa and reset the password for DYNSA but am still getting the error. I edited C:\Program Files\Microsoft Dynamics\GP2013\Data\Dex.ini and set the following lines:
SQLLogSQLStmt=TRUE
SQLLogODBCMessages=TRUE
SQLLogAllODBCMessages=TRUE
I tried to login, got the failure and found the following in the DEXSQL.LOG file:
/* Date: 07/27/2016 Time: 12:12:16
SQLSTATE:(28000) Native Err:(18456) stmt(0):*/
[Microsoft][SQL Server Native Client 11.0][SQL Server]Login failed for user 'Dynsa'.*/
/*
/* Date: 07/27/2016 Time: 12:12:16
SQLSTATE:(00000) Native Err:(18456) stmt(0):*/
*/
/*
/* Date: 07/27/2016 Time: 12:12:16
SQLSTATE:(00000) Native Err:(18456) status(24):*/
SWSTATUS DUMP*/
Oddly, if I run SQL Server Management Studio, I can sign on as DYNSA. Finally, the really frustrating part is that this worked last week! Of course nobody will admit to making any changes so I'm not sure what the cause is. ANY recommendation on what to check would be greatly appreciated.
Ken
