0

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?

Michel Klomp
  • 5
  • 4

1 Answers1

2

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.

adaptr
  • 16,576
  • 23
  • 34