MC CSA 5.2 - SQL Server collation

Unanswered Question
Jun 4th, 2008

Hi!:

I am installing MC CSA 5.2 with a remote SQL database.

I received a error about database collation. I have a database with a collation which isn't Latn1_General_CP1_CI_AS and I want to use because I have another database.

Is it possible install MC CSA 5.2 with a database collation different to this?

I didn't find any document with this prerequisite.

Thank you

Alex

I have this problem too.
0 votes
  • 1
  • 2
  • 3
  • 4
  • 5
Overall Rating: 0 (0 ratings)
Loading.
tsteger1 Fri, 06/06/2008 - 15:41

Were you not able to set Latin1_General collation when you created the CSAMC52 DB prior to installing the CSAMC?

The DB server may have a default collation other than Latin1_General but each database can have it's own collation.

It defaults to the server collation if you don't choose one when creating the database.

Tom

jlana Sun, 06/08/2008 - 23:25

Hi Tom!:

I have a CSAMC52 DB created. This DB haven't Latin1_General collation then I run a fresh MC CSA 5.2 installation. When I put DB parameters I received this message:

Database collation must be Latin1_General_CP1_CI_AS and I can not continue with installation.

I don't want to install another database instance with Latin1_General_CP1_CI_AS collation (problem with licenses). I need install MC CSA 5.2 with DB wich I have . I want to exchange collation.

Thank you

Alex

tsteger1 Mon, 06/09/2008 - 08:43

Hi Alex, as far as I know, you don't need a new instance of SQL Server.

When you create a new DB on an existing server you have the option of choosing collation. If you don't specify one it chooses whatever the server collation is.

You need to delete the CSAMC52 DB you previously created and create a new one on the same server and choose Latin1 collation.

Then it should work as expected.

Tom

Actions

This Discussion