How to install SQL Server Report Pack for SPS?

I want to install the report pack for SPS, but I am a little unsure
about the install process. I have a single SPS box (web, index,
search) and a single SQL box. Exactly what do I need to install for
the report pack to work... and on which server?

The system requirements state that you need the following, but they do
not clarify on which server(s).

Server OS
SPS 2003
SQL Server with dbSPSReportStaging and dbSPSReporting installed
SQL Reporting Services
Visual Studio .NET
LogParser

Does all of this need to be installed prior to the packs and on which
server(s)?

When I attempted to install the packs on my SQL server which already
has SQL Report Server installed, during the install it says that to
"Deploy Report Solution" it needs Visual Studio and to "Install Data
Extraction Program" it needs SPS. Does this mean that I should be
installing the packs on my SPS box? If so, that would mean that I
would also need to install SQL Server and the reporting services on it
also.

These instructions seem a bit "fuzzy" to me at best. Can anyone give
me the proper install order and on which server, etc?

Thanks for any help!

David Goebel

davidg
Fri Oct 28 12:04:05 CDT 2005

Well, I have tried to install the Report Pack on my SQL box (even
though the dialog box stated that I needed Visual Studio and SPS) and I
got an error that said "Object reference not set to an instance of an
object"... good grief. Somebody please enlighten me on what I need
to do in order to use these packs.

Why is everything with SPS end up being so difficult? Somebody please
help get this installed as I really want to check search usage, etc.

Thanks.

David Goebel

davidgDONOTSPAM
Fri Oct 28 12:37:01 CDT 2005

Ok you MVP's, time to earn your stripes :)

I have been unable to find any further information regarding the install
process.

David Goebel



"davidg@cuiab.ca.gov" wrote:

> I want to install the report pack for SPS, but I am a little unsure
> about the install process. I have a single SPS box (web, index,
> search) and a single SQL box. Exactly what do I need to install for
> the report pack to work... and on which server?
>
> The system requirements state that you need the following, but they do
> not clarify on which server(s).
>
> Server OS
> SPS 2003
> SQL Server with dbSPSReportStaging and dbSPSReporting installed
> SQL Reporting Services
> Visual Studio .NET
> LogParser
>
> Does all of this need to be installed prior to the packs and on which
> server(s)?
>
> When I attempted to install the packs on my SQL server which already
> has SQL Report Server installed, during the install it says that to
> "Deploy Report Solution" it needs Visual Studio and to "Install Data
> Extraction Program" it needs SPS. Does this mean that I should be
> installing the packs on my SPS box? If so, that would mean that I
> would also need to install SQL Server and the reporting services on it
> also.
>
> These instructions seem a bit "fuzzy" to me at best. Can anyone give
> me the proper install order and on which server, etc?
>
> Thanks for any help!
>
> David Goebel
>
>

Hollis
Fri Oct 28 23:11:20 CDT 2005

In article <52EEF3C4-D095-46D5-A3A5-4DF250F9C050@microsoft.com>,
=?Utf-8?B?RGF2aWQgR29lYmVs?= wrote:
> Ok you MVP's, time to earn your stripes :)
>
> I have been unable to find any further information regarding the install
> process.
>
> David Goebel
>
I used your subject as a search term on MSN.com, and got the following
hits:

Web ResultsPage 1 of 4,079 results containing How to install SQL Server
Report Pack for SPS? (0.10 seconds)
Results
Thom Robbins .NET Weblog : The SQL Server Report Pack for SPS 2003
.. The SQL Server Report Pack for SPS 2003 In cased you missed it - A very
cool tool! The ... just installing this on my SPS server, and it needs
VS.Net 2003 to install. Do we have to have VS on our ...

blogs.msdn.com/trobbins/archive/2005/07/12/438112.aspx Cached page
Microsoft Office Assistance: Introduction
.. Comment on this Web page SQL Server Report Pack for SharePoint Portal
Server Deployment ... you with sufficient guidelines to install and
configure the Report Pack. This document assumes that you have ...

office.microsoft.com/en-us/assistance/HA012305181033.aspx Cached page
10/27/2005
Using Reporting Services SharePoint Web Parts in SQL Server 2000 ...
.. included with SQL Server 2000 Reporting Services Service Pack 2. It
describes how to install the Web Parts ... Microsoft SQL Server Report Pack
for Financial Reports ... the WSS and SPS teams. Target ...

