You are maintaining a Data Quality Services (DQS) environment. The production server
failed and a new server has been set up. The DQS databases are restored to a new server.
All the appropriate permissions are granted.
DQS users are experiencing issues connecting to the new Data Quality Server.
You need to enable users to connect to the new server.
Which Surface Area Configuration property should you enable?
A.
AdHocRemoteQueriesEnabled
B.
SoapEndpointsEnabled
C.
ClrIntegrationEnabled
D.
RemoteDacEnabled
E.
OleAutomationEnabled
F.
XpCmdShellEnabled
I don’t see why this is the correct answer.
The answer is correct based on this link: https://docs.microsoft.com/en-us/sql/data-quality-services/detaching-and-attaching-dqs-databases
After restoring the DQS_MAIN database the following T-SQL must run otherwise an error message is displayed when you try to connect to Data Quality Server by using the Data Quality Client application, and you cannot connect. :
ALTER DATABASE [DQS_MAIN] SET TRUSTWORTHY ON;
EXEC sp_configure ‘clr enabled’, 1;
RECONFIGURE WITH OVERRIDE
ALTER DATABASE [DQS_MAIN] SET ENABLE_BROKER
ALTER AUTHORIZATION ON DATABASE::[DQS_MAIN] TO [##MS_dqs_db_owner_login##]
ALTER AUTHORIZATION ON DATABASE::[DQS_PROJECTS] TO [##MS_dqs_db_owner_login##]
I dont remember exactly but in order to
connect to DQ server you have to set
[DQS_MAIN] SET TRUSTWORTHY ON
and enable clr
yup clr must be enable
https://docs.microsoft.com/en-us/sql/data-quality-services/detaching-and-attaching-dqs-databases