Reporting Services section is not Showing under Application Management

Hi,

I installed Reporting Services Add-in for Sharepoint 2007, on my Server where i have both Sharepoint 2007 and SQL Server 2005 and report Server are installed, i already installed SQL Server SP2, but in SharePoint 3.0 Central Administration under Application Management Reporting Services section is not Showing.

Please let me know if anybody has the got the same issue and fix it.

Thanks

Ahsan

Make sure the Windows user account you used to install RS add-in is one of the Site Collection administrators in SharePoint.
Also make sure you are not using FrontPage Server Extension in your default Web Site.

Good luck!

Chun
sql

Reporting Services Management

What tools are available to manage which users are currently running what
reports, parameters selected, load on server etc. Basically I'm trying to
figure out how I determine if Reporting Services is slow, what report/user is
causing it, or if it's just a lot of people asking for reports and I need to
look at scaling the server.
I'm interested in historical stuff, but I'm also interested in real time
this is what's happening where with what components. For instance is
retrieval slow or is it rendering that's slowing the report down, slamming
the cpu etc.
I see the DTS package for the logs and am installing that, but is there
anything more immediate like current activity in SQL server?Larry,
Your first stop should be the Execution Log. Check "Report Server Execution
Log" topic in the documentation. Among many other things, the Execution Log
will tell you how much time is spend in querying the data, processing and
rendering the report. In addition, in Report Manager you can see the current
activity (Running Jobs).
Warning.. shameless self-promotion :-) Accidentally, my book includes a
whole chapter (Chapter 16) on the RS performance and scalability.
--
Hope this helps.
---
Teo Lachev, MVP [SQL Server], MCSD, MCT
Author: "Microsoft Reporting Services in Action"
Publisher website: http://www.manning.com/lachev
Buy it from Amazon.com: http://shrinkster.com/eq
Home page and blog: http://www.prologika.com/
---
"Larry Charlton" <LarryCharlton@.discussions.microsoft.com> wrote in message
news:8947D670-D575-4FD1-A724-9A7A0147DF29@.microsoft.com...
> What tools are available to manage which users are currently running what
> reports, parameters selected, load on server etc. Basically I'm trying to
> figure out how I determine if Reporting Services is slow, what report/user
is
> causing it, or if it's just a lot of people asking for reports and I need
to
> look at scaling the server.
> I'm interested in historical stuff, but I'm also interested in real time
> this is what's happening where with what components. For instance is
> retrieval slow or is it rendering that's slowing the report down, slamming
> the cpu etc.
> I see the DTS package for the logs and am installing that, but is there
> anything more immediate like current activity in SQL server?sql

Reporting Services Key Management

I have a situation where I need to delete the keys from my SRS install and have new ones created. I see from here: http://msdn2.microsoft.com/en-us/library/ms162822.aspx

that I can use a -s switch but I don't have that. I have this installed on SQL 2000.

Here are the options I have:

Microsoft (R) Reporting Services Key Manager
Version 8.00.1038.00 x86

Extracts from the report server and applies to the report server the key used during encryption.

RSKeyMgmt [-e] [-a] [-d] [-r installationID] [-f file] [-p password] [-t]

-e extract Extracts a key from a report server instance
-a apply Applies a key to a report server instance
-d deletecontent Deletes all encrypted content from a report server
database
-r installationID Remove the key for the specified installation ID
-f file Full path and file name to read/write key.
-p password Password used to encrypt or decrypt key.
-t trace Include trace information in error message

I don't see a way to get the new ones created, if I use rskeymgmt.exe I see ways to extract the existing and apply an extracted key but nothing about creating new keys.

Anyone know how to create new keys and apply them to an exising install?

Joe

I am not too familar with RS2000, so try this at your own risk :). You can use -d, and then -r to remove the installation from RS catalog, then restart the RS service. This should create a new key for you. However, you'll loose the encrypted content.