Launching soon: The world's first vendor agnostic bug scrubLearn more & join waitlist
OPERATIONAL DEFECT DATABASE
...
...
When we configure the SQL DB for the Horizon event database it fails with the error: "An error occurred while trying to configure the database and make sure the database is not inactive during restart or unavailable" Implementing Configuring Horizon View Event Database fails (53034 ) does not help SQL Server Log shows password invalid and cannot log in. We can authenticate ODBC or through SQL Management Studio with the same username and password Log Messages on The Horizon Server show: 2021-06-18T17:05:11.539+02:00 DEBUG (280C-32A4) <ajp-nio-127.0.0.1-8009-exec-7> [RestApiServlet] Exception for uri /view-vlsi/rest/v1/EventDatabase/update com.vmware.vdi.logger.Logger.debug (Logger.java:44) com.vmware.vdi.vlsi.rest.exceptions.ViewServiceFaultException: (vdi.fault.InvalidRequest) { errorMessage = {#DATABASE_CONNECTION_FAILED#} Unable to update database settings; database connection failed: Unable to create events tables: Invalid column name 'name'. } errorMessage = {#DATABASE_CONNECTION_FAILED#} Unable to update database settings; database connection failed: Unable to create events tables: Invalid column name 'name'. } at com.vmware.vdi.vlsi.server.util.FaultUtilBase.createInvalidRequest(FaultUtilBase.java:313) at com.vmware.vdi.vlsi.server.util.FaultUtilBase.createInvalidRequestWithErrorCode(FaultUtilBase.java:337) at com.vmware.vdi.vlsi.server.infrastructure.EventDatabaseManager.update(EventDatabaseManager.java:248) at com.vmware.vdi.vlsi.server.infrastructure.EventDatabaseServer.update(EventDatabaseServer.java:32) at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(Unknown Source) at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source) at java.base/java.lang.reflect.Method.invoke(Unknown Source) at com.vmware.vdi.vlsi.rest.service.impl.VlsiMethodWrapper.invoke(VlsiMethodWrapper.java:49) at com.vmware.vdi.vlsi.rest.reflect.impl.VlsiInvocation.invoke(VlsiInvocation.java:81) ... 33 more SQL Server Log Show: 06/18/2021 16:27:57,Logon,Unknown,Login failed for user '<username>'. Reason: Failed to open the explicitly specified database '<eventDbname>'. [CLIENT: 172.xx.xx.xx] 06/18/2021 16:27:57,Logon,Unknown,Error: 18456<c/> Severity: 14<c/> State: 38. 06/18/2021 16:27:57,Logon,Unknown,Login succeeded for user '<username>'. Connection made using SQL Server authentication. [CLIENT: 172.xx.xx.xx] 06/18/2021 16:26:02,Logon,Unknown,Login failed for user '<username>'. Reason: Password did not match that for the login provided. [CLIENT: 172.xx.xx.xx] 06/18/2021 16:26:02,Logon,Unknown,Error: 18456<c/> Severity: 14<c/> State: 8.
This article helps you to understand the additional requirement during SQL installation while using the SQL server on local language platform
JDBC login instructions / call from JDBC will be denied or the table name not translated correctly
Cannot configure the Event DB on Horizon
Re-install the SQL application using the correct collation type or change the database collation. [ Example: While using French use [ French_CI_AS ]For more information please refer to Microsoft Documentation: Set or change the database collation
N/A