Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Macola SQL Login Authenticate Failure, Password Mismatch

Status
Not open for further replies.

Sarah Weinberger

IS-IT--Management
Sep 6, 2017
1
0
0
US
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?
 
I would run cliconfg to make sure the SQL client protocols are enabled, particularly TCP/IP. If that doesn't sort it out let us know, this has got to be an easy one.

Software Training, Implementation, Programming and Support for Macola Progression, Macola ES, Macola 10, Synergy, and Crystal Reports.
Check out our Macola tools:
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top