Installing Reporting Services for Share.Point 2. 01. 0, A GKM2 Blog.As you are well aware, Share.Point and SQL work very closely together and with each iteration of Share.Point and SQL, that integration gets tighter and tighter.One of the main attractions to integrating Share.Point with SQL Server Reporting Services, commonly referred to as SSRS is to allow users to create, modify and publish reports from within Share.SharePoint 2010 is definitely generating a lot of buzz out there in the community, especially amongst partners and customers and with the official launch only a.Point itself. Reporting Services SSRS provides some predefined content types that are used to manage various files, including the shared Report data source.Report Builder model.Installation Sharepoint 2010 Server Farm Data' title='Installation Sharepoint 2010 Server Farm Data' />Report Builder report definition.In my last article, I provided you with a step by step guid on configuring SQL Power.Pivot for Share. Point 2.In this article I will be providing you with a step by step guide in installing and configuring Reporting Services in Share.Point integrated mode.Installing SQL Reporting Services for Share.Point 2. 01. 0We begin by installing SQL Reporting Services for Share.Share, organize, and discover information with Microsoft SharePoint.Learn about SharePoint Online, OneDrive for Business, Yammer, and Apps for SharePoint.Since its inception, Microsoft SharePoint has used SQL Server to store its content, configuration, and application service data.SharePoint simply wont function.The first thing you need to be aware of if you are planning an upgrade from SharePoint 2010 to SharePoint 2016, is that there are no direct upgrade path you will.Point on our Application Server or on a dedicated Reporting Services Server with Share.Point running. Launch the SQL Server Installation Center and Select Installation and then click on New Installation or add features to an existing installation.Click Install to install the Setup Support Files.The setup support rules are then run.At this stage you should rectify any errors if present.Click Next. In the Installation Type page, select New installation or add shared features.Click Next. Enter the product key at the Product Key screen and click Next.Accept the License Terms and then click Next.Select SQL Server Feature Installation.Click Next. Select Reporting Services and Management Tools only.Click Next. Setup will run the Installation Rules.Address any failures and then click Next.Type a Named Instance.Click Next. Check your Disk Space Requirements.Click Next. In the Server Configuration page, enter a domain user account.Click Next. In the Reporting Services Configuration Page, the only option was to Install, but do not configure the report server.Click Next. The Installation Configuration Rules are run.Address any issues and click Next.Installation Sharepoint 2010 Server Farm Data' title='Installation Sharepoint 2010 Server Farm Data' />Click Install to proceed with the Installation. Check File System Windows Cmd Restart here. Once the installation has completed, Navigate to Start All Programs Microsoft SQL Server 2.R2 Configuration Tools and launch the Reporting Services Configuration Manager.Select the Report Server Instance and click Connect.On the left Task bar, select Database and click on Change Database.The Report Server Database Configuration Wizard is displayed and select Create a new report server database.Click Next. Enter a valid database name where you want to install the Report Server database.I will be hosting this on a remote SQL server which also houses my Share.Point Configuration and Content Databases.Click Next. Enter the Database Name and Select your Report Server Mode as Share.Point Integrated Mode.Click Next. Under Authentication Type, select Windows Credentials and enter a domain user account.Click Next. Review the Summary and Click Next.Click Finish once the configuration Wizard completes.Navigate to Web Service URL and change any values.I have changed my TCP port to 1.Click Apply. You should notice that the new URL was successfully reserved.Copy the Report Server Web Service URL to clipboard.This will be needed a little later.Click Exit. Integrate Reporting Services with Share.Point. Launch Share.Point Central Administration and navigate to General Application Settings Reporting Services Reporting Services Integration.Enter the details below.After clicking OK you will return to the Reporting Services Integration Summary Page with hopefully 3 green ticks with successful status.We now need to confirm that the that the Report Server Name and server instance is correctly listed in Share.Point. We do so by navigating to Share.Point Central Administration General Application Settings Reporting Services Add a Report Server to the Integration.To verify that we have correctly configured and integrated Reporting Services with Share.Point 2. 01. 0, we navigate to our Share.Point Site, Site Settings Site Collection Features and Activate the Reporting Server Integration Feature.After the activating the Report Server Integration Feature, we can navigate to our Share.Point Site and add the SQL Server Reporting Services Report Web Part, located under SQL Server Reporting.You can now upload your reports which will render directly in Share.Point. If you require any assistance with your Share.Point or other IT needs, the team at GKM2 are happy to assist.You can contact us via infogkm.How to Migrate From Share.Point 2. 00. 7 to Share.Point 2. 01. 0In this post I am going to walk you through how to migrate a Share.Point 2. 00. 7 environment to a Share.Point 2. 01. 0 environment.We will be moving from Windows Server 2.Standard to a newly built, Windows Server 2.R2 Standard machine.I have included screenshots in the walkthrough as well to make certain steps easier.For this migration, we will have a webapplication frontend server and a SQL database backend server.If you have not done so already, stage an environment with the following hardwaresoftware specs from Microsoft for your Share.Point 2. 01. 0 environment.Step 1 Run the pre upgrade check on your current Share.Point 2. 00. 7 environment.Make sure you are running Share.Point 2. 00. 7 with Service Pack 2 installed.Click Start Right click Command Prompt and Run as administratorIn the Command Prompt window navigate to the following directory COMMONPROGRAMFILESMicrosoft SharedWeb Server Extensions1.Type the following command and press Enter STSADM.EXE o preupgradecheckAfter the upgrade check is finished running, it should automatically open a browser.You can use this to troubleshoot any issues.Step 2 Youll want to back up the content database of your Share.Point Web Application in SQL Server.Note if you cannot take your live database offline when backing up, then click the Copy only Backup checkbox.After the backup is finished, restore the backed up database to a new created database in SQL Server.At this point your Share.Point Content Database has been checked for a valid upgrade and a new database has been created for your new Share.Point 2. 01. 0 site.Step 3 We will now move to our new Windows Server 2.R2 server and start the Share.Point 2. 01. 0 installation.Run setup. Install Software Prerequisites.Software Prerequisites will install.If you are curious as to all that is getting installed, here are the Roles and Features Web Server IIS role.Application Server role.Microsoft. NET Framework version 3.SP1. Microsoft Sync Framework Runtime v.Microsoft Filter Pack 2.Microsoft Chart Controls for the Microsoft.NET Framework 3. 5.Windows Power. Shell 2.SQL Server 2. 00.Native Client. Microsoft SQL Server 2.Analysis Services ADOMD.NETADO. NET Data Services Update for.NET Framework 3. 5 SP1.A hotfix for the.NET Framework 3. 5 SP1 that provides a method to support token authentication without transport security or message encryption in WCF.Windows Identity Foundation WIFStep 4 Click on Install Share.Point Server when the prerequisites finish installing and enter your Product Key and agree to the license terms.Step 5 Next you are greeted with the option of Standalone or a Server Farm.For this environment we are going to select Server Farm as it gives us more extensibility to add additional servers and roles down the road.If you already have your own instance of SQL on another sever, as we do in this build, then select Complete and click Install Now.Step 6 Once the install is complete assuming that there is only one server in the Farm run the Share.Point Products Configuration Wizard Now.If you plan on adding additional servers to the Farm, stop here and run the installation on the other servers and then run the Share.Point Products and Configuration Wizard on the server that will host the Central Administration console.The Share. Point Products Configuration Wizard will pop up.Click Next. You will be prompted with a warning that a few services that will be stopped and restarted during this configuration.Since this is a fresh install on a new server, we are okay with IIS and the other services being stopped and restarted.Step 7 If this is your first server in your farm, click Create a new server farm.If you are adding this server to a farm already created, then click the other.Step 8 Start keeping track of all your settings from here on out.In the next few steps we are going to specify the Database Server and the Database Name, along with the Database Access Account.Enter your appropriate settings Step 9 Share.Point 2. 01. 0 incorporates the concept of using a Paraphrase to add additional servers to the farm.Enter a paraphrase and remember it.Step 1. 0 The next screen is about configuring the settings for your Central Administration Web Application.Specify a port number I used 9.NTLM as your authentication provider.If you are using Kerberos, then see this Microsoft article.After clicking Next, you are prompted with a screen that displays your recent settings that you input.Check over everything and click Next.Share. Point 2. 01.Youll see a progress bar as Share.Point runs through 1.When completed, you will see a screen like the one below Reboot the server or run iisreset force from a CMD prompt when the configuration is complete.Step 1. 1 After the server reboot or iisreset, browse to your Share.Point Central Administration Site.From here I highly recommend using the wizard.It will walk you through the basic steps of setting up account dependencies.After the wizard completes, you should see a page like the one below Step 1.With the farm configured, well want to register a few accounts so that the Share.Point services can run appropriately.To register accounts, click on Security Configure Managed Accounts.I would start with registering an account for your Web Application, User Profile Synchronization Service, and Share.Point SearchCrawl.After you register your accounts, you can assign them to the appropriate service by going to Configure Service Accounts in the Security section.Select the service you want from the top dropdown list, and then select the corresponding service account you want to tie that service to.Step 1. 3 Now that your accounts are configured and associated with their service, we will create our new Web Application for our site.Click on Application Management on the left hand side, then Manage web applications.Click on New in the ribbon.Select your authentication mode, name of the site, port number, and the physical directory.Customize to fit your setup.Create a new Application Pool and select an account for it to run under.Network Service is fine, or if you have a specified Active Directory account, then you can select that.The Database Server is running on a separate machine, so enter the name of the server or the IP address.You can enter a Database Name here, but we will be removing this database later on, so it is not entirely important on what you name it.Customize the remaining Service Application Connections as needed and click OK.After clicking OK, your web application will be created.When it is finished, you are greeted with the prompt below.You can also open IIS Manager and view your site collection there.It will be called Share.Point lt port number.Step 1. 4 In the above step we just created the new web application for our Share.Point 2. 01. 0 site instance and created a temporary database name.We are now going to remove the temporary content database and start the process of attaching our Share.Point 2. 00. 7 database.Navigate to Application Management Manage Content Databases, and click on the current Database Name you see.It is most likely called WSSContent unless you change the name earlier.In that case, click the database name that you input.Scroll to the bottom of the screen and there is a checkbox to Remove content database.Check that box and click OK.Now there is not a Content Database associated with your Web Application.This is exactly what we want.Step 1. 5 Next we have to run the psconfig.Open an elevated CMD prompt and change the directory to C Program FilesCommon FilesMicrosoft SharedWeb Server Extensions1.BINFrom there run this command PSConfig.This will install additional features that allow the upgraded Share.Point 2. 00. 7 database to be mounted on the 2.Step 1. 6 After psconfig.Share. Point 2. 01.Management Shell.Open the Share. Point 2.Management Shell as Administrator and run this Power.Shell Cmdlet Mount SPContent.Database Name lt content.DB Database. Server lt server.DB Web. Application lt webappname lt content.DB upgraded Share.Point 2. 00. 7 Content Database Namelt server.DB name or IP address of SQL Serverlt webappname URL of web application, i.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. Archives
October 2017
Categories |