Running into some problems working with SharePoint? No worries, here are the tips and tricks to help you solve your problems.

Installing Reporting Services for SharePoint 2007

By | SharePoint Tips | No Comments

MS SQL Server 2008 Reporting Services for SharePoint are tricky to install, but following these steps will ease the installation pain.

  • Add the Admin for this SQL Server to the farm administrators of the SharePoint farm. This is important to connect to SharePoint farm with the Reporting Services.
  • Install SQL Server Reporting Services on one SharePoint Farm server.
  • Install the Reporting Services SharePoint Add-ins. In this case rsSharePoint_x64.msi.

If you get errors during installation, you can run Setup in files-only mode, and then run a custom actions executable after the files are copied to the server. To install the Reporting Services Add-in in files-only mode, do the following:

Run rsSharePoint_x64.msi SKIPCA=1. A files-only installation runs the Installation Wizard.

Find the rsCustomAction.exe file on the file system. This file is copied to your computer by the Setup program. The file will be located in the %Temp% directory.

To get the path information for this file, click Start, click Run, and then type %temp%. The file should be located in Documents and Settings<your name>LOCALS~1Temp.

Open a command prompt window. To do this, click Start, click Run, and type cmd.

Navigate to the folder that contains the rsCustomAction executable.

Enter the following command. This configuration step will take several minutes to complete. The W3SVC service will be restarted during this process.

rsCustomAction.exe /i

Read More

Enable PDF Indexing With SharePoint 2007

By | SharePoint Tips | No Comments

By default PDF indexing is not enabled with SharePoint 2007. This is important to remember when adding PDF documents to document libraries you will be surprised that no PDF documents will show up in the search results.

To enable PDF indexing you need to configure the following steps:

Download Adobe Reader 9.0, which includes IFilter, from

Download the Acrobat PDF Picture, to display in front of PDF search result items, from

Add the PDF file type to the Extensions List for WSS search by editing the registry

  • Start regedit
  • Open the key HKEY_LOCAL_MACHINESOFTWAREMicrosoftShared ToolsWeb Server Extensions12.0SearchApplications{Random GUID}GatherSearchExtensionsExtensionList
  • Add PDF to the list as a new String Value. Use a new high value e.g. if 37 is the highest value, use “38” as the key with the value “pdf”

Add the Acrobat PDF picture to the SharePoint templates directory. Copy the Acrobat PDF picture called pdficon_small.gif in the 12 HiveTEMPLATEIMAGES folder, e.g. %programfiles%Common FilesMicrosoft SharedWeb Server Extensions12TEMPLATEIMAGES.

Read More