Saturday, August 2, 2008

SSRS integration with SharePoint

Better late than never - A PG site for SSRS integration with SharePoint

I am aware and painfully so that a PG blog / site dedicated to SSRS integration with SharePoint has been long overdue. Hence, for my initial post I have compiled a short list of some unanswered questions I have seen from blogs / newgroups etc. on this subject. Feel free to send me your issues / thoughts on RS integration with SharePoint and I will try as best to answer / address them and post new blogs as and when required. I hope you find this helpful.

  1. Is it possible to integrate SQL Server Reporting Services with WSS3 not MOSS ? Additionally, Is it possible to run Sharepoint Services and SQL Reporting Service on Windows 2003 X64?
    Yes it supports both WSS 3.0 and MOSS 2007. Additionally it is supported on x86 and x64. For details refer to Requirements for Running Reporting Services in SharePoint Integrated Mode
  2. Does RS integrate with a SharePoint WFE using Forms or Basic Authentication?
    Yes, it does. Make sure you install Forms auth hotfix 939942 and the Basic auth hotfix 50001712 for the RS 2005 SP2 Add-in for SharePoint.
  3. Does Reporting Services support Alternate Access Mappings (AAM)? If not, then what are the alternatives?
    Reporting services only supports access via the default zone in AAM. You will get an error along the lines  "The specified path refers to a SharePoint zone that is not supported" if you try to access a report from a non-efault zone. You can consider a workaround wherein multiple “Internal URLs” (Internet, intranet, etc.) for the same web application use a single “Public URL for Zone” all in the AAM default zone. Full AAM support is being considered for the next version post-SSRS 2008.
  4. Is there support for Reporting against SharePoint lists?
    SSRS does not natively ship a SharePoint Lists data extension as yet. Here are option that may want to consider:
    • Using the out-of-the XML data extension to read and wrtie to a SharePoint via the GetListItems and SetListItems methods of the SharePoint List web service. I have attached a TicTacToe.rdl report that I demo'd @ TechEd / TechReady. This report reads from and writes to a SharePoint list by the name oif TicTacToe.  
    • Other third-party solutions like Enesys RS data extension
    • Develop a custom solution such as this blog from Teun Duynstee.
  5. How do I fix the "User cannot be found" error?
    This is a bug in wherein if the author /creator / publisher of a report is deleted from the site in which the report resides. Possible workarounds can be found in "User Cannot be found" RS Forum thread. We are working on releasing a hotfix #50003017 with the upcoming SQL 2005 SP2 CU to fix this issue.
  6. Which authentication modes should I use - Windows Integrated or trusted account?
    Only use Windows Integrated for Kerberos enabled environments and in single-box deployment scenarios. For the rest use Trusted Account mode. In the scenario wherein you are having trouble setting-up Kerberos you should consider using Trusted account mode to at least setup and verify RS integration with SharePoint works. Once you have fixed your Kerberos issues then you can choose to switch to using Windows integrated.
  7. How do I fix the error message "The report server cannot access settings in the Sharepoint configuration database.  Most likely, the Windows Sharepoint Services object model is not installed..."?
    This is generally noticed in a multi-machine scenario when SharePoint WFE and RS are on separate machines. Make sure you install the minimum SharePoint install on the SSRS machine. For details refer to How to: Configure SharePoint Integration on Multiple Servers
  8. Is Reporting Services Integration with SharePoint supported on SQL Server Express SKUs?
    No it is only supported on Standard and higher SQL SKUs. There are no plans to include it is Express SKUs. For the details refer to the SSRS feature matrix.
  9. I am trying to get this working on a domain controller and the "grant database access" step always fails with "A new member could not be added to a local group because the member has the wrong account type"?
    Make sure your Report Server services accounts are domain accounts on a DC, else you will get this error when try to to add them to the local WSS_WPG group.
  10. I have a MOSS 2007 site set up on "localhost" and RS 05 is running in native mode.How can I view the reports in sharepoint webparts on the site?
  11. How to publish to SharePoint document library via Report Designer? 
    Make sure you have SQL 2005 SP2 BIDS when deploying to SSRS 2005 SP2 and the following project properties set to absolute paths:
    TargetDataSourceFolder http://<SharePoint_site>/<SharePoint_Doclib>
    TargetReportFolder http://<SharePoint_site>/<SharePoint_Doclib>
    TargetServerURL: http://<SharePoint_site>
    If you have issues deploying to a SharePoint site that uses Forms Authentication mode then consider posting directly to the Report Server by changing TargetServerURL to:
    TargetServerURL: :/http://<server_name>:<port>/<ReportServer_VDIR>
    For details refer to How to: Publish a Report to a SharePoint Library from Report Designer
  12. What do I do when I get "User does not have permission to add feature to site collection" when installing the RS Add-in for SharePoint msi?
    Locate the installation log created by the RS Add-in msi in the Temp folder - <Drive>:\Documents and Settings\<user_name>\Local Settings\Temp\RS_SP_<number>.log file. Next you should be able to locate log entries along the lines:  
    Activating feature to root site collection: <sharepoint_site_collection>
    ******* User does not have permission to add feature to site collection: <sharepoint_site_collection>
    This means that the RS integration feature was installed however the feature may not be activated for the <sharepoint_site_collection>, because the user who ran the msi wasn't a site collection admin. In order to view the RS integration feature in the site you need the site colection administrator to activate the Report Server feature. 
  13. When I try to access a report thru the MOSS Site I get an internal catalog exception near GetSystemPropertiesAction() but it works just fine when I access it directly from the report server URL?
    This is may happen when there are multiple Central Administration sites in a SharePoint Farm. Verify this by checking whether you see multiple URLs for “Central Administration” Alternate Access Mappings Collection under Central Administration -> Operations -> Alternate Access Mappings. If this is the case, then browse to the Report Server URL directly and determine the http://<server_name>/ in the SharePoint sites listed. Ensure the URL containing this <server_Name> is first in the list of URLs for the "Central Administration" group under Central Administration -> Operations -> Alternate Access Mappings. This issue has been fixed in SSRS 2008 RC0.
  14. What are some newer whitepapers related with RS integration?

    SQL Server 2005 Integration with Microsoft SharePoint Products and Technologies

    Troubleshooting Integration with SQL Server 2005 and Microsoft SharePoint Technologies

 