www.microsoft.com/technet/prodtechnol/sql/2000/maintain/webrssp2.mspx
Cached page
Mat Stephen's SQL Server WebLog : Free SQL Server Tools, Utilities and ...
.. Microsoft SQL Server Report Pack for Microsoft Axapta 3.0 . This is a
set ... To install these procedures, I recommend you read the ...
SharePoint Portal Server (SPS), IIS, Office Web Components (OWC) ...

blogs.technet.com/mat_stephen/archive/category/8471.aspx Cached page
Microsoft SQL Server September 2005 Community Technology Preview
Microsoft SQL Server September 2005 Community ... before you install SQL
Server 2005 Community Technology ... When an instance of SQL Server 2005
that hosts the report server database for an ...

download.microsoft.com/download/1/f/8/1f8af9ba-751e-440d-ba2c-006d680b7c81/
ReadmeSQL2005.h... Cached page
GAYAN PEIRIS'S SHAREPOINT BLOG
.. that you may experience when you install the service pack and about how
to determine whether ... you to the new Microsoft® SQL Server? Report Pack
for SPS 2003. (That?s quite a long name, so from ...

gpeiris.blogspot.com Cached page
Karen's SQL Blog: Chip Andrews' SQLSecurity.com Site
.. usually to install SPs). forceSQL - Nilesh Burghate's SQL Server
password ... service pack levels. From Microsoft and Shavlik. spdecrypt.zip
- Decrypt SQL Server 7.0 stored ... org/port_report.php?port ...

blog.pinpub.com/archives/sqlblog/2005/01/chip_andrews_sq.html Cached page
Karen's SQL Blog: Security Archives
.. your SQL Server. Includes an ... install SPs). forceSQL - Nilesh
Burghate's SQL Server password brute force ... service pack levels. From
Microsoft and Shavlik. spdecrypt.zip - Decrypt SQL Server 7.0 stored ...

