Use UCYBCRYP.exe to encrypt the password uc4
This is done via
D:\Test>UCYBCRYP.exe -p -n uc4
D:\Test>
Edit the password.ucc to get the encrypted version of the password - нн10E9734BDAD2EC91FF3FE6CF198A2AAB32
The нн has to be removed from the encrypted password:
--10E9734BDAD2EC91FF3FE6CF198A2AAB32
The updated UCSrv.ini with SQLDRIVERCONNECT=ODBCVAR=SNNNNNRN,DSN=automicd;UID=automic;PWD=--10E9734BDAD2EC91FF3FE6CF198A2AAB32
The following error shows up in the wp log:
20191202/133832.459 - 27 U00003545 UCUDB: Opening database ...
20191202/133832.599 - 27 U00003611 DB OPEN executed. Return Code = '18456'
20191202/133832.599 - 27 U00003590 UCUDB - DB error: 'S0001', 'Login failed for user 'automic'. ClientConnectionId:6c1b39e8-9046-4ddf-8263-70768eb975d4', '18456', 'com.microsoft.sqlserver.jdbc.SQLServerException'
20191202/133832.599 - 27 U00032031 Error when connecting to Database
20191202/133832.615 - 31 U00003432 Termination of Server 'AUTOMICD#WP' initiated.
Using notepad ++ instead of notepad to edit password.ucc adds different characters
Component : AUTOMATION ENGINE
Use notepad instead of notepad ++