Product(s):	Keynetix
	Version(s):	1.0
	Area:	Assist

How to set the correct Collation when reinstalling SQL Express 20xx

Explanation

If for some reason you find yourself in the situation where you need to reinstall SQL Express, either due to a issue or a server change you will need to ensure you set the SQL express install to use the same collation that the HoleBASE Databases uses.

Process

By default the HoleBASE SI database will be set to the collation "Latin1_General_CI_AS". This collation is set when installing SQLExpress using the HoleBASESI installer. This is usually a local install on a single PC and just repeating the install should ensure the collation is correct.

If you install SQL manually on the server from the SQL download then the collation could be different to what the collation was in your original install.

To check this, open SQL management Studio, right click on your HoleBASESI database and go to "Properties. On the "General" tab you should see what collation the database is set to under "Maintenance".

Once you're happy you know what the collation of the database is and have backed up the databases you can install the new SQLExpress.

During the install you will get to the "Server Configuration" step where you set the "sa" password. In that step you will see a tab for "Collation"

Edit the collation there to match the collation of your databases and complete the install.