Missing Reporting Services Site Feature in WSS 3.0


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

LVL 18
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Kyle AbrahamsSenior .Net DeveloperCommented:
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).

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
ShogunWadeAuthor Commented:
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 :)
ShogunWadeAuthor Commented:
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.

Kyle AbrahamsSenior .Net DeveloperCommented:
Glad to be of help.  Yeah, sharepoint errors are frustrating at best.  They barely tell you what's going on.
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Server Apps

From novice to tech pro — start learning today.