OWSTIMER.exe message overflow Sharepoint log files

A somewhat known issue of getting Sharepoint log messages like,

03/19/2010 16:25:05.95  OWSTIMER.EXE (0x0794)                    0x0A54 Windows SharePoint Services    Timer                          5uuf Monitorable The previous instance of the timer job ‘Config Refresh’, id ‘{98B057E8-AD9C-46DC-A5EC-F69ED2550AF1}’ for service ‘{A1E122AE-D22D-46F7-A5F1-EF4DA0D549C4}’ is still running, so the current instance will be skipped.  Consider increasing the interval between jobs.

Continue reading “OWSTIMER.exe message overflow Sharepoint log files”

Why can’t I add a WFE to Sharepoint farm

After a lot of tbshooting it came to me to check versions/service pack levels. Sure enough the live/main site/server was running WSS3.0 SP1, while the servers I as attempting to join were running WSS3.0 SP2. After I upgraded the live WFE site to SP2, I could then add the other servers.

*Huge* got-ya hit me though in this process. I added a server that had the RS_Sharepoint add-in installed. A few minutes after adding it the main site when offline with nasty .NET errors. Event Logs on the server quickly showed that the web.config file was trying to load the Report Services addin modules!. I can only guess that the new server did some sync/? that caused the farm to think these were part of it.

Continue reading “Why can’t I add a WFE to Sharepoint farm”

Migrate Sharepoint Databases

Problem after renaming database server – duplicates and adding a new server gives error – still pointing to old db server. I’m unsure how good the “stsadm renameserver” command is since the database still appeared to have the old name that didn’t seem to keep the existing site/WFE from working but I couldn’t add any new servers/WFE – such as to add the RS Integration.

Continue reading “Migrate Sharepoint Databases”

Sharepoint Cross Forest-Trust Users How to add

There are documented steps needed to allow the Sharepoint site to add,pick users from a one-way trusted forest. This is what we have setup for our TrustedForest–> LocalDomain (also set as a selected trust).

Though I’d swear I didn’t have to do this on the first Sharepoint installation on Server1 but nothing I research or tried worked on second/third installations efforts. So I must have done such (a year ago) and after following the steps outlined below I’m able to add users from the trusted forest.

Sites quoted/researched for this solution,

  1. http://technet.microsoft.com/en-us/library/cc262051.aspx
  2. http://blogs.msdn.com/joelo/archive/2007/03/08/cross-forest-multi-forest-configuration-additional-info.aspx
  3. http://blogs.msdn.com/sharepoint/archive/2006/03/15/552331.aspx
  4. http://technet.microsoft.com/en-us/library/cc263460.aspx

Continue reading “Sharepoint Cross Forest-Trust Users How to add”

Sharepoint Report Server Integration (multi-server)

Follow all the steps at http://msdn.microsoft.com/en-us/library/bb677365.aspx

The best troubleshooting document is Chris Alton’s White Paper,  Reporting Services SharePoint Integration Troubleshooting

Perhaps one of the most typical of the difficult problems is the one I faced where after getting everything up and running with Sharepoint on one server and Report Services on another it through this error:

“An unexpected error occurred while connecting to the report server. Verify that the report server is available and configured for SharePoint integrated mode”

Continue reading “Sharepoint Report Server Integration (multi-server)”

Customize Report View Web Part in RS-Sharepoint Integrated Mode

Microsoft documentation at best alludes to the ability to modify 2 aspects of this web part, and similar to modifications for Report Manager.

1) Remove Export file types – Users don’t need more than PDF, Excel, and Image export types. Makes for a cleaner interface.

2) Remove Print Control – ActiveX that is only IE compatible and even MS’s own docs say the best way to printer is to export to PDF and then print!.

In the web part these are under the Actions dropdown.

Modify the List of Export File Types

Directly modify the rsreportserver.config file located on the RS server in the \MSRS10_Instancename\Reporting Services\ReportServer folder. The drive\folder is configured during initial installation of Report Services so it will vary.

Find the section for <Render> and locate the <Extension Name=….> you want to modify and add Visible=”false” within the /> – Example:

<Extension Name=”IMAGE” Type=”Microsoft.ReportingServices.Rendering.ImageRenderer.ImageRenderer,Microsoft.ReportingServices.ImageRendering”/>
<Extension Name=”WORD” Type=”Microsoft.ReportingServices.Rendering.WordRenderer.WordDocumentRenderer,Microsoft.ReportingServices.WordRendering”

The “Word” export type will be removed from the Export list. Do this for any of the export types you want removed or added as some like the RPL or HTML4.0 are removed by default..maybe you want to add them back.

No need to restart the server as the changes will be immediately picked up when you refresh the Sharepoint page..

Removing the Print Control

MSDN article – suggests a programmatic (sketchy) way of enable/disable the ActiveX print control but I recall I’d previously made this setting change and have re-discovered it. This article was helpful in noting the setting name “EnableClientPrinting”.

Searching the \Reportserver application folder for the “EnableClientPrinting” setting it was revealed within the file Catalog.sql (script used in installation) as a value in the database supporting RS. Ahhh – *lightbulb goes on*.

Fire-up SSMS and select connect to Report Server – remember in RS-SQL2008 that IIS is out so you access some settings via SSMS – and to connect you enter the full URL to the RS reportserver,


Once connected in SSMS you’ll see the server name and under that Jobs/Security/Shared Schedules. Mouse over the server name and rt-click for the popup menu and select Properties. Bingo! – you’ll see the “Enable Client Printing” checkbox towards the bottom of the General Settings.

Category: Sharepoint Customize
Published: 2/16/2010 3:02 PM
Updated: 12/05/2010

Sharepoint and Report Services Integrated Mode

Notes on multiple Report Services (RS) instances on single server and one is setup for Sharepoint integrated mode (http://msdn.microsoft.com/en-us/library/bb326356.aspx):

  • Ensure that all instances of Reporting Services are the same version. SQL Server 2008 Reporting Services (SSRS) introduces an updated version of the Reporting Services Windows Management Instrumentation (WMI) provider. You cannot have SQL Server 2008 Reporting Services (SSRS) and pre-SQL Server 2008 Reporting Services (SSRS) versions on the same computer.
  • If you run SQL Server 2008 Setup for each report server instance at different times, restart the WMI service after you install the second instance of SQL Server 2008 Reporting Services (SSRS).

Continue reading “Sharepoint and Report Services Integrated Mode”

SharePoint (v3.0) Link Lists core modification for Open in New Window

Background: Often requested option by users is for a link to external page in a Link List webpart/list to open to a new browser window. SharePoint doesn’t support this action/option without some modifications.

In the simplest form this means adding code to each link html tag like “target=_blank”. This code tell the browser to open a new window when the link is clicked.

SharePoint builds the Link List url/html tag programmatically during the site’s page display so adding the noted code also requires some programmatical way*.

*Note: <shift>+click by the user also will open any link in a new window.

A Google search for “SharePoint Links open in new window” will reveal numerous postings asking about this feature, why its not available (by default), and/or every type of fix or workaround imaginable. Most offer modifications that force ALL links to open in a new window – javascript code or core hacks (not flexible). Some suggested taking the entire list webpart and converting to xml part and modifying each link via code changes (yuck!). Only one by Andrew Connell seemed to offer hope of adding it as an option for each link within the context of the link list. But I had some issues with his suggestion in that you had to create an addition calculated field to merge the URL + target=_blank along with numerous core code modifications which applied to v2.0 (older version) of SharePoint.

Continue reading “SharePoint (v3.0) Link Lists core modification for Open in New Window”