Home » blog » zjaneliunas's blog

SQL Server Collation Error when installing iMIS

Posted July 9th, 2009 by zjaneliunas

 

I have installed SQL on my laptop and am getting the following message: 
 
Server collation (Latin1_general_CI_AS) does not match the EmptyDB database collation (SL_Latin1_General_CP1_C1_AS)
 
can anyone tell me how I can fix this issue:
 
 
 
 
416-277-7167 (cell)
416-247-4652 (home office)
zjaneliunas's blog | login or register to post comments | printer friendly version

Comment viewing options

Select your preferred way to display the comments and click "Save settings" to activate your changes.

iMIS database collation must match master database

On July 12th, 2009 lpapageorgiou says:

The iMIS database collation must match the collation of the SQL server. The empty database gets created using SQL_Latin1_General_CP1_C1_AS so it will only work if you install SQL server using this collation.
This was reported as an issue when iMIS15 first came out, but it does not look like it has been fixed.

You will have to re-install SQL Server on your laptop with that collation.

login or register to post comments

SQL SERVER COLLATION

On July 12th, 2009 zjaneliunas says:

When I install it there is no choice for that collation that I can find .   Any idea which one I should use?

 

zz

login or register to post comments

SQL Collation

On July 12th, 2009 lpapageorgiou says:

I think you need to select this one:
Dictionary order, case-insensitive, for use with 1252 character set.

login or register to post comments