Different Collation on SQL Server and NAV 2015 DB

DrittesKnie

Hello.

We have a SQL 2014 Standard Server installed with a NAV 2015 database installed on that.
The SQL 2014 Standard Server has the following SQL collation: SQL_Latin1_General_CP1_CI_AS
The NAV 2015 database has the collation: Latin1_General_100_CS_AS

To set the SQL 2014 Server to the same collation as the NAV database, simple way is the recreate the SQL Default databases and thereby set the new collation as same as NAV database.

Question: uses NAV only the own NAV database? Or uses NAV also Default databases from SQL (e.g. temp) to operate?

Thank you for your assistance / your best practise for that.

Best regards,
Lars

Slawek_Guzek

NAV does not use tempdb directly (ie it does not issue any statements against tempdb), but it does use master db (license is usually stored in master db)

BTW There is not such a thing as default db in SQL Server - I guess you refer to model db. If so changing default SQL Server collation takes a bit more than just recreating the model db. https://msdn.microsoft.com/en-us/library/ms179254.aspx

Regards,
Slawek

joshuasung

You talking about that one?
That's default NAV uses