Welcome: Guest!

Sharepoint Forum

 
Home » Forum » Sharepoint       Ask a questionRSS Feeds

SQL Reporting Services missing from Central Admin

  Asked By: Ruchir Roy/ray         Date: Jan 16, 2007      Category: Sharepoint      Views: 2987
 

I installed SQL Reporting Services on the same server as my current
sharepoint server and I am having trouble. I created the database
reporting services datbase from the reporting configuration GUI and
made sure that the sharepoint integration checkbox was checked. I
clicked apply and the settings took. All of the service accounts used
have admin access to the box, farm admin to sharepoint, and dbo to the
databases. The sharepoint integration tab in the reporting services
configuration tool has a green check mark and when I click it the link
to sharepoint central admin is there. When I follow this and go to
central applications there is no Reporting Services area. I clicked
sites actions --> site settings --> site features. and the Reporting
Services Integration feature is NOT in the features list within central
admin. I have followed all of the microsoft recommendations for
configuration and searched high and low across blogs and google to find
an answer and have drawn a blank. Any suggestions?

Tagged:              

 

8 Answers Found

 
Answer #1       Answered By: Elisa Santos          Answered On: Jan 16, 2007       

I didn't see mention of you installing the add-in. This is required on all of
the front-end servers. Did this take place? As far as the RS settings  are
concerned, you will find them on the Operations tab  of the CA page once the
add-in has been installed.

 
Answer #2       Answered By: Judy Pittman          Answered On: Jan 16, 2007       

Yes the Addins were installed  and I double checked  to ensure that
they were there by looking under add remove programs. Everything
looks like it is running fine in the reporting  services configuration
tool. I just can't see them in the SP CA area. You mention that
they are in the Operations tab. Everything I have read and saw
points to the reporting services  section showing up on the right hand
side of the applications  tab.

 
Answer #3       Answered By: Arlene Hodge          Answered On: Jan 16, 2007       

Another stupid question: did you run an IISRESET on the front-end servers? I
don't remember if it requests a reboot or not.

 
Answer #4       Answered By: Jolene Sandoval          Answered On: Jan 16, 2007       

Yes, I reset IIS, I rebooted the server, I reinstalled reporting
services and the sharepoint  component, played with all the settings,
recreated the databases, drank a couple of beers, pulled some hair
out, and still no dice.

 
Answer #5       Answered By: Brandan Roach          Answered On: Jan 16, 2007       

Weird. My only suggestion would be to perform a re-install of the add-in. I've
heard that it can be spotty,

 
Answer #6       Answered By: Kai Carney          Answered On: Jan 16, 2007       

I have repaired and reinstalled the addin two times each. No dice
either.

 
Answer #7       Answered By: Gaurav Nemane          Answered On: Jan 16, 2007       

I also have looked in the web.config of the site  and the lines for
reporting services  are there.
<SafeControl
Assembly="Microsoft.ReportingServices.SharePoint.UI.ServerPages,
Version=9.0.242.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91"
Namespace="Microsoft.ReportingServices.SharePoint.UI" TypeName="*"
Safe="True" />
<SafeControl
Assembly="Microsoft.ReportingServices.SharePoint.UI.WebParts,
Version=9.0.242.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91"
Namespace="Microsoft.ReportingServices.SharePoint.UI.WebParts"
TypeName="*" Safe="True" />


I can also see the reporting  services viewer webpart in my site
collection. However, I still don't see anything inside of central
admin.

 
Answer #8       Answered By: Marjorie Humphrey          Answered On: Jan 16, 2007       

If I look under my site  collection features  in my default web
application the reporting  Server Integration feature  is there. If I
activate it the reporting services  tab shows up in the actual site
collection with one option, Managed Shared Schedules. If click  this
link then it returns an error that says: An unexpected error occurred
while connecting to the report server. Verify that the report server
is available and configured for sharepoint  integrated mode. I assume
this is becausee I have not configured the stuff inside of the
central admin.

 
Didn't find what you were looking for? Find more on SQL Reporting Services missing from Central Admin Or get search suggestion and latest updates.


Your Answer
  • Answer should be atleast 30 Characters.
  • Please put code inside [Code] your code [/Code].

 
Hall of Fame  |  Facebook  |  Twitter  |  LinkedIn  |  Terms of Use  |  Privacy Policy  |  Contact us
RSS Feeds: Articles |  Forum |  New Users |  Activities |  Interview FAQ |  Poll |  Hotlinks


Go4Sharepoint, is a Microsoft Featured Community. Microsoft, Windows, Sharepoint, Sharepoint logo, Windows logo, etc are trademarks of the Microsoft Corporation. All product names, logos, copyrights, and trademarks mentioned are acknowledged as the registered intellectual property of their respective owners. This site is not in any way affiliated with, nor has it been authorized, sponsored, or otherwise approved by, Microsoft Corporation.

Copyright © 2008-2011