This article was created in response to a support issue logged with K2. The content may include typographical errors and may be revised at any time without notice This article is not considered official documentation for K2 software and is provided “as is” with no warranties.

Issue

Installing K2 against a pre-created database results in an error:

ImageImage

Image

The SQL Server database configuration test failed as databases of the wrong type exists

Symptoms

This is expected behavior. The K2 Installer currently does not support installation against a pre-created database. You must allow the K2 Installer (K2 Setup Manager) to create the database.

Additionally, the installation account (account performing the installation) will need to be part of the following SQL Server Roles:

dbcreator on the SQL Server.

securityadmin on the SQL Server.

http://help.k2.com/onlinehelp/k2five/icg/5.0/default.htm#Plan/Required_Permissions.htm?Highlight=dbcreator

Resolution

Deleting the pre-created database and allowing the K2 installer (K2 Setup Manager) to create the database resolved the issue.

If you would like this functionality to install against a pre-created database, please log or upvote this idea at:

https://ideas.k2.com