up vote 0 down vote favorite
share [g+] share [fb]

We have a two node active-active SQL Server 2008 Cluster. Running on Windows Server 2008 R2.

The three excisting instances have Latin1_General_CI_AS as the Server Collation. I need to add an instance with SQL_Latin1_General_CP1_CI_AS as the Server Collation.

Is this a supported configuration?

link|improve this question
feedback

1 Answer

up vote 2 down vote accepted

Every MSSQL Server instance is a complete, stand-alone database server system.

The Server collation is, therefore, unique to each instance.

This is obvious when you install an instance - you can specify the server collation at that moment.

link|improve this answer
feedback

Your Answer

 
or
required, but never shown
discard

Not the answer you're looking for? Browse other questions tagged or ask your own question.