Microsoft SQL Server 2008 R2 Specifications download pdf (Page 207)

SharePoint Integration CHAPTER 9 187

SharePoint Integration

SQL Server 2008 R2 Reporting Services continues to improve integration with SharePoint. In

this release, you nd better options for conguring SharePoint 2010 for use with Reporting

Services, working with scripts to automate administrative tasks, using SharePoint lists as data

sources, and integrating Reporting Services log events with the SharePoint Unied Logging

Service.

Improved Installation and Conguration

The rst improvement affects the initial installation of Reporting Services in SharePoint inte-

grated mode. Earlier versions of Reporting Services and SharePoint require you to obtain the

Microsoft SQL Server Reporting Services Add-in for SharePoint as a separate download for

installation. Although the add-in remains available as a separate download, the prerequisite

installation options for SharePoint 2010 include the ability to download the add-in and install

it automatically with the other prerequisites.

After you have all components installed and congured on both the report server and the

SharePoint server, you need to use SharePoint 2010 Central Administration to congure the

General Application settings for Reporting Services. As part of this process, you can choose

to apply settings to all site collections or to specic sites, which is a much more streamlined

approach to enabling Reporting Services integration than was possible in earlier versions.

Another important improvement is the addition of support for alternate access mappings

with Reporting Services. Alternate access mappings allow users from multiple zones, such as

the Internet and an intranet, to access the same report items by using different URLs. You can

congure up to ve different URLs to access a single Web application that provides access

to Reporting Services content, with each URL using a different authentication provider. This

functionality is important when you want to use Windows authentication for intranet users

and Forms authentication for Internet users.

RS Utility Scripting

Report server administrators frequently use the rs.exe utility to perform repetitive administra-

tive tasks, such as bulk deployment of reports to the server and bulk conguration of report

properties. Lack of support for this utility in integrated mode had been a signicant problem

for many administrators, so having this capability added to integrated mode is great news.

SharePoint Lists as Data Sources

Increasing numbers of companies use SharePoint lists to store information that needs to be

shared with a broader audience or in a standard report format. Although there are some

creative ways you could employ to get that data into Reporting Services, custom code was

always part of the solution. SQL Server 2008 R2 Reporting Services has a new data exten-

sion provider that allows you to access SharePoint 2007 or SharePoint 2010 lists. After you

1 2 ... 202 203 204 205 206 207 208 209 210 211 212 ... 235 236

No comments

Modely	Typ Dokumentu
MR-MS3203	Datový list Maroo Woodland Brown Surface 3, 1 stránky
MR-MS3202	Datový list Maroo Woodland Blue Surface 3, 1 stránky
MR-MS3301	Datový list Maroo MR-MS3301, 1 stránky
MR-MS3307	Datový list Maroo MR-MS3307, 1 stránky
MR-UC8001	Datový list Maroo MR-UC8001, 1 stránky
MR-MS3304	Datový list Maroo MR-MS3304, 1 stránky
MR-IC5005	Datový list Maroo MR-IC5005, 1 stránky
MR-IC5002	Datový list Maroo MR-IC5002, 1 stránky
M-102	Datový list Maroo MOKO II, 1 stránky
MR-UC8002	Datový list Maroo MR-UC8002, 1 stránky
MR-MS3003	Datový list Maroo MR-MS3003, 1 stránky
MM-401	Datový list Maroo MM-401, 1 stránky
MR-IC5003	Datový list Maroo MR-IC5003, 1 stránky
MR-MS3007	Datový list Maroo MR-MS3007, 1 stránky
MR-IC5004	Datový list Maroo MR-IC5004, 1 stránky
MR-MS3005	Datový list Maroo MR-MS3005, 1 stránky
MR-MS3002	Datový list Maroo MR-MS3002, 1 stránky
MM-400	Datový list Maroo PANGO mini, 1 stránky
MII-120	Datový list Maroo MII-120, 1 stránky
MII-121	Datový list Maroo RIMU[ii] mini, 1 stránky

Microsoft SQL Server 2008 R2 Specifications Page 207