SQL server integration with DevTest throws error "Cannot open database login failed"

Products

• CA Application Test
• CA Continuous Application Insight (PathFinder)
• Service Virtualization

Issue/Introduction

Configured dradis.properties for SQL SERVER Database with integrated security. When you try to start the ED, getting the below error 

com.microsoft.sqlserver.jdbc.SQLServerException: Cannot open database "DevTestDashboard" requested by the login. The login failed. ClientConnectionId:1d0f9e69-193a-4101-be6f-4ae0fc189cfe 
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.sendLogon(SQLServerC 

Environment

All Supported DevTest environments 

Cause

User did not have DBA privileges. 

Resolution

When setting the MQ SQL Connections in the dradis.properties file for the Enterprise Dashboard, the USER to start the Enterprise Dashboard must have DBA priviledge the first time the tables are created.