I have a SQL instance with the collation Latin1_General_CI_AS_KS_WS for SharePoint Server SE. Is it possible to install K2 on the same instance by manually creating the K2 databases with the required collation (Latin1_General_CI_AS)? When I try this, I get the following warning message .And when I click 'Continue', I get another message: 'K2 is the wrong type of database'."
K2 Installer and SQL Collation
+1
Hi,
I usually go the other way around – I request the collation required by K2 (Latin1_General_CI_AS) for the SQL instance, which is also acceptable for SharePoint. I have never created a clean K2 database manually.
Don't waste time, install a new SQL instance with collation for K2, migrate the SP databases to it, and install K2 alongside them.
+1Hi
Thank you for your response. Unfortunately, SharePoint has already been in place for some time. So it's actually K2 that needs to be added to the existing SharePoint instance.
If I understand correctly, I now have to enforce the creation of a new instance exclusively for K2??
Hi,
Well, if the K2 database is to be hosted on a supported SQL instance, then I would say that you have no other option than to request a new separate SQL instance with the required collation.
Changing the collation on the existing SQL instance for SharePoint is simply not possible.
It would be easier and safer to request a new SQL instance with the collation required by K2 and use PowerShell and the dbatools module to migrate SharePoint logins and databases between SQL instances, then just change the SQL alias on the SharePoint servers, if it is used there, and everything will continue to work. The old SQL instance can be uninstalled.
Good luck
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.