How to Install Reporting Services In Integrated Mode after SharePoint

  1. Click the Start button

  2. Click the Microsoft SharePoint 2010 Products group.

  3. Right-click SharePoint 2010 Management Shell click Run as administrator.

  4. Run the following PowerShell command to install the SharePoint service. A successful completion of the command displays a new line in the management shell. No message is returned to the management shell when the command completes successfully:


  5. Run the following PowerShell command to install the service proxy:


  6. Run the following PowerShell command to start the service or see the following notes for instructions to start the service from SharePoint Central administration:


    get-spserviceinstance -all |where {$_.TypeName -like "SQL Server Reporting*"} | Start-SPServiceInstance

You can also start the service from SharePoint central Administration rather than running the third PowerShell command. The following steps are also useful to verify that the service is running.

  1. In SharePoint Central Administration, click Manage Services on Server in the System Settings group.

  2. Find SQL Server Reporting Services Service and click Start in the Action column.

  3. The status of the Reporting Services service will change from Stopped to Started. If the Reporting Services service is not in the list, use PowerShell to install the service.


Office 2010 Features List

I came across an amazing list of features from Office 2010 I decided to publish it here for reference

Here’s what is known, at this point:

Microsoft officials are continuing to decline to comment on Office 14’s timetable or feature list. Nonetheless, there have been a few bits of information about O14 which have gone public. Among them:

Upgrade SharePoint SQL Express to Standard or Enterprise

Source : Todd Klindt’s SharePoint Admin Blog

Microsoft so very graciously provides a free version of SQL 2005, SQL Express, with MOSS. If you install MOSS using the Basic option or Single Server under Advanced you get SQL Express automatically. So what if as a budding newbie SharePoint admin you chose the Basic option, but now as a wise aged SharePoint admin you’ve seen the error of your ways and want to use a more respectable version of SQL for your SharePoint backend? You’re in luck. In this blog post I’ll walk you through upgrading SQL Express to SQL Standard or Enterprise.

First thing you need to do is get a copy of SQL 2005 Standard or Enterprise. Which version you choose depends on the redundancy and availability you want. Either will upgrade from Express. After you have your media you can start the install. This step is important as you have to pass the setup program a parameter to let it know you’re doing an upgrade. To upgrade use the command setup.exe SKUUPGRADE=1. It should look like this:

The setup should kick off and it won’t give you any indication that you passed it a parameter. Never fear, it will come up later. When the setup gets to the instance selection make sure you don’t accept the default instance and you choose the SQL Express instance. First click Installed Instances:

Then choose the OFFICESERVERS instance from the list and hit OK:

Your next screen should confirm that it found SQL Express:

If you click the Details… button you’ll see that the setup confirms that SQL Express can be upgraded. This step is optional.

At this point you can Close the box and hit OK until the setup is finished. After the setup is finished you’ll want to apply SP2 for SQL 2005 and any post SP2 patches that are available. I don’t know if it’s required but I always do an IISRESET after this to make sure that SharePoint reconnects properly to SQL.

That’s all there is to it. Once you are using full SQL you have quite a few more options available to you like log shipping, database replication, SQL Profiler and more. If you have any questions about how to leverage those tools with SharePoint, leave me a comment and let me know.