SQLServer Insights database connection creation issues

Products

• ConnectALL

Issue/Introduction

ConnectALL reports an error saying unable to create a database while creating Insights Connection.

Steps to Reproduce: 

1. Create a database user named insights_dbowner without dbcreator permission
2. Login to ConnectALL and try creating an Insights creation
3. ConnectALL reports an error saying unable to create database 
4. Create a database manually in the SQL Server with the database name as "Insights"
5. Attempt to create a connection again from ConnectALL
6. This time ConnectALL creates the tables and other artifacts in SQL Server but you will still get an exception still saving the connection
7. The next time you attempt to create the connection after giving the dbcreator permission the connection still fails. 

Expected Results: User should be able to create Insights DB connection fine.

Actual Results: You get error "Unable to create Database"

Environment

2.10.25 - 3.1.x

Cause

DE71936

Resolution

DE71936 is addressed in 3.2.0 version