Encountering DB issue while installing DEVTEST and connecting to MS SQL server 2016-incorrect syntax near '-'

Products

• Service Virtualization

Issue/Introduction

10.6 is being installed , I am seeing an error while connecting to DB details while installing. 

 

    at org.jboss.threads.JBossThread.run(JBossThread.java:320) Caused by: com.microsoft.sqlserver.jdbc.SQLServerException: Login failed for user 'USER1\DOMAIN'. ClientConnectionId:a60da628-f29d-4637-9a2f-324832866b69     at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(SQLServerException.java:216)     at com.microsoft.sqlserver.jdbc.TDSTokenHandler.onEOF(tdsparser.java:254)     at com.microsoft.sqlserver.jdbc.TDSParser.parse(tdsparser.java:84)     at com.microsoft.sqlserver.jdbc.SQLServerConnection$1LogonProcessor.comp

Caused by: liquibase.exception.CustomChangeException: Failed to add realm code secret
    at org.keycloak.connections.jpa.updater.liquibase.custom.AddRealmCodeSecret.generateStatements(AddRealmCodeSecret.java:78)
    at liquibase.change.custom.CustomChangeWrapper.generateStatements(CustomChangeWrapper.java:178)
    ... 62 more
Caused by: com.microsoft.sqlserver.jdbc.SQLServerException: Incorrect syntax near '-'.
    at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(SQLServerException.java:216)
    at com.microsoft.sqlserver.jdbc.SQLServerStatement.getNextResult(SQLServerStatement.java:1515)

Environment

Release : 10.7 or user

Component : DevTest Application Test

Cause

schema is created by default with the domain user "USER-1\DOMAIN" . The name had a hyphen '-'  

Resolution

 

 

Create a new database with new schema without having hyphen in the name. '-'  (for example User: USER\DOMAIN)