Selecting the right collation when setting up your SQL Server instance for your System Center 2012 SP1 components

Microsoft System Center 2012 SP1 is a great product for managing your modern private cloud. The System Center suite has been moving closer and closer together in integration with one another, and I believe that this will continue to be the trend for obvious benefits of a tightly integrated solution. For now, in my opinion, they are rather involved to setup and integrate together, but for what they deliver I believe it is well worth the trouble. Which is why I am investing in my MCSE Private Cloud certification. 🙂

However, in working to integrate the components in my lab environment I found that selecting the right collation (ex. SQL_Latin1_General_CP1_CI_AS)  for your SQL Server instance is paramount unless you want to encounter issues when linking them together. This turn out to be a rather deep issue after searching online and comparing system requirements for the System Center components, and I came upon a very helpful and informative article, “Clarification on SQL Server Collation Requirements for System Center 2012” by Travis Wright at Microsoft. I recommend reading this article as I cannot explain it any better.

I will say, this little Collation tab has never stood out so much until now.