If you faced this error when you want to connect Data Quality Services (from Data Quality Client or from SSIS DQS Cleansing component);
Cannot connect to server – A .NET Framework error occurred during execution of user-defined routine or aggregate “SetDataQualitySessions” – SetDataQualitySessionPhaseTwo
You can fix it in following way;
Why this happens:
When .NET Framework updates installs on Data Quality Server machine
For me it happened when I installed SSDT – BI projects for Visual Studio 2012 which released yesterday!
You need to upgrade data quality services dlls with these steps:
1- Open Command Prompt
2- go to DQS installed folder with this:
cd C:\Program Files\Microsoft SQL Server\MSSQL11.MSSQLSERVER\MSSQL\Binn
3- Run this command:
after finishing upgradedlls you will be able to connect to DQS successfully.
here you can read MSDN article about it: