当前位置: 传客网 > Install and configure Reporting Services for SharePoint 2010 

Install and configure Reporting Services for SharePoint 2010 

2017-01-02 作者:铁血柔情

Install and configure Reporting Services for SharePoint 2010 Integration

Rita Zhang

 

There are many ways to setup SSRS for SharePoint integration. In this post, we will describe steps to configure SSRS for SharePoint on multiple servers. In particular, when Reporting server is installed on the SharePoint server.

First computer is the SharePoint server. We will need to install Reporting services and Reporting services add-in on the SharePoint server:

  • Run the SQL setup from the installation media to install the Reporting sercices feature without configuration
  • Once the installer launches, click New Installation or add features to an existing installation
  • Wait for the setup support files to be installed
  • At the Feature Selection prompt, click on the checkbox next to Reporting Services. Click Next


  • At the Instance Confiuration prompt, fill in a name for the Report Server instance and specify a file path. Click Next

 and configure Reporting Services for SharePoint 2010 Integration" title="Install and configure Reporting Services for SharePoint 2010 Integration" />

  • When prompted for Service account, enter a service account to be used to run Reporting Services on the SharePoint server

  • At the Reporting Services Configuration prompt, select "Install, but do not configure the report server."

Configure Reporting services on SharePoint server

  • Launch Reporting Service Configuration Manager (Start > All programs > Microsoft SQL Server 2008 R2 > Configuration Tools > Reporting Services Configuration Manager)



  • When the tool first launches, it will prompt you for the Reporting server name and the Report server instance. Ensure you enter the SharePoint server name for server name and Report server instance you have created in previous steps when you installed the reporting services feature on the sharepoint server. Click Connect.

  • If the service is not already started, click on the Start button. Click Apply.
  • At the Service account prompt, enter the service account the reporting service should run under. Click Apply.
  • At the Web Service URL prompt, accept the default values OR enter 8080 for TCP Port. Ensure the URL is using the SHarePoint server. Click Apply.

  • At the Database prompt, click Change Database to configure settings for SQL database

  • At the Change Database prompt, select the radio button to Create a new report server database
  • At the Connect to Database Server prompt
    • ensure you enter the SQL instance you are running on the SQL server (not the default value given on the SharePoint server)
    • Authentication type should be Current User - Integrated Security, ensure the current user has sys_admin access on the SQL server to create new databases
    • Click Test Connection to ensure the information is correctly entered. Click Next

  • At the Database Prompt, enter a name for the new ReportServer Database and select "SharePoint Integrated" as the Server mode for Report services. Click Next.

    • Wait for the process to finish.
  • At the Report Manager URL prompt, accept the default and click Apply

  • At this point, we have configured most things for Reporting server. Go back to the Web Service URL, and click on the URL we have set earlier, it should launch your browser and you should be able to see information about the reporting server.

Configure SSRS add-in in SharePoint Central Admin

  • Launch SharePoint Central Admin > General Application Settings > click Reporting Services Integration
    • Ensure Report Server Web Service URL is the same URL was the one we set in the previous steps.
    • For Authentication Mode, set it to Windows Authentication
    • For Credential, specify the service account used to run Reporting Services
    • For Activate the Reporting Services feature, ensure Activate feature in all existing site collections" is selected.
    • Click OK

 

  • Once all the configurations are set, you will see confirmation indicating service account has access to the Reporting service database, service account has been added to the WSS_WPG windows group, and activation of the feature has been successful.

