Tag: MS SQL Server Error Codes

SQL Server Error Code – 41171 failed to create availability group ‘%.*

In this blog post, you’ll learn more about the SQL Server Error Code 41171 and the error message description that is shown SQL Server Error Code 41171 SQL Server Error Description for the Code :41171 Failed to create availability group ‘%.*ls’, because a Windows Server Failover Cluster (WSFC) group with the specified name already exists.  The operation has been rolled back successfully.  To retry creating…

SQL Server Error Code – 21640 non-sql server publishers do not support

In this blog post, you’ll learn more about the SQL Server Error Code 21640 and the error message description that is shown SQL Server Error Code 21640 SQL Server Error Description for the Code :21640 Non-SQL Server Publishers do not support a value of 1 for the parameter @thirdparty_flag. When executing the stored procedure sp_adddistpublisher, specify a value of 0 for the parameter.

SQL Server Error Code – 12824 the sp_configure value ‘contained databa

In this blog post, you’ll learn more about the SQL Server Error Code 12824 and the error message description that is shown SQL Server Error Code 12824 SQL Server Error Description for the Code :12824 The sp_configure value ‘contained database authentication’ must be set to 1 in order to %S_MSG a contained database.  You may need to use RECONFIGURE to set the value_in_use.

SQL Server Error Code – 485 views and inline functions cannot return

In this blog post, you’ll learn more about the SQL Server Error Code 485 and the error message description that is shown SQL Server Error Code 485 SQL Server Error Description for the Code :485 Views and inline functions cannot return xml columns that are typed with a schema collection registered in a database other than current. Column ?%.*ls? is typed with the schema collection…