We cannot log into CAMS. Receive DLL xp_ctnhashproc.dll error
Problem: A Microsoft update may have occurred and now we cannot log into CAMS Enterprise. We get a DLL xp_ctnhashproc.dll error.
Possible Solution: On each node in the SQL Cluster, copy the xp_CTNHashProc.dll (typically located in the SQL subdirectory under the root of CAMSEnterprise) to the C:\program files\Microsoft SQL Server\Binn folder. This file should have NTFS permissions Everyone (Read,Execute). Once the file is in place, run the EnableCTNHash.sql (located in the same directory as the dll above).