SQL Server Error Msg 33569 – Column ‘%.*ls.%.*ls’ is encrypted using a randomized encryption type using a non *_BIN2 collation and is therefore not valid for use as a key column in an index.

In this blog post, let’s learn about the error message “33569 – Column ‘%.*ls.%.*ls’ is encrypted using a randomized encryption type using a non *_BIN2 collation and is therefore not valid for use as a key column in an index.” in Microsoft SQL Server, the reason why it appears and the solution to fix it.

SQL Server Error Message

33569 – Column ‘%.*ls.%.*ls’ is encrypted using a randomized encryption type using a non *_BIN2 collation and is therefore not valid for use as a key column in an index.

Reason for the Error

To be update soon…

Solution

To be update soon…