Administering Core Business Intelligence Services - Microsoft SQL Server 2008 R2 Administration

Database Reference

In-Depth Information

How it works...

Both Reporting Services and SharePoint products use SQL Server relational databases for

internal storage. SharePoint installs the Embedded Edition for its database; however, it is

best practice to use a different instance. Reporting Services cannot use this edition for its

database; it requires that the Evaluation, Developer, Standard, DataCenter or Enterprise

edition of SQL Server Database Engine be installed. The earlier versions of SQL Server do not

support hosting the SQL Server 2008 R2 Reporting Services Add-in for SharePoint Products,

so it is essential to use SQL Server 2008 Reporting Services R2 database only.

On the other hand, SSRS is lenient with prefixed parameters and uses a default value when

the value specified in URL access is invalid. For example, rs:Command= Reindeer defaults

to rs:Command=Render . If you want to install Reporting Services and a SharePoint product

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.

If you are using a SharePoint farm or a scale-out reporting deployment topology and don't

want to repeat these configuration steps manually on each server, you can use SSRS

programmability to create configuration scripts. To increase security, an administrator can

use SecureConnectionLevel to configure SSRS and enforce web service client applications to

leverage various levels of SSL communications for Report Server web service method calls. (This

configuration also affects ReportManager). SSRS uses SecureConnectionLevel (located in

RSReportServer.config) to determine which web service methods require an SSL connection.

There's more...

SQL Server Edition requirements for Reporting Services in SharePoint integrated mode

include Developer, Evaluation, Standard, DataCenter, or Enterprise editions. 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.

If you are adding a report server to a SharePoint Server 2010 server farm, you must have at

least a minimal installation of SharePoint Server 2010 on the report server computer. You

cannot have a combination of SharePoint Foundation 2010 and SharePoint Server 2010 in

the same server farm.