This blog post discusses the additional manual steps SharePoint Integrated Reporting Service instances will need in order to be fully patched correctly.
As part of the October 2009 Microsoft Security Patch Release, the security patch MS09-062 contains fixes for SQL Server 2005 Reporting Services (SSRS). This patch will normally automatically be applied to your Reporting Services instances either through Windows Update or applied as part of your company’s normal security patch process.
However, for Reporting Services instances that are installed in SharePoint Integrated mode, you need to apply an updated “Microsoft SQL Server 2005 Reporting Services Add-in” also. This will NOT be done automatically as part of the update process.
In most deployments, this updated add-in will need to be applied on your Reporting Services server and all your SharePoint Web Front Ends. Basically, wherever you have already installed this add-in in the past.
There is an SQL 2005 SP2 and SP3 version of this patch so I will list the KB article and the add-in download link:
SQL 2005 SP2 Add-In Details
MS KB 970896
Download add-in here (make sure you grab x32 or x64 as need)
SQL 2005 SP3 Add-In Details
MS KB 970894
Download add-in here (make sure you grab x32 or x64 as need)
Categories: Microsoft Office Sharepoint Server
Tagged: Security, SharePoint, SSRS
This post is focused on installing SQL Server 2008 on a Windows 2008 R2 server for those of only need to do a few installs. In other words, this is the quick fix. At the bottom of this post is the solution for how to resolve this issue if you regularly install SQL Server in this configuration. In other words, at the bottom is the enterprise solution. For me, I ran into this issue building a virtual machine for local testing of SharePoint.
I ran into a problem installing SQL Server 2008 (SQL2K8) RTM onto a Windows 2008 R2 server. After some research, the issue is SQL2K8 is not supported on Windows 2008 R2 without SQL2K8 Service Pack 1. We receive this error message when you try the install:

If you continue the install process, you will get through all the setup screens but the installation of any of the services will fail. The issue is the setup files that come with the RTM version of SQL2K8 cannot properly install the services on the R2 version of Windows 2008. Anything I did from this point forward did not resolve the issue. I did some research and found the answer. I started with a clean Windows 2008 R2 image and started my resolution process from there.
So here is the work around solution. Before you even try to install SQL2K8, run the SQL2K8 Service Pack 1 install. As it starts up, it will install the latest group of setup support files.

After this part is done, it will not detect any installed SQL components (to be expected) and you will cancel the installation. Now run the installation of SQL2K8 just like you always would. The installation will detect that there are newer versions of the setup files installed already and will use them instead. These SP1 setup files are aware of Windows 2008 R2 and your installation will complete successfully.
Remember to go back and re-run the SQL2K8 Service Pack 1 to actually update the installed services on your system now. That is it! You are done!
Enterprise Solution: If you are regularly installing SQL2K8, this solution is very much a work around and adds extra steps and time. The solution for when doing several installs is to make a SQL Server 2008 SP1 slipstream install location. With this solution, you will be able to run the install once, have it install without errors, have the server configured and have the service pack already installed.
Categories: Microsoft Office Sharepoint Server
Tagged: SQL Server 2008, Windows 2008 R2
It was great to be able to speak and to see the great turnout for the event this year. There were over 400 attendees this year and with speakers and volunteers over 500 people involved. As always, feel free to provide any feedback and ask questions in the comments.
My presentation on Best Practices for SharePoint Deployment and Management is available for download.
Categories: Microsoft Office Sharepoint Server
On Saturday, April 18, 2009, there will be an all-day MOSS Camp taking place in St. Louis, MO focusing on all things SharePoint and we are looking for speakers. The current plan is to have four tracks covering the following topics: Development, Infrastructure, Governance/Business, or End User. The session can contain 100, 200, or 300 level information.
Submissions for speakers are being accepted immediately.
Registration being open for attendees will be announced soon. More information will be posted on the St. Louis SharePoint Users Group site as it becomes available and you can follow the St. Louis MOSS Camp twitter account for updates as well.
Categories: Microsoft Office Sharepoint Server
Tagged: MOSS Camp, SharePoint, Speakers
In this post, I will do a brief review of the state of 64-bit PDF iFilters for the Microsoft platform (this effects SharePoint). There have been a couple things occur in the last few days that I just wanted to point out.
First, let me review the purpose of an ifilter briefly for those who may not be aware. For Microsoft search products, an ifilter allows the indexer to read different file formats. So a PDF ifilter allows a Microsoft search product to open Adobe PDF files so that can be indexed and searched. Also, if you are running the MS Search Product on 64-bit platform, you want to run a 64-bit ifilter for performance and supportability reasons.
Until this month, in my opinion, the only production ready option for a 64-bit ifilter was offered by FoxIt Software. There are two things that have happened that I wanted to point out for your review.
- Finally, Adobe has released a 64-bit PDF ifilter. Their filter is free.
- FoxIt Software has released an update to their 64-bit PDF ifilter this month. There is a charge for their ifilter if you are using on a server (free for desktop use).
So if you are using FoxIt already, time to update your filter next patch cycle. If you need an ifilter, you may ask, “Why on earth would I use the FoxIt Software solution I have to buy now that Adobe has a free version?” There have been tests done to show that previously, the FoxIt ifilters (even 32-bit) performed better than the Adobe solution. I know the FoxIt version is multi-threaded. I do not know the capabilities of the free Adobe version yet.
So for Production environments, I would ask you to still consider the FoxIt solution. But if you can’t afford it, there is an alternative now. As more testing is done with these filter solutions, hopefully we will have more information to make a decision.
If you need help installing the ifilters, here are some links that will help:
For SPS 2003: http://support.microsoft.com/kb/555209
For WSS 3.0: http://support.microsoft.com/kb/927675
For MOSS 2007: http://blogs.microsoft.co.il/blogs/adir_ron/archive/2007/05/03/Just-Released-_2D00_-PDF-IFilter-for-x64-Bit_2100_.aspx
How to add the PDF icon
And if you install SharePoint updates/patches, remember that you need to reinstall the FoxIt PDF ifilter.
Categories: Microsoft Office Sharepoint Server
Tagged: 64-bit, PDF ifilter, Search, SharePoint