Assorted SharePoint Thoughts....

Saturday, September 11, 2010

MOSS 2010 Application Service

(1) Access Services View/Edit/Interact with Access 2010 DB’s in the browser Cache
(2)Business Data Connectivity Access LOB data DB
(3)Excel Services View/Edit/Interact with Ecel 2010 files Cache
(4)Managed Metadata Service Access managed taonomy hierarchies, keywords, and social tagging infrastructure as well as Content Type publishing across site collections DB
(5)PerformancePoint Provides the capabilities of PerformancePoint Services Cache
(6)PowerPoint View/Edit/Broadcast PowerPoint presentations in a web browser Cache
(7)Search Crawls content, produces inde partitions, serves search queries DB
(8)Secure Store Services Provides single sign-on authentication to access multiple applications or services DB
(9)State Service Provides Temporary Storage of user session data for SharePoint Server components DB
(10)Usage and Health Data Collection Collects farm wide usage and health data and provides the ability to view various reports DB
(11)User Profile Adds support for My Sites, Profile pages, Social Tagging, and other social computing features DB
(12)Visio Graphics Service Viewing and refreshing of Visio diagrams in the browser BLOB cache
(13)Web Analytics Provides Web Service interfaces

Performance Point Service in MOSS 2010

http://blogs.msdn.com/b/performancepoint/archive/2009/11/24/deploying-performancepoint-2010-soup-to-nuts.aspx

Thursday, September 9, 2010

Request for permission of type 'Microsoft.Office.Access.Server.Security.AccessServicesPermission,

Below are steps to solve above problem

(1) Modify the C:\Program Files\Microsoft SQL Server\MSRS10_50.MSSQLSERVER\Reporting Services\ReportServer\rsreportserver.config file on the Reporting Services server. Under the node, under the node, add the ADS data extension. For example:
<Extension Name="ADS" Type="Microsoft.Office.Access.Reports.DataProcessing.AdsConnection, Microsoft.Office.Access.Server.DataServer, Version=14.0.0.0, Culture=Neutral, PublicKeyToken=71e9bce111e9429c"/> -->

(2)Modify the rssrvpolicy file on RS server.

Add the following XML code in the file under the node.

<PermissionSet class="NamedPermissionSet" version="1" Name="ReportExpressionsDefaultPermissionSet">
<IPermission class="SecurityPermission" version="1" Flags="Execution" />
<IPermission class="Microsoft.Office.Access.Server.Security.AccessServicesPermission, Microsoft.Office.Access.Server.Security,
Version=14.0.0.0, Culture=neutral, PublicKeyToken=71e9bce111e9429c" version="1.0" Flags="CalculationCallback" />
</PermissionSet>

(3) In the node, find the following line and change PermissionSetName from “Execution” to “ReportExpressionsDefaultPermissionSet”

<CodeGroup class="UnionCodeGroup" version="1" PermissionSetName="Execution" Name="Report_Expressions_Default_Permissions"
Description="This code group grants default permissions for code in report expressions and Code element. ">

You tried to use an extension for the data 'ADS' not registered for this report server or not supported in this edition of Reporting Services

(1) Go

C:\Program Files\Microsoft SQL Server\MSRS10_50.MSSQLSERVER\Reporting Services\ReportServer\rsreportserver.config

(2)Remove the comment markers () off of the Data Extension for ADS.

(3) Once the comments were removed from the ADS extension, the SQL reports began working immediately.