ALERT: Some images may not load properly within the Knowledge Base Article. If you see a broken image, please right-click and select 'Open image in a new tab'. We apologize for this inconvenience.

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

book

Article ID: 226203

calendar_today

Updated On:

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 'ABC-USER\SIT-LAAAAAAA'. 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)

Cause

schema is created by default with the domain user "ABC-USER/D70097X"

Environment

Release : 10.6

Component : DevTest Application Test

Resolution

 

 

Create a new database with new schema without having hyphen in the name. '-'  (for example User: ABCUSER/D70097X)