VERIFIED SOLUTION i

Resolve EngageOne Content Author installation - SQL authentication error

Products affected:  Content Author

Issue

During the Content Author installation, the following errors occurred authenticating in SQL:
1) Drop all active database connections failed for Server <server name>.
2) The user does not have permission to perform this action".

SQL had been set up as Mixed Mode (Wiindows & SQL authentication).

Cause

The cause for the SQL errors were due to insufficient privileges in SQL.

Resolution

UPDATED: March 29, 2017
Added sysadmin rights to the installer's Window's Group in SQL.