0

We are trying to define a parametric IAAS SQL Server setup.
But we require a different collation than the default sql_latin01_general_cp1_ci_as.

I can't seem to find it in the json template / parameter or as a parameter in the Powershell.

Is there a way to define a different collation when setting up a IAAS SQL Server for Azure?

Reaces
  • 5,597
  • 4
  • 38
  • 46
  • What do you mean of `collation`. If my understanding is right, you want to classify the database, you could use use [tags](https://docs.microsoft.com/en-us/azure/azure-resource-manager/resource-group-using-tags) to organize your SQL server. – Shui shengbao May 17 '17 at 07:47
  • @Walter-MSFT What I mean by collation, is the default collation of the SQL Server instance that comes pre-installed with the Windows server. The reason we need to be able to define this dynamically is because we support a variety of applications. Some of which such as the version of Citrix our supplier supports require a specific collation. – Reaces May 17 '17 at 11:20
  • @Walter-MSFT So I'm talking about [this](https://docs.microsoft.com/en-us/sql/t-sql/statements/collations). – Reaces May 17 '17 at 11:22

1 Answers1

1

AFAIK You can't change the collation when provisioning a IaaS from the SQL Server Image. It comes with SQL pre-loaded and there is no way to change this during the deployment process. The media and key are located on the server, so the steps would be the following

  1. Create SQL Server VM From IaaS Sql Server Template
  2. Uninstall SQL
  3. Re-install SQL with the collation you want
CtrlDot
  • 349
  • 1
  • 3
  • This is what I also came to think, and fear. I'll leave the question open for a while to see if anyone can prove us wrong. If not that is very unfortunate and removes a part of the flexibility of IAAS SQL Server on Azure for larger enterprises. +1 – Reaces May 18 '17 at 06:46
  • I got confirmation from M$ in an Azure ticket, that it is indeed impossible. They however recommend rebuilding the master database. Perhaps something you would like to add to your answer. – Reaces May 18 '17 at 11:37