Create Reports and publish to Reports library

  • From a computer with SQL Server Business Intelligence Development Studio, launch the program from Start > Program
  • Once the application is launched, File > New > Project
  • From Solution Explorer, right-click Reports > Add New Report
  • From Report Wizard, select an existing datasource from the Shared data source dropdown or create a new data source
    • To create a new data source, click New data source radio button
    • Click Edit button
    • From Connection Properties, select Server Name dropdown to find the sql instance you want to connect to
    • Click OK
  • Click Next
  • Click within the Query String field to enter the SQL query for this report, example: select id from Customer. Click Next
  • Select Tabular or Matrix, Next
  • Continue to click Next and configure the report. Lastly, enter a name for the report. Click Finish
  • From a SharePoint site, you need to create two libraries
    • Site Actions > More options > At the Create prompt, click Library > Select Report Library, name it Reports (for example)
    • Site Actions > More options > At the Create prompt, click Library > Select Data Connection Library, name it DataConnection (for example)

    • Copy these URLs
  • From SQL Server Business Intelligence Development Studio project, configure settings for the project to deployment
    • From Solution Explorer, right-click the Report project > Properties
    • Ensure you use the URLs of the Reports and Dataconnection library we just copied from previous step
    • If we are changing the credential to a service account instead of a user, we need to change OverwriteDatasources to "False" to ensure the changes we set in SharePoint does not get ovewritten.

  • Click Apply, click OK
  • Right-click on the project, click Build then Deploy

To ensure Reports run using a service account, instead of the user:

  • From SharePoint, navigate to the Data connection library. Click the data source used by the report.

  • Because this is a change in SharePoint, we need to ensure properties of the project indicates that OverwriteDatasources is set to "False" to ensure the changes we set in the previous step does not get ovewritten


