[Webinar] Streamline your web hosting managementRegister Today

x
?
Solved

Missing Reporting Services Site Feature in WSS 3.0

Posted on 2010-03-30
4
Medium Priority
?
879 Views
Last Modified: 2012-06-27
Hi,

I had this working before my SAN blew up and had to rebuild it from scratch.      Basically  Ive got SQL 2008 x64 hosting Sharepoint 3.0.  and Reporting Services in Sharepoint Integrated mode.

After some pain.  Im am now able to upload reports to WSS and execute them.    However,   I dont seem to have the Reporting Services context menus, such as Manage Data sources, etc.   I think this is related to not having The Reporting services site feature in the list of site features.  

I do have the RS Sharepoint add-in installed.  but the site feature is not present and so i cant enable it and thus get the context menus working.  

Any ideas?   As I say, I thave has this working before but the server is now rebuilt.  

Oh I should mention that WSS is not my forte, Im a SQL DBA so forgive any ignorance of WSS terminoligy

Thanks
0
Comment
Question by:ShogunWade
  • 2
  • 2
4 Comments
 
LVL 41

Accepted Solution

by:
Kyle Abrahams earned 2000 total points
ID: 29086071
Run the SSRS configuration and repoint to your DB.  The manage data sources is a function of SSRS itself and not WSS.

Re-run the configuration and ensure the DB is upgraded.  (Or assuming it was a backup you should be fine).
0
 
LVL 18

Author Comment

by:ShogunWade
ID: 29089275
Thanks for the reply ged.    

Ive tried that but no joy.     Ive also tried running SSADM to install using the feature.xml of the addin  but that reports an error saying that feature.xml must be called feature.xml.   That error made me laugh :)
0
 
LVL 18

Author Comment

by:ShogunWade
ID: 29099168
ged325.   Im going to close the question as ive resolved it.   Im going to give you the points because you lead me in the right direction.

What I had to do was uninstall the add-in.    Then reset the Report Manager URL in reporting services config.  then reinstall the add-in.     If I reset the report manager URL alone reporting services didnt reflect the change.

Thanks.  
0
 
LVL 41

Expert Comment

by:Kyle Abrahams
ID: 29104860
Glad to be of help.  Yeah, sharepoint errors are frustrating at best.  They barely tell you what's going on.
0

Featured Post

Upgrade your Question Security!

Your question, your audience. Choose who sees your identity—and your question—with question security.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

A recent questions about how to add SSRS named instances, couldn't find any that talks about SQL server 2008, anyway I decided to help by creating some screen shots. The installation is straightforward, you just pop the SQL server 2008 installati…
Occasionally there is a need to clean table columns, especially if you have inherited legacy data. There are obviously many ways to accomplish that, including elaborate UPDATE queries with anywhere from one to numerous REPLACE functions (even within…
Hi, this video explains a free download that you can incorporate into your Access databases, or use stand-alone for contact management. Contacts -- Names, Addresses, Phone Numbers, eMail Addresses, Websites, Lists, Projects, Notes, Attachments…
Get the source code for a fully functional Access application shell with several popular security features that Access VBA application developers desire, but find difficult or impossible to figure out how to code. You get the source code for managi…

608 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question