While running the "Certificate Seed Script.sql" file in Step 10 of the Generate Advanced Remote Management Certificates task, you might see an error. This error reads The conversion of a varchar data type to a datetime data type resulted in an out-of-range value.

Such an error is likely the result of a difference in locale between the machine upon which the SQL script was generated and the database server on which it is being run.

There are two possible solutions.

  • Run the cert provisioning tool on a machine with the same locale settings as the database server to ensure that the same date format is set in the SQL script.

OR (if the first solution is not possible)

  • Manually edit the date format in the SQL script to avoid errors while deploying the script during installation.

    For more information about date formats, see http://www.sql-server-helper.com/tips/date-formats.aspx.

    References in this documentation to any specific service provider, manufacturer, company, product, service, setting, or software do not constitute an endorsement or recommendation by VMware. VMware cannot be held liable for any damages, including without limitation any direct, indirect, incidental, special, or consequential damages, expenses, costs, profits, lost savings or earnings, lost or corrupted data, or other liability arising out of or related in any way to information, guidance, or suggestions provided in this documentation.