相关推荐

  • 使用 Excel Services ,结合 AS在 SharePoint 中发布报表

    微软以往的BI产品,尽管有ReportBuilder这类ad-hoc工具,但是作为客户端开发工具仍然太麻烦,而且也无法提供灵活的分析功能。在微软新的SQLServer加Office战略布局中,Excel被提升到了非常重要的地位,除了OLAP

  • WSSv3 Technical Articles_Windows SharePoint Services 3.0编码开发工具和技巧(Part 

    摘要:学习开发WindowsSharePointServices3.0的技能,与传统ASP.NET开发的区别,需要的开发环境,用VisualStudio2005ExtensionsforWindowsSharePointServices3.

  • WSS3.0 和 MOSS 的版本号小结 (Sharepoint 2007 对应的补丁版本)

    如果你对SharePoint的版本对应那个servicepack和补丁有疑惑,这个表格也许对你有帮助.在SharePoint的管理中心网站的ServersinFarm页面,可以看到的版本号如下:描述WSSKBMOSSKB版本号August1

  • Microsoft Office SharePoint Server 2007管理与应用系列课程

    中文名称:MicrosoftOfficeSharePointServer2007管理与应用系列课程资源类型:ISO发行时间:2007年地区:大陆语言:普通话简介ʍ

  • 3Ds Max[2010-2017]Project Manage项目管理插件v2.60.27

    ProjectManager在3dsmax中工作起到组织的作用,它帮助你在你的编目和位图项目使用,模型和材料库,也和HDRI文件,该组织系统允许在不同的目录中保持参考目录,而不必重复您的硬盘驱动器上的文件夹,为了更方便的工作与图书馆的所有信

  • 在线激活密钥:Windows 8.1/8/7|Office 2013/2010一键激活

    MAK密钥为“MultipleActivationKey”的简称,即“多次激活密钥”,顾名思义:可以使用多次。具体可以使用多少次,可以通过一个小工具“TheUltimatePIDChecker”(下载及使用方法)来检测。MAK密钥的特点是,

  • 纺织工程设计防火规范 GB 50565-2010

    纺织工程设计防火规范Codefordesignoftextileengineeringonfireprotectionandprevention资料来源http://www.zzguifan.com/webarbs/book/12428/6

  • Project 2007/2010企业项目实战课程

    ●主办单位:北京高远华信科技有限公司●时间地点:2012年5月25日---27日北京●培训费用ProjectProfessional2007/2010(2天);ProjectServer2007/2010

  • 【JavaSE学习】String str = "2010-5-24  10:53:30"=======>2010524105

    packagecom.gem.lesson1;//4、String了解方法//Stringstr="2010-5-2410:53:30"=======>2010524105330publicclassStringdel{publics

  • Treme S01E04 May 06,2010 PLX Part3

    May06,2010宋体字Lizzie译粗体是别人校对后改正的斜体是Lizzie译的不错的注:IAIN'TKNOWNOTHING其实就是IDON'TKNOWANYTHING~美国黑人的说法25100:47:37,134-->00:47

  • VC2010运行库中文安装版(microsoft Visual C++2010)下载,高速下载

    VC2010运行库中文安装版(microsoftVisualC++2010)软件标签:VC2010运行库visualc++软件授权:安装版更新时间:2011-01-1010:28:53软件类型:国产软件软件大小:4.83MB软件语言:简体中

  • 【极致屋】数码相机 约2010万有效像素 5倍光学变焦

    【极致屋】数码相机约2010万有效像素5倍光学变焦,又是一年春来到,惊蛰一过,各种草长莺飞,内心长草的事儿就开始浮现心头了,许多一直惦记的事儿,这时候也该慢慢提到日程上了。如今大家手里的手机拍照功能越来越强大,修图App的开发也越来越全面,

  • 数码相机 约2010万有效像素 5倍光学变焦

    数码相机约2010万有效像素5倍光学变焦,数码相机是集光学、机械、电子一体化的产品。它集成了影像信息的转换、存储和传输等部件,具有数字化存取模式,与电脑交互处理和实时拍摄等特点。极致屋,手机数码特卖网站.正品正货_限时抢购_优惠促销www.

  • 数码相机 约2010万有效像素 5倍光学变焦

    数码相机约2010万有效像素5倍光学变焦,集成了影像信息的转换、存储和传输等部件,具有数字化存取模式,与电脑交互处理和实时拍摄等特点。光线通过镜头或者镜头组进入相机,通过数码相机成像元件转化为数字信号,数字信号通过影像运算芯片储存在存储设备

  • 笔迹鉴定规范(SF/Z JD0201002-2010)【第 5 部分 签名鉴定规程】

    第5部分签名鉴定规程1范围本规范规定了笔迹鉴定中签名鉴定的程序和方法。本规范适用于笔迹鉴定中签名的同一认定。2规范性引用文件下列文件中的条款通过本部分的引用而成为本部分的条款。凡是注明日期的引用文件,其随后所有的修改单(不包括勘误的内容)或

  • Word Excel PPt 2007/2010/2013打开的时候提示配置的解决方法

    现象描述有时候我们安装好office2010后,每次打开word文档时候会提示“安装程序正在准备必要的文件”然后是“正在配置MicrosoftOffice...""。原因主要是安装时候所用账户和你目前登陆的账户不为同一个账户,或者你进行过覆

  • 雅思阅读notes-剑10T1P2-European transport systems 1990-2010

    prospect前景facilitate促进volume量imperative紧急的,势在必行的/必要的事integrate使完整,使融合alternative供选择的,替代性的/可选择的方法complementary补足的,补充的guar

  • Late Autumn(2010 film)

    LateAutumnisanEnglish-languagemovieproducedin2010anddirectedbyKimTae-yong.ItstarsTangWeiasAnna,aprisonerwhoisgivena72hou

  • 数码相机 约2010万有效像素 5倍光学变焦

    数码相机是集光学、机械、电子一体化的产品。它集成了影像信息的转换、存储和传输等部件,具有数字化存取模式,与电脑交互处理和实时拍摄等特点。光线通过镜头或者镜头组进入相机,通过数码相机成像元件转化为数字信号,数字信号通过影像运算芯片储存在存储设

  • 废玻璃分类 SB/T 10900-2010

    废玻璃分类SB/T10900-20101范围本标准规定了废玻璃的分类原则、类别及其要求。本标准适用于废玻璃的回收和分拣活动。2术语和定义下列术语和定义适用于本文件。2.1再生资源在社会生产和生活消费过程中产生的,已经失去原有全部或部分使用价

返回
顶部