http://blogs.msdn.com/prash/archive/2008/08/02/better-late-than-never-a-pg-site-dedicated-to-ssrs-integration-with-sharepoint.aspx

Windows Vista® Performance and Tuning

Improve Performance Quickly and Easily

This guide focuses on performance improvements on a single computer, but also takes a look at some of the tools used in enterprise environments to help make performance tuning manageable on a much larger scale.

Windows Vista and SP1 focus on delivering greater performance and overall system responsiveness. By striking a balance between speed and responsiveness, Windows Vista and SP1 deliver a level of performance that has the greatest positive impact on the system’s usability.This guide looks at the following areas of performance improvement:
• Making configuration changes that help a computer feel more responsive when you use it.
• Using hardware to boost the actual physical speed of a computer.
• Making configuration changes that help a computer to start faster.
• Making the computer more reliable may help increase performance.
• Monitoring performance occasionally so that you can stop problems before they get too big.

Version: 1.0

Date Published: 7/28/2008

Language: English

PDF Link : http://download.microsoft.com/download/2/8/8/28869476-67ec-4bec-a8f7-1ded39d3f161/Windows%20Vista%20Performance%20and%20Tuning%20-%20Final.pdf

Download details: Windows Vista® Performance and Tuning

InfraRecorder

This seems to meet my needs, has a portable (Installation not need version) as a bonus.

InfraRecorder

The free CD/DVD burning solution

Latest version: 0.45

InfraRecorder is a free CD/DVD burning solution for Microsoft Windows. It offers a wide range of powerful features; all through an easy to use application interface and Windows Explorer integration.

InfraRecorder is released under GPL version 2.

Features

  • Create custom data, audio and mixed-mode projects and record them to physical discs as well as disc images.
  • Supports recording to dual-layer DVDs.
  • Blank (erase) rewritable discs using four different methods.
  • Record disc images (ISO and BIN/CUE).
  • Fixate discs (write lead-out information to prevent further data from being added to the disc).
  • Scan the SCSI/IDE bus for devices and collect information about their capabilities.
  • Create disc copies, on the fly and using a temporary disc image.
  • Import session data from multi-session discs and add more sessions to them.
  • Display disc information.
  • Save audio and data tracks to files (.wav, .wma, .ogg, .mp3 and .iso).

InfraRecorder » Welcome

Friday, August 1, 2008

SharePoint : You asked for it, you got it: .chm builds of library content

 

A frequent request from customers and partners is to create a download that contains all of the content from our technical library in compiled help format (CHM). Well, it took a while, but due to some positive changes in our authoring environment, we can now build .chm files of our content. Now live and available for your downloading and searching pleasure: Office SharePoint Server 2007 Technical Library in Compiled Help format.

We'll refresh monthly, and post the updates on our newly published content list, so check back and grab the hot, fresh content regularly. If you like this one, we'll do one for Windows SharePoint Services too.

To the SharePoint : You asked for it, you got it: .chm builds of library content

goosh.org - the unofficial google shell.

Goosh goosh.org 0.5.0-beta #1 Mon, 23 Jun 08 12:32:53 UTC Google/Ajax
Welcome to goosh.org - the unofficial google shell.
This google-interface behaves similar to a unix-shell.
You type commands and the results are shown on this page.
goosh is powered by google.
goosh is written by Stefan Grothkopp <grothkopp@gmail.com>
it is NOT an official google product!
Enter help or h for a list of commands.

Loading local settings...

guest@goosh.org:/web>

http://goosh.org/

Microsoft Deployment Toolkit 2008 Update 1 is now Available

 

Microsoft Deployment Toolkit 2008 Update 1 is now Available

Published 01 August 08 12:21 AM | msdeployment

We are pleased to announce the release of our first update to Microsoft Deployment Toolkit 2008  (MDT 2008).  We have added two major features:  OEM preload scenarios for Lite Touch Installation and Zero Touch Installation with System Center Configuration Manager 2007 and a new management pack for System Center Operations Manager 2007 SP1.  Minor updates include bug fixes and design changes to override driver platforms as well as the ability to inject all drivers into Windows PE. 

Get MDT 2008 Update 1 and the new Quick Start Guides from the Download Center. All of the latest documentation can be found within  updated and  searchable help files.  However, if you would like a full collection of the Word documents, download it here.

Microsoft Deployment Toolkit Team Blog : Microsoft Deployment Toolkit 2008 Update 1 is now Available

SCVMM 2008 Release Date

 

SCVMM 2008 Release Date

In case you missed it, we recently announced a more precise date for the final release of SCVMM 2008 -  September 2008. Previously we had said that it would be the second half of 2008 but Hyper-V shipped early and we're coming down the home stretch as well. At this stage of the game, shipping software is as much art as it is science so it's hard to pin down an exact date. Our single focus for the past four months has been quality and that will continue to be our focus until we ship. We have been testing SCVMM in as many configurations and use cases as is humanly possible in addition to cranking up the performance and scale limits. We're working with a small group of aggressive early adopters in parallel with our efforts here in Redmond to ensure we're battle tested before the general release.

Stay tuned......

rakeshm's VM Management Blog : SCVMM 2008 Release Date

Blog Archive