Home / server / Questions / 850410
Accepted
Reaces
Asked: 2017-05-17 05:05:01 +0800 CST

How to choose collation for SQL Azure IAAS

  • 772

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?

sql-server

1 Answers

  1. Best Answer

    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
    • 1