ARD: Error while installing ARD HUb 3.2 in Windows 2019

Products

• CA Agile Requirements Designer

Issue/Introduction

Hello,

I am installing ARD HUb 3.2 manually on Winodws 2019 Server , MS SQL Server Version 2017

using instructions from Install ARD Hub Manually (broadcom.com)

 

I am getting below error at 

Run the setup script.
> HUB_HOME/keycloak/keycloak-setup.bat

21:39:56,190 FATAL [org.keycloak.services] (ServerService Thread Pool -- 59) Error during startup: org.keycloak.connections.jpa.updater.liquibase.lock.LockRetryException: liquibase.exception.DatabaseException: CREATE TABLE permission denied in database 'keycloak'. [Failed SQL: CREATE TABLE [dbo].[DATABASECHANGELOGLOCK] ([ID] [int] NOT NULL, [LOCKED] [bit] NOT NULL, [LOCKGRANTED] [datetime2](3), [LOCKEDBY] [nvarchar](255), CONSTRAINT [PK_DATABASECHANGELOGLOCK] PRIMARY KEY ([ID]))]

 

Environment

Release : 3.2

Component : ARD Installation

Resolution

       Please verify the user account for keycloak database and give full permissions to create/alter/drop the tables. After changing the permissions, restart the keycloak to resolve this issue.