"Databases of the wrong type exist" error appears when installing K2 against a pre-created database.

  • 16 February 2021
  • 0 replies
  • 210 views

Userlevel 3
Badge +10
 

"Databases of the wrong type exist" error appears when installing K2 against a pre-created database.

kbt140634

PRODUCT
K2 Five
BASED ON
K2 Five (all)
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.
LEGACY/ARCHIVED CONTENT
This article has been archived, and/or refers to legacy products, components or features. The content in this article is offered "as is" and will no longer be updated. Archived content is provided for reference purposes only. This content does not infer that the product, component or feature is supported, or that the product, component or feature will continue to function as described herein.

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


0 replies

Be the first to reply!

Reply