You are your company’s SQL administrator. A SQL Server 2008 computer named SQL3 is running SQL ServerReporting Services (SSRS) in SharePoint integrated mode. Your company has decided to discontinue the use of SharePoint Services due to lack of use. You must configureSSRS to use native mode and still be able to access all SSRS content. You start the SQL Reporting Service Configuration tool and configure SSRS to use native mode. You need tocomplete the process. Which three actions must you perform? (Choose three. Each correct answer represents part of the complete solution.)
A.
Republish the content to SQL3.
B.
Assign roles on SQL3 that grant access to items and operations.
C.
Redefine subscriptions and scheduled operations.
D.
Re-create the report history for the SharePoint integrated mode data on SQL3.
E.
Point SQL3 to the SharePoint content location.
Explanation:
You should republish the content to SQL3 , assign roles on SQL3 that grant access to items and operations, andredefine subscriptions and scheduled operations. All of these actions are required to complete the switch back tonative mode while still being able to access all of the previous content. You cannot re-create the report history for the SharePoint integrated mode data on SQL3 . It is not possible tocarry over any information or re-create the information when switching from SharePoint integrated mode to nativemode. You should not point SQL3 to the SharePoint content location. A SQL Server 2008 SSRS computer cannot pointto the SharePoint content location. The content must be republished on the SSRS server. Native mode is used when you want the report content to be accessed and managed from within SSRS. Theversion history for SSRS in native mode can be viewed using the Report History feature. The version history forSSRS in SharePoint integrated mode can be viewed from within SharePoint. SharePoint integrated mode is used when you want the report content to be accessed and managed from withinSharePoint. The version history for SSRS in SharePoint integrated mode can be viewed from within theSharePoint application.
Objective:
Installing and Configuring SQL Server 2008Sub-Objective:
Configure additional SQL Server components.References:
TechNet > TechNet Library > Server Products and Technologies > SQL Server > SQL Server 2008 > ProductDocumentation > SQL Server 2008 Books Online > Reporting Services > Deployment > New Installation >Reporting Services Configuration How-to Topics > How to: Switch Server Modes (Reporting ServicesConfiguration)