This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(115.19999999999999, 87%, 21%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EBA%3C/text%3E%3C/svg%3E)
The server collation is Latin1_General_CI_AS, the database collation is Latin1_General_100_CI_AS_SC_UTF8
right-click/properties (SSMS 18.9.2) on database in SQL Server (15.0.4063.15) returns:
TITLE: Microsoft SQL Server Management Studio
Cannot show requested dialog.
ADDITIONAL INFORMATION:
Cannot show requested dialog. (SqlMgmt)
An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo)
Cannot resolve the collation conflict between "Latin1_General_100_CI_AI_SC_UTF8" and "Latin1_General_CI_AS" in the equal to operation.
Cannot resolve the collation conflict between "Latin1_General_100_CI_AI_SC_UTF8" and "Latin1_General_CI_AS" in the equal to operation. (Microsoft SQL Server, Error: 468)
For help, click: https://learn.microsoft.com/sql/relational-databases/errors-events/mssqlserver-468-database-engine-error
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(28.799999999999997, 2%, 12%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESX%3C/text%3E%3C/svg%3E)
We have not received a response from you. Did the reply could help you? If the response helped, do "Accept Answer". If it doesn't work, please let us know the progress. By doing so, it will benefit all community members who are having this similar issue. Your contribution is highly appreciated.
Best regards,
Seeya
Thanks Seeya but no the problem is not resolved.
Please see my latest post further down the thread, simply put
Alter the collation of the DB on the Primary
Right-click/Properties on the secondary and it fails
Hi @Burch, Adrian ,
Yes. It may be a problem with the SSMS version. The latest version is 18.10.
Find Help from the navigation bar of SSMS, and then click About.., then you can see the SSMS version information.
Please see here: https://learn.microsoft.com/en-us/sql/ssms/download-sql-server-management-studio-ssms?view=sql-server-ver15
You can update SSMS if you need.
Best regards,
Seeya
aha .... further info, yes it is still happening. It is the secondary database in an Availability Group that has the problem
I can right-click/properties on the Primary DB fine, but trying it on the secondary DB produces the error
Both Servers have the same collation.
from the error message...
Cannot resolve the collation conflict between "Latin1_General_100_CI_AI_SC_UTF8" and "Latin1_General_CI_AS" in the equal to operation.
Cannot resolve the collation conflict between "Latin1_General_100_CI_AI_SC_UTF8" and "Latin1_General_CI_AS" in the equal to operation. (.Net SqlClient Data Provider)
For help, click: https://learn.microsoft.com/sql/relational-databases/errors-events/mssqlserver-468-database-engine-error
Server Name: BLAH-BLAH
Error Number: 468
Severity: 16
State: 9
Procedure: sys.sp_db_vardecimal_storage_format
Line Number: 37
Program Location:
at Microsoft.SqlServer.Management.Common.ConnectionManager.ExecuteTSql(ExecuteTSqlAction action, Object execObject, DataSet fillDataSet, Boolean catchException)
at Microsoft.SqlServer.Management.Common.ServerConnection.GetExecuteReader(SqlCommand command)
Server Name: BLAH-BLAH
Error Number: 468
Severity: 16
State: 9
Procedure: sys.sp_db_vardecimal_storage_format
Line Number: 37
If this is to believed, the issue is not in SSMS as such, but in this stored procedure. But when I look at the source code for this procedure, line 37 looks like this:
if @vardecimal_storage_format is not null and lower(@vardecimal_storage_format) not in ('on', 'off')
I would not expect that result in a collation conflict.
But if I understand this correctly, this happens if you alter the collation of the primary and view the properties of the secondary? Is that a readable secondary?
Unfortunately, I don't really have AG to test on myself.
Yes it is a readable secondary, thanks for looking
Hi @Burch, Adrian ,
Please see this prerequisite from this document : All the server instances that host availability replicas for an availability group must use the same SQL Server collation.
Also see: Set or Change the Server Collation.
Best regards,
Seeya
If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.
USE AdventureWorks2012;
GO
EXEC sp_configure 'show advanced options', 1;
GO
RECONFIGURE
GO
EXEC sp_configure 'default full-text language', 1043; --You need choose your language: Values Returned for Default Languages. (The link is at the end)
GO
RECONFIGURE
GO