web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Finance forum / SQL collation on-premise
Finance forum

SQL collation on-premise

(1) ShareShare
ReportReport
Posted on by Victor123 214

Hi All, 

I'm deploying D365FFO on-premise version now and I got a little problem.

According to https://docs.microsoft.com/en-us/dynamics365/unified-operations/fin-and-ops/get-started/system-requirements-on-prem best practise, I have selected Latin1_General_CI_AS default collation for my SQL Server.

In https://docs.microsoft.com/en-us/dynamics365/unified-operations/dev-itpro/deployment/setup-deploy-on-premises-pu12 there is step no. 14 "Configure the databases" which says to download a ready AXDB database from LCS and restore it in your SQL server.

These previous steps have resulted in SQL Server with collation Latin1_General_CI_AS and AXDB database with collation SQL_Latin1_General_CP1_CI_AS (because backup file had this collation).

I'm almost sure that it will cause collation conflicts in AX, because of tempdb having different collation.

What should be done in this situation? 

Categories:
  • MATTGUO Profile Picture
    MATTGUO 22,353 Moderator on at

    Hi Victor123,

    I have an immature idea, you can change SQL Server collation.

  • Victor123 Profile Picture
    Victor123 214 on at

    Hi MATTGUO,

    Thank you for your reply.

    As I remember, SQL Server collation indeed can be changed, but it doesn't solve the problem.

    D365FO SQL requirements state that I can select any collation which falls under CI_AS criteria and also that Windows collation should be selected for new implementations.

    So, changing SQL Server collation to SQL_Latin1_General_CP1_CI_AS would solve collation conflict problem, but it wouldn't leave us with best-practise option.

  • Victor123 Profile Picture
    Victor123 214 on at

    Any other suggestions?

  • EdgarM Profile Picture
    EdgarM 80 on at

    I'm also interested in this question

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

November Spotlight Star - Khushbu Rajvi

Congratulations to a top community star!

Forum Structure Changes Coming on 11/8!

In our never-ending quest to help the Dynamics 365 Community members get answers faster …

Dynamics 365 Community Platform update – Oct 28

Welcome to the next edition of the Community Platform Update. This is a status …

Leaderboard > Finance

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans