jump to navigation

Reporting Services – Sharepoint Integrated Mode vs Native August 29, 2012

Posted by juanpablo1manrique in Developer, SharePoint, SQL SERVER 2008, SSRS, VS.
Tags: ,
add a comment

En esta ocasión se intento hacer una diferenciación entre los dos modos de instalación de Reporting Services cuando se integra con SharePoint 2010, fue algo complejo espero que les guste

SharePoint Integrated Mode SharePoint Integrated Mode Whit SQL 2008 R2 Native 2008
SharePoint collaboration Features, alerts and version control x x
Tener un sitio unificado para accesar y manejar tanto .rdl como otros documentos x x
SharePoint Permissions and authentication providers x x
Use SharePoint large deployment to internet or intranet x x
Manage custom application page and custom masterpage to improved desing x x
Posibility to develop custom features for custom requirements, for exmaple manage report history x x
Report Center x x
Publish reports and datasources directly to sharePoint library or use direct upload action x x
SharePoint collaboration Features, deliver reports thorugh e-mail, shared folder, data-driven subscriptions using data queried at run time Según SharePoint Según SharePoint Según SSRS
Report viewer web Part whit page navigation, search, print and export features. x x
Program against a new SOAP endpoint to create custom applications that integrate with a SharePoint site
 x x
URL addressing is different in SharePoint integrated mode
 x x
Atom Renderer specific icon in the ReportViewer web part toolbar. x x
Improved Report Preview experience with Report Builder 3.0 and edit sessions. x x
2010 End Point Proxy. x x
Support for SharePoint ULS Logging. x x
Local Mode for viewing reports with SharePoint List data extension. x x
Access Reporting in local mode when Access Services is enabled. x x
37 languages supported including bi-directional languages (Hebrew and Arabic) and complex script languages Reporting Services web pages. x x
Reporting Services custom security extensions x
Report Manager x
Linked reports x
My Reports x
My Subscriptions x
Batching methods x
Support for Multiple SharePoint Zones. x
Rs.exe utility supports scripting with servers in SharePoint Integrated mode. x
Support using Trusted Account authentication for SharePoint web applications using login. x
Report Parts. x
2010 management endpoint. x
Microsoft Access reporting in connected mode when Access Services is enabled. x
Relational, multidimensional, XML, and custom data sources x x x
Tabular, matrix, chart, and free-form report layouts x x x
Ad hoc reports x x x
Drillthrough reports and interactivity x x x
Presentation formats x x x
Custom controls and report items x x x
bookmarks and document maps x x x
aggregate and summarize x x x
Graphical elements x x x
Command-line utilities for administration x x x
Role-based security Report Manager Según SharePoint Según SharePoint Según SSRS
On-demand access over Web connections x x x
Subscriptions for E-mail or File share Delivery Según SharePoint Según SharePoint Según SSRS
Data-driven subscriptions de Reporting Services Según SharePoint Según SharePoint Según SSRS
Report Definition Language (RDL) x x x
URL access parameterized URL strings x
WMI provider Report Server Windows service x x x

Se esperaria que todas las funcionalidades de una librería esten disponibles en una librería de reportes, pero estas 2 no lo estan.

  • SharePoint OutLook Calendar
  • Report server integration Anonymous Access

Tomado de

http://msdn.microsoft.com/en-us/library/ms159273(v=sql.105).aspx

http://msdn.microsoft.com/en-us/library/bb326290(v=sql.105).aspx

Saludos

SharePoint Exception Details: System.Security.SecurityException: January 19, 2011

Posted by juanpablo1manrique in BI, Business Inteligent, Seguridad, SharePoint, Uncategorized.
Tags: ,
add a comment

Al intentar llamar otra aplicación WEB desde SharePoint recibi el siguiente error

Security Exception
Description: The application attempted to perform an operation not allowed by the security policy.  To grant this application the required permission please contact your system administrator or change the application’s trust level in the configuration file.

Exception Details: System.Security.SecurityException: Request for the permission of type ‘Microsoft.SharePoint.Security.SharePointPermission, Microsoft.SharePoint.Security, Version=12.0.0.0, Culture=neutral, PublicKeyToken=71e9bce111e9429c’ failed.

Para solucionar este inconveniente en el web.config del sharepoint se encuentran las siguientes definiciones

      <trustLevel name=”WSS_Medium” policyFile=”C:\Archivos de programa\Archivos comunes\Microsoft Shared\Web Server Extensions\12\config\wss_mediumtrust.config” />
      <trustLevel name=”WSS_Minimal” policyFile=”C:\Archivos de programa\Archivos comunes\Microsoft Shared\Web Server Extensions\12\config\wss_minimaltrust.config” />

Las cuales establecen las posibles politicas de seguridad que puede tener el SharePoint, estas politicas son editables y permiten dar mayor o menor funcionalidad al SharePoint con respecto a otras aplicaciones o dlls.

Si comparamos la definición de la politica de WSS_Medium y WSS_Minimal para este dll se observa que en WSS_Medium se pueden ejecutar más acciones.

  • WSS_Medium <IPermission       version=”1″ Flags=”Assertion, Execution, ControlThread, ControlPrincipal,     RemotingConfiguration”   />
  • WSS_Minimal <IPermission       version=”1″ Flags=”Assertion, Execution, ControlThread, ControlPrincipal,     RemotingConfiguration”   />

Entonces se debe reemplazar unas cuantas lineas más abajo con

  • <trust level=”WSS_Medium” originUrl=”” />

Y solucionada la integración

Se recibe un error al ingresar al server report de SSIS January 19, 2011

Posted by juanpablo1manrique in BI, Business Inteligent, Reporting Services, SQL SERVER 2008, SSRS.
Tags:
add a comment

He estado instalando Reporting services de SQL en su versión 2008,

El cual tiene 2 modos de operación Native Mode e SharePoint Integrated Mode, y en el proceso de la instalación en SharePoint Integrated Mode me aparecio el siguiente error, al intentar entrar a la URL de server de SSRS

The report server has encountered a configuration error. if the report server is configured to use sharepoint integrated mode, verify that the server belongs to a sharepoint farm and that the service account has access the report server to this farm.

La solución de este inconveniente fue entrar a la consola de servicios de windows services.msc y cambiar la cuenta de usuario con la que corre el servicio, y entregar una cuenta windows que tuviera permisos sobre las bases de datos de SharePoint