Tip For The latest information regarding issues with SQL Server 2012, see Reporting Services SQL Server 2012 Tips Tricks, and Troubleshooting ttpgo.SQL Server Reporting Services SSRS is part of Microsoft SQL Server services since version 2000.If you are an ordinary user with a basic knowledge of SQL, this.Reporting Services 2.R2 and Share.Point Server 2.The Next Generation of Integration If your organization currently uses or plans to use both Share.Point Server 2.SQL Server Reporting Services SSRS 2.R2 as separate products, you should consider using SSRS in Share.Point integrated mode.Reporting Services Add In For Microsoft Sharepoint Designer' title='Reporting Services Add In For Microsoft Sharepoint Designer' />Youll have only one security model to manage and, even better, business users will have only one environment in which to create, find, and share information, whether that information is in the form of reports, lists, documents, or other content types.Furthermore, you can manage reports using the same content management, workflow, and versioning features that you use for other Share.Point content.SQL Server 2.R2 adds many new features to SSRS, and several of the new features tighten integration with Share.Point 2.One benefit of the enhanced integration is that its easier to install and configure the Share.Point integrated mode of SSRS than it was in the previous versions of the two products.Youll also find additional benefits of the new integration features throughout the reporting life cycle as you author, manage, and access reports.Lets go exploring Installation There are many different ways to set up Share.Point for integration with SSRS.You can install all required software on a single server to create a development environment, or you can distribute components across multiple production servers for a Share.Point farm.Regardless of the specific topology, the overall architecture for an integrated environment remains the same, as Figure 1 shows.You start by installing a database instance to host the report server databases.You can use the same database instance to host the Share.Point configuration and content databases if youd like, but youre not required to keep all the databases in the same location.If you decide to place all the databases in the same database instance, the Reporting Services service account, which you set in the Reporting Services Configuration Manager, must be a domain account.The Share.Point databases will contain information used by the report server.The configuration database stores the URL for the Reporting Services Web service, information about the Report Server service account, and the authentication mode.It also includes configuration information about the server defaults, such as report history settings, processing timeouts, and logging.The content databases store the report server content types e.Even when SSRS runs in Share.Point integrated mode, the report server databases are still necessary.The Report.Server.Temp. DB database continues to store session data and cached instances, and the Report.Server database stores information related to snapshots, report history, subscriptions, and schedules.Furthermore, the Report.Server database also maintains copies of report server items that are stored in the Share.Point content database to facilitate faster processing during report execution.At the time that you install the database instance, you can also add SSRS to the feature selection if you plan to run the two components on the same server.Wherever you choose to install SSRS, you can install SSRS in Share.Point integrated mode immediately, or in files only mode if you prefer to manually complete the integration steps later.When SSRS runs in Share.Point integrated mode, it not only uses a different database structure but also uses custom security and delivery extensions.During the installation of Share.Point, there are several prerequisites that are installed as part of the standard process.One of these prerequisites is the Reporting Services Add in for Share.Point.Now that the add in is a prerequisite, you no longer have to worry about finding the download site for the add in file, making sure you have the right version for your combination of Share.Point and SSRS, and then installing the add in separately as earlier versions require.If you perform a non standard installation without installing the prerequisites automatically, you can still obtain the add in by downloading it from Microsoftand installing it separately on each Share.Point Web front end WFE.The add in installs a new endpoint to Share.Point as a proxy for the Reporting Services Web service. Backup Software Compatibility Esx Server 451 . Conference Room Floor Plan Software '>Conference Room Floor Plan Software .It also installs the Report Viewer Web Part that allows you to view your reports in Share.Point.Finally, the add in provides the application pages that are necessary for managing report properties, configuring data sources, setting up subscriptions, and everything else that Report Manager handles in a native mode deployment.If your report server is on a separate computer from the Share.Point server, your final step will be to install the Share.Point WFE on the report server and join the WFE to the Share.Point farm.Be sure to use the same version of Share.Point on both servers.Adding the WFE components to the report server enables it to communicate with the Share.Point configuration and content databases.SSRS Configuration If you installed SSRS in Share.Point integrated mode, no further configuration is necessary.However, if you installed it in files only mode, you need to open the Reporting Services Configuration Manager located in the Configuration Tools folder in the Microsoft SQL Server 2.R2 program group.Using this tool, you must specify an account to run the Reporting Services service account and a URL for the Reporting Services Web service.Then, create the report server database in Share.Point integrated mode.Share.Point Configuration After all the products are installed and the SSRS configuration is completed, youre ready to begin the Share.Point configuration process.For Share.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |