You design a Business Intelligence (BI) solution by using SQL Server 2008. You plan to deploy a new SQL Server 2008 Reporting Services (SSRS) solution for an accounting department. The department currently uses Microsoft Excel 2007based reports hosted on Windows SharePoint Services (WSS) 3.0.
You need to replace the existing Excel 2007 reports with SSRS-based reports.
Your solution must meet the following requirements:
-Users must be able to access the reports by using WSS.
-Reports must be version-controlled.
-Developers must be able to deploy the reports to a WSS document library.
Which two tasks should you perform? (Each correct answer presents part of the solution. Choose two.)
A.
Configure the SSRS instance by using native mode.
B.
Configure the SSRS instance by using SharePoint integration mode.
C.
Install the Reporting Services Add-in for SharePoint Technologies in the WSS server.
D.
Install SharePoint Web Part in the WSS server. Configure the Web Part to point to the reports in Report Manager.
Explanation:
Tip: "version-controlled" = "SharePoint integration" / "Add-in for SharePoint"http://msdn.microsoft.com/en-us/library/bb283190(SQL.100).aspx
Requirements for Running Reporting Services in SharePoint Integrated Mode
You can integrate Microsoft SQL Server Reporting Services with Windows SharePoint Services or Office SharePoint Server by configuring a report server to run in SharePoint integrated mode and by installing a Reporting Services Add-in that adds infrastructure and application pages to a SharePoint Web application.
Report Server Requirements
A report server that runs in SharePoint integrated mode has edition and software requirements:
– The report server computer must satisfy the hardware and software requirements for SQL Server installations.
– Edition requirements for Reporting Services in SharePoint integrated mode include Developer, Evaluation, Standard, or Enterprise editions. There is no support for this feature in the Workgroup edition or in SQL Server Express with Advanced Services.
– The report server database must be created for SharePoint integrated mode.
– To join a report server to a SharePoint farm, the report server must be installed on a computer that has an instance of a SharePoint product or technology. You can install the report server before or after installing the SharePoint product or technology instance.
– The version of the SharePoint product or technology that you install on the report server computer must be the same version that is used throughout the farm. I
SharePoint Product and Technology Requirements
The SharePoint server farm that you integrate with Reporting Services has the following edition and software requirements:
– Edition requirements for the SharePoint product or technology are Windows SharePoint Services 3.0 or Microsoft Office SharePoint Server 2007. If you use Microsoft Office SharePoint Server , you must run either the Standard Edition or the Enterprise Edition of Microsoft Office SharePoint Server 2007.
– Reporting Services Add-in for SharePoint Technologies must be installed on the Web front-end. The Reporting Services Add-in provides server integration features and Web application pages for accessing report server items from a SharePoint site. The add-in must be installed on each Web front-end in the server farm through which users will access reports and other items.
– You must have at least 2 gigabytes of RAM on the Web front-end computer.
– Anonymous access cannot be enabled on the SharePoint Web application. If Anonymous access is enabled, you will be able to configure integration settings but users will get an error when they run a report. All other authentication providers and options are supported. If you are configuring integration between a report server and a SharePoint farm, each SharePoint Web application in the farm can be configured to use different authentication providers.
Database Server Requirements
Both Reporting Services and SharePoint products and technologies use SQL Server relational databases for internal storage. Windows SharePoint Services installs the Embedded Edition for its database. Reporting Services cannot use this edition for its database; it requires that you install the Evaluation, Developer, Standard, or Enterprise edition of SQL Server Database Engine. The SQL Server 2008 Reporting Services Add-in for SharePoint Technologies requires a SQL Server 2008 Reporting Services (SSRS) report server instance because this add-in is not supported with earlier versions of SQL Server. However, the report server may connect to a report server database that is hosted in either SQL Server 2005 or SQL Server 2008.
If you want to install Reporting Services and a SharePoint technology instance on the same computer, you can run SQL Server Express and another edition of SQL Server side-by-side on the same computer or you can use the same instance of the Database Engine for the SharePoint configuration and content databases if you choose the Advanced installation option when installing a SharePoint product or technology. If you choose the Basic installation option instead, the SharePoint Setup program will install SQL Server Embedded Edition as an internal component and use that instance to host the SharePoint databases.