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…

AdHocRemoteQueriesEnabled controls access to OPENROWSET and OPENDATASOURCE for ad hoc distributed queries and has no relationship to DQS client connectivity.

SoapEndpointsEnabled relates to HTTP SOAP endpoints which were deprecated in SQL Server and are not used by Data Quality Services.

SQL Server Data Quality Services depends on CLR Integration because its server-side components use managed code assemblies registered in SQL Server. When the DQS databases are restored to a new server, CLR Integration (ClrIntegrationEnabled) is disabled by default and must be explicitly enabled using sp_configure or SQL Server Surface Area Configuration. Without this, the DQS stored procedures fail to execute, preventing client connections.

RemoteDacEnabled allows remote Dedicated Administrator Connection access for emergency server administration and is unrelated to DQS user connectivity.

OleAutomationEnabled enables OLE Automation stored procedures such as sp_OACreate and is not required by DQS.

XpCmdShellEnabled enables the xp_cmdshell extended stored procedure for OS command execution and is not a DQS dependency.