500-445 · Question #13
Which two integration tasks are needed to get CUIC to communicate with ECE? (Choose two.)
The correct answer is B. Single-mode authentication must be enabled on the ECE Reporting server. E. Create a SQL User with db_user rights to the eGReportsDB on the ECE Reporting server. Integrating CUIC with ECE requires two specific configurations: enabling single-mode authentication on the ECE Reporting server (B) so that ECE accepts the SQL credentials CUIC will use, and creating a SQL user with db_user rights on the eGReportsDB database (E), which grants…
Question
Which two integration tasks are needed to get CUIC to communicate with ECE? (Choose two.)
Options
- ACreate a SQL User with db_datareader rights to the eGReportsDB on the ECE Reporting server.
- BSingle-mode authentication must be enabled on the ECE Reporting server.
- CCreate a SQL User with db_user rights to the eGsideDB on the ECE Reporting server.
- DMixed mode authentication must be enabled on the ECE Reporting server.
- ECreate a SQL User with db_user rights to the eGReportsDB on the ECE Reporting server.
- FMixed mode authentication must be enabled on the CUIC publisher.
How the community answered
(53 responses)- A4% (2)
- B83% (44)
- C9% (5)
- D2% (1)
- F2% (1)
Explanation
Integrating CUIC with ECE requires two specific configurations: enabling single-mode authentication on the ECE Reporting server (B) so that ECE accepts the SQL credentials CUIC will use, and creating a SQL user with db_user rights on the eGReportsDB database (E), which grants the correct permission level on the correct reporting database.
Why the distractors are wrong:
- (A)
db_datareaderrights are insufficient - CUIC requiresdb_userrights to function properly againsteGReportsDB. - (C)
eGsideDBis the wrong database;eGReportsDBis the ECE reporting database CUIC queries. - (D) Mixed-mode authentication is not the required setting - single-mode (SQL Server Authentication only) is what ECE's Reporting server needs for this integration.
- (F) Authentication mode is configured on the ECE Reporting server, not the CUIC publisher.
Memory tip: Think "Single + eGReports" - ECE needs Single-mode auth and a SQL user on eGReportsDB. If you see "Mixed" or the wrong database (eGside), it's a trap. Also, nothing is configured on the CUIC side for SQL auth - all changes live on the ECE Reporting server.
Topics
Community Discussion
No community discussion yet for this question.