SQL Server error during vRA Simple Install

[atoerper]

The installer fails on the Database Role.

Examining the logs on the IaaS server show the following:

"C:\Program Files\Java\jre8\jre1.8.0_161\bin\java.exe"  -Djsse.enableCBCProtection=false -Djava.library.path="C:\Program Files (x86)\VMware\vCAC\Server\Database" -cp "liquibase.jar;jtds-1.3.1.jar" liquibase.integration.commandline.Main --driver=net.sourceforge.jtds.jdbc.Driver --url=jdbc:jtds:sqlserver://XXXXX/"XXXXX";instance=XXXXX;user=xxxx;password=******;ssl=request releaseLocks

Info : [UTC:2018-07-31 20:00:44 Local:2018-07-31 16:00:44] :  Liquibase releaseLocks Failed: liquibase.exception.DatabaseException: java.sql.SQLException: Login failed for user 'xxxxxxx'.

We have verified the username and PW is correct. This is a pre-created database that uses SQL authentication. I have tested credentials by creating a dummy ODBC connections and the test passes. Also, earlier in the install wizard, the SQL database is verified and passes with the same credentials.

This is SQL 2016 and we had found that the DB was in 130 compatibility mode. Changed it to 120 comparability mode and the same results occur.

[GayathriS]

Hi

I have experienced this and the problem was with NTLM was disabled.

We re-enabled NTLM inbound and outbound in security policies and database was created successfully.

Can you check on that ?

Please consider marking this answer as "correct" or "helpful" if you think your questions have been answered.

[atoerper]

We restarted the install from scratch and allowed vRA to create the Database rather than using a pre-created empty one. This worked