Sarah Weinberger
IS-IT--Management
Macola 7 is successfully installed and working several computers. I installed Macola on an additional computer. The problem is that on this particular computer, Macola 7 fails to authenticate the <user>_SQL password. I enter the Macola user name and password. I then get the company drop down list populated. I can then view the explorer, however double clicking on any item throws an login failure, specifically a password mismatch. From the SQL error log off of the server:
2017-09-06 12:50:01.02 Logon Error: 18456, Severity: 14, State: 8.
2017-09-06 12:50:01.02 Logon Login failed for user 'SAN_SQL'. Reason: Password did not match that for the login provided. [CLIENT: <named pipe>]
On this particular system, no user name works, not even the Supervisor account. I can go to any other computer and successfully log in. As such, I know the password is fine. From what I am able to gather, it looks like some sort of SQL configuration on this particular computer. I checked the MACOLA7.ini file on the %ProgramData% folder (Macola uses that rather than the one in the %WinDir% folder), but did not see anything stand out.
What can the problem be?
2017-09-06 12:50:01.02 Logon Error: 18456, Severity: 14, State: 8.
2017-09-06 12:50:01.02 Logon Login failed for user 'SAN_SQL'. Reason: Password did not match that for the login provided. [CLIENT: <named pipe>]
On this particular system, no user name works, not even the Supervisor account. I can go to any other computer and successfully log in. As such, I know the password is fine. From what I am able to gather, it looks like some sort of SQL configuration on this particular computer. I checked the MACOLA7.ini file on the %ProgramData% folder (Macola uses that rather than the one in the %WinDir% folder), but did not see anything stand out.
What can the problem be?