blog.pinpub.com/archives/sqlblog/security Cached page
Show more results from "blog.pinpub.com".
INF: SQL Server 7.0 Service Pack 2 Fixlist
.. INF: SQL Server 7.0 Service Pack 2 Fixlist View products that this
article applies ... May Incorrectly Report Error 2513 53838 246598
(http://support ... Impact of Remote SPs Not Returning Result Sets 57173
262446 ...

support.microsoft.com/support/kb/articles/Q254/3/69.ASP 10/27/2005

Putting the same string into Google produces:

Tip: Have a question? Ask the researchers at Google Answers.

Download details: SQL Server 2000 Report Pack for SharePoint ...A set of 8
reports that work with a sample database of information extracted from a
SharePoint Portal Server environment.
www.microsoft.com/downloads/
details.aspx?FamilyID=49159368-544B-4B09-8EED-4844B4E33D3D&displaylang=en -
24k - Cached - Similar pages


Reporting Services DownloadsSQL Server Report Pack for SharePoint Portal
Server 2003. Download this set of eight SQL Server 2000 Reporting Services
reports that work with a sample ...
www.microsoft.com/sql/reporting/downloads/default.mspx - 25k - Cached -
Similar pages
[ More results from www.microsoft.com ]


Thom Robbins .NET Weblog : The SQL Server Report Pack for SPS 2003sql
server report pack for sps. Tuesday, July 12, 2005 6:08 PM by Method ~ of ~
failed ... I was just installing this on my SPS server, and it needs VS.
..
blogs.msdn.com/trobbins/archive/2005/07/12/438112.aspx - 40k - Cached -
Similar pages


Johnwe's SharePoint WebLog : Announcing: The SQL Server Report ...The
Microsoft® SQL Server Report Pack for Microsoft® Office SharePoint® Portal
Server 2003 is a set of predefined report definition files that work with a
..
blogs.msdn.com/johnwe/archive/2005/07/12/437997.aspx - 41k - Cached -
Similar pages


Download Microsoft SQL Server Report Pack for Microsoft Office ...Microsoft
SQL Server Report Pack for Microsoft Office SharePoint Portal Server 2003
1.0 ... Free MDB Viewer for PC without Microsoft Access installed ...
www.softpedia.com/get/Internet/Servers/Database-Utils/
Microsoft-SQL-Server-Report-Pack-for-Microsoft-Offi... - 87k - Cached -
Similar pages


SQL Server Report Pack for SharePoint Portal Server 2003The Microsoft SQL
Server Report Pack for Microsoft Office SharePoint Portal Server 2003 is a
set of 8 Microsoft SQL Server 2000 Reporting Services reports ...
geekswithblogs.net/barttimmermans/ archive/2005/07/06/45520.aspx - 21k -
Cached - Similar pages


SharePoint and Reporting Services - Installation ResourcesAfter installing
Reporting Services (and Service Pack 2), do the following (these ...
rsactivate -c "C:\Program Files\Microsoft SQL Server\MSSQL\Reporting ...
blogs.officezealot.com/ mauro/archive/2005/07/08/6729.aspx - 19k - Cached -
Similar pages


SahrePoint Site StatisticsThe Microsoft SQL Server Report Pack for
SharePoint Portal Server is a set of 8 Microsoft SQL Server ... Install the
following onto your SPS or WSS server: ...
www.wssdemo.com/Pages/stats.aspx?menu=Articles - 36k - Cached - Similar
pages


Bink.nu | Microsoft SQL Server Report Pack for Microsoft Office
..Microsoft SQL Server Report Pack for Microsoft Office SharePoint Portal
Server ... have mostly viewed the thread titled "Disk mirroring between
servers". ...
bink.nu/Article4425.bink - 53k - Cached - Similar pages


SQL Server Report Packs for IIS and SPSSQL Server Report Pack for SPS:.
Storage Report Shows a listing of the virtual servers and the number of
collections, sites, areas, lists, files and size. ...
andrewconnell.com/blog/archive/2005/07/11/1720.aspx - 24k - Cached -
Similar pages

***********************

I suspect there should be some help there, and you could have done that
yourself in the time you waited for messages in the newsgroup. Actually,
you should have done that first.

If none of the SPS MVP's have used that report pack, they can't really make
a definitive response; any more than I can.



Hollis D. Paul [MVP - Outlook]
Hollis@outhousebythesound.com
Mukilteo, WA USA

davidg
Mon Oct 31 10:17:08 CST 2005

Good grief, what is it with you MVP's lately? Yes, I already looked
through those. If you read all of my posts you would see that I have
already been attempting to get this thing installed. What I need is
some further help that will clarify exactly how to install the packs.
Your advice puts me back to square 1, when I am already on square 9.

Lastly, shouldn't the "MVP's" be some of the first people to be
using this thing?

Has anybody out there got the report packs to work? If so, please
chime in.

Thanks.

David Goebel

Joe
Mon Oct 31 13:57:22 CST 2005

Hi David,
I was able to get the report pack working, but I have a single-server
deployment, with SP 2003 and SQL 2000 on the same box. I don't have Visual
Studio installed on the server. I installed all the other reporting stuff
(parser, reporting services, etc) on the server without incident.

Another problem you'll run into is that there are bugs in the reporting
server database schema, which can be resolved by using this KB article:

http://support.microsoft.com/?kbid=906508

Good luck,
-- Joe


"davidg@cuiab.ca.gov" wrote:

> I want to install the report pack for SPS, but I am a little unsure
> about the install process. I have a single SPS box (web, index,
> search) and a single SQL box. Exactly what do I need to install for
> the report pack to work... and on which server?
>
> The system requirements state that you need the following, but they do
> not clarify on which server(s).
>
> Server OS
> SPS 2003
> SQL Server with dbSPSReportStaging and dbSPSReporting installed
> SQL Reporting Services
> Visual Studio .NET
> LogParser
>
> Does all of this need to be installed prior to the packs and on which
> server(s)?
>
> When I attempted to install the packs on my SQL server which already
> has SQL Report Server installed, during the install it says that to
> "Deploy Report Solution" it needs Visual Studio and to "Install Data
> Extraction Program" it needs SPS. Does this mean that I should be
> installing the packs on my SPS box? If so, that would mean that I
> would also need to install SQL Server and the reporting services on it
> also.
>
> These instructions seem a bit "fuzzy" to me at best. Can anyone give
> me the proper install order and on which server, etc?
>
> Thanks for any help!
>
> David Goebel
>
>