.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Register
 
Win Surprise Gifts!!!
Congratulations!!!


Post New Web Links

SSP not working after Reporting Service Add-in Removal

Posted By:      Posted Date: October 06, 2010    Points: 0   Category :SharePoint
 

I have a mess.  Back in August I installed the Reporting Services Add-in for SharePoint on my MOSS 2007 server.  I had some trouble getting it installed and never ended up getting it to work.  So I uninstalled it - which at the time looked like it uninstalled fine, however, I found out later that search wasn't working.  I tried resolving but decided I should probably do a restart.  After that none of the sites came up at all.  We performed a SharePoint Restore to a time before I installed the add-in (1 day earlier)  (We use Backup Exec.)  After that, the webs would come up but my SSP came up in an unprovisioning status.

At the time I didn't think it was any big deal, just Create a new SSP and reindex your content.  Well, the first SSP I tried to create, did create but when I try to configure anything on it I get an Access Denied Error.

I researched my Application Log, fixed issues in my Web.Config files where it was still looking for the Reporting Services Add-in.  (Not sure why Backup Exec Restore didn't fix this.) Restarted the Server.

Tried to create another SSP, got errors when I created it as well, tried to delete it - it is stuck in an "unprovisioning" state as well.  (I have no idea why the first one is "unprovisioning" other than it didn't like being restored.)<


View Complete Post


More Related Resource Links

Foundations: Working With The .NET Service Bus

  

The .NET Services Bus is arguably the most accessible, powerful, and useful piece of the new Windows Azure Cloud Computing initiative. See how it manages cloud communications.

Juval Lowy

MSDN Magazine April 2009


RDL Rendering (500 Internal Server) Error at Sharepoint Integrated Reporting Service

  

I have a serious problem that cannot be solved by googling around the keywords below:
sharepoint, moss 2007, reporting service, ssrs 2008, rendering, internal server error, ....

The error is;

"An error occurred during client rendering. The remote server returned an error: (500) Internal Server Error. "

Everything is O.K.;

* When I render the report from the REPORTSERVER (http://localhost/ReportServer)
* When the reports are scheduled to be sent by the reporting service (planned via MOSS 2007) 

But if I open (render) the RDL file from the sharepoint REPORTS LIBRARY interface, all of the reports fail with that internal error message above. 

It is weird also that parametrized reports are displayed without errors although the parameters are queried from a sql dataset. But I got the error when rendering the report after I've chosen a parameter  and order "apply/report"...

Possible causes how I met that error may be;

After I have installed (then uninstalled) AJAX extensions
After I have re-configured IIS Web Service Extensions list items

Possible solution alternatives I've found;

I've found a solution on MSDN replying a similar issue with an ideal cause of the error but an evreka answer but no sol

Is this same as SQL server Reporting Service or else what can we say for these type of report genera

  
Hi      In my windows application I am generating reports using this steps          1) Creates a stored procedure in the sql server for the required report output          2) In the .Net application add new Item adds a DataSet1.xsd binds the stored procedure to the DataSet1           3) Adds a Report1.rdlc to the application and places the requred fields in the Report1.rdlc          4) Adds a ReportViewer control to a form and binds the Report1.rdlc to the ReportViewer contol and shows the report Is this same as SQL server Reporting Service or else what can we say for these type of report generation 

SQL Reporting Service 2005 - share schedule report performace T-SQL query?

  
Hi, I have SQL 2005 reporting services Shared Schedules and each schedule has its own subscribed report. I would like to have T-SQL 2005 to find out performance loading on each schedule. i.e. MySchedule_1 has 10 reports in it and AVEGARE report eaxecutiontime is like 3mins 5sec      MySchedule_2 has 7 reports in it and AVEGARE report eaxecutiontime is like 4mins 9sec Pls can I have T-SQL 2005 on ReportServer database to find out load on each schedules (and more drill-down to each report level for execution time)?

Windows service can't use Reporting Services on SQL Service 2008 R2

  
Hello. I have a Windows service that run as Local System account. The service uses the Reporting Services ReportService2005.asmx web service. When I have SQL Server 2008 installed, I have no problems and my service is able to browse and create report. After I have installed SQL Server 2008 R2 I get the error "The request failed with HTTP status 401: Unauthorized." when the service tries to use the web service. If I change my service to log on as a user with administrator rights, it is able to use Reposting Services again. What has changes in SQL Server 2008 R2, that doesn't allow the Local System account to use Repoting Services? And is it possible to configure Reporting Services to allow it?   - Per

Problem Integration SQL Reporting Service 2005 and SharePoint 2007

  
Hello, I'm trying to make our SQL Reports available on our SharePoint report center. I have SQL 2005 (sp3) report server that resides on a different server than our SharePoint 2007 server. So in our SRS Configuration Tool, we changed the database mode for SharePoint integration (before, we only had it in native mode), so we created a new database for this SharePoint Integration type. Next, I installed the Report Server Add-in for SharePoint 2007 server and it was successful. However when configuring the Report Server, we got stuck at the step "Grant Database Access". For some reason we keep getting error message "Named instance not found" We already installed Service Pack 3 on the Report Server... I heard that the problem is because the mismatched version between the Report Server Add-in in SharePoint and the SQL RS version... but I don't think this is the case for us. Do we need to install WSS on our Report Server too?     Another question: We already integrate our Report Server with Microsoft Dynamics CRM 4.0. However I see that when the Report Server is in the SharePoint Integration mode, all the reports in CRM don't work (because Report Manager is no longer available in this mode). Do you think it would be the best practice to install a copy of Report Server instance in our SharePoint 2007 server? Thank you, greatly appreciate all your hel

Problem Integration SQL Reporting Service 2005 and SharePoint 2007

  
Hello, I'm trying to make our SQL Reports available on our SharePoint report center. I have SQL 2005 (sp3) report server that resides on a different server than our SharePoint 2007 server. So in our SRS Configuration Tool, we changed the database mode for SharePoint integration (before, we only had it in native mode), so we created a new database for this SharePoint Integration type. Next, I installed the Report Server Add-in for SharePoint 2007 server and it was successful. However when configuring the Report Server, we got stuck at the step "Grant Database Access". For some reason we keep getting error message "Named instance not found" We already installed Service Pack 3 on the Report Server... I heard that the problem is because the mismatched version between the Report Server Add-in in SharePoint and the SQL RS version... but I don't think this is the case for us. Do we need to install WSS on our Report Server too?     Another question: We already integrate our Report Server with Microsoft Dynamics CRM 4.0. However I see that when the Report Server is in the SharePoint Integration mode, all the reports in CRM don't work (because Report Manager is no longer available in this mode). Do you think it would be the best practice to install a copy of Report Server instance in our SharePoint 2007 server? Thank you, greatly appreciate all your hel

Reporting Service Model with db2 data source?

  
Sorry if this has been already asked.  I searched, but couldn't find it any previous posts. My question is can you have db2 as a datasource in Reporting Service Model?  Currently in the drop down I can only see SQL, which we have a few models over, and Oracle.  We are using SQL server 2008 r1. If not does Microsoft have any plans to add this in the future? Thanks for any help!

Parallel Groupings are not showing the data in Reporting Service 2008.

  
Hi All, My main goal is to show rows under two adjecent groups (say A another one is B) which have one parent group lat call it as AB (all are row sections) and i have one column group for "months".The details inside the group A under the "months" group is not showing any values or expressions it returing me blank. Adjacent groups in SSRS 2008 still shows blank lines for invisible rows (why?). Any ideas.Please let me know. Veeren.

How to use SharePoint 2007 list data in Reporting Service (Visual Studio) 2008?

  
Jeez - I have been googling left and right, and tried all the suggestions. No luck in getting it to work. I am using Reporting Service 2008 tools in my VS2008, trying to create a simple report using SharePoint 2007 data (from a simple list). Here is what I've been doing: Created a simple SharePoint list in a test site - only one column (Title) with one record of data. Started Visual Studio 2008 and created a new Report Server Project Wizard project. I named the data source "dsTest". Type: "XML". As connection string I used: http://site/subsite/subsite/_vti_bin/lists.asmx. Credentials: "Use Windows Authentication (Integrated Security)". Clicked Next and arrived at the "Design the Query" form. I entered this in the Query string box: <Query> <Method Namespace="http://schemas.microsoft.com/sharepoint/soap/" Name="GetListItems" /> <SoapAction>http://schemas.microsoft.com/sharepoint/soap/GetListItems</SoapAction> </Query> Clicking Next I get this error: An error occurred while the query design method was being saved. Failed to execute web request for the specified URL. Soap Fault: Exception of type 'Microsoft.SharePoint.SoapServer.SoapServerException' was thrown. Now if I view the Details when trying it inside the Query Builder I get this: <errorstring xmlns="http://schemas.mi

WSDL not working for SQL Reporting Services 2008

  
I have seutp reporting services successfully, but now i want to generate a proxy to be able to interact progromatically with the reporting services 2008 like I did in 2000 and 2005.  I have tried viewing the WSDL from a command like this:   http://localhost/reportserver/reportservice.asmx?WSDL and I get an error like this:   The path of the item 'WSDL' is not valid. The full path must be less than 260 characters long; other restrictions apply. If the report server is in native mode, the path must start with slash. (rsInvalidItemPath) Get Online Help Any thoughts?  I also tried from WSDL.exe, no dice. Thanksl Ben

T-SQL 2005 query for Group BY and not GROUP in same query for SQL reporting service use purpose?

  
Hi, I have SQL 2005 table like bellow @OrderTable I want to display all row data and GROUP BY data as well for SQL Reporting Service Matrix purpose...   declare @OrderTable TABLE (OrderID varchar(10),OrderType varchar(20),OrderValue decimal(10,2),OrderDate DateTime) INSERT INTO @OrderTable VALUES('P06','O1',25.22,'2010-01-24') INSERT INTO @OrderTable VALUES('P06','O2',105.48,'2010-06-12') INSERT INTO @OrderTable VALUES('P07','O3',555.00,'2010-06-09') INSERT INTO @OrderTable VALUES('P08','O1',10.22,'2010-06-12') INSERT INTO @OrderTable VALUES('P06','O1',55.66,'2010-03-17') INSERT INTO @OrderTable VALUES('P06','O1',45.44,'2010-03-17') INSERT INTO @OrderTable VALUES('P07','O3',477.81,'2010-03-18') INSERT INTO @OrderTable VALUES('P07','O3',78.85,'2010-03-18') INSERT INTO @OrderTable VALUES('P06','O1',78.08,'2010-04-09') INSERT INTO @OrderTable VALUES('P07','O2',899.90,'2010-04-22') INSERT INTO @OrderTable VALUES('P08','O3',25.33,'2010-01-24') INSERT INTO @OrderTable VALUES('P08','O3',859.01,'2010-01-24') INSERT INTO @OrderTable VALUES('P08','O3',7433.89,'2010-01-24') INSERT INTO @OrderTable VALUES('P08','O1',1005.41,'2010-06-12') INSERT INTO @OrderTable VALUES('P06','O2',455.20,'2010-06-09') INSERT INTO @OrderTable VALUES('P07','O3',85.30,'2010-06-12') INSERT INTO @OrderTable VALUES

WCF Service not working with ToolkitScriptManager

  
Back in the "old days" one would use the <asp:ScriptManager></asp:ScriptManager> and <asp:ServiceReferenc /> to allow for WCF Service integration into javascript on web forms.  Example: <asp:ScriptManager ID="ScriptManager1" runat="server">     <Services>         <asp:ServiceReference Path="~/Services/Service1.svc" />     </Services> </asp:ScriptManager> Now we are to use the <AjaxControlToolkit:ToolkitScriptManager></AjaxControlToolkit:ToolkitScriptManager> to accomplish the same task, but this doesn't seem to be working. Example: <AjaxControlToolkit:ToolkitScriptManager ID="ToolkitScriptManager1" runat="server">     <Services>        <asp:ServiceReference Path="~/Services/Service1.svc" />     </Services> </AjaxControlToolkit:ToolkitScriptManager> The former works. while the latter does not. Any suggestions? Visual Studio 2008 Professional .Net Framework 3.5 AJAX Toolkit 3.5.40412.0<asp:ScriptManager ID="ScriptManager1" runat="server">    <Services>        <asp:ServiceReference Path="~/Services/Service1.svc" />&nb

Sharepoint 2010 Search service removal and reinstall

  
In my attempt to recover from a database restore to a new server I was able to get most of the functionality to work with the data that was in my restore.  However Search service was not able to get connected and since it was a new install there should not have been much in the search database so it was not important enough to try and figure out the issue.  So, I stopped the Foundation search service with no problem and then tried to stop the search service and it gave me  the following message stating :   Removing the search service from a server must be done within the context of a search service application.  To temporarily reclaim resources used by the search service, Vist the Content Sources page and select "Pause all Crawls."  To unprovision the search service from this machine, modify the topology of each search service application and remove all components from this server.  Click OK to go to the Manage Service Applications page where you can select a Search Service Application to Configure.  deleted the service app and tried to reinstall the search service since this was a new install to begin with however I could never get the regular service to start correctly. However there was no search service installed in the services section.  It would not allow me to stop the service which is under the Ce

Custom webpart displaying Reports from Reporting service

  
Hi          I created a report in VS 2008 and deployed to reporting service. Then when I access this report through a custom webpart some of the cell borders are getting disappeared from inside the table control. Even the cell is not getting misaligned within the cell. But the same report when I retrieve through ReportViewer builtin webpart. Its displaying without any issues. How do I fix such issues?

Sharepoint Search and Secure Store Service not working

  
Hi There I am having issues with a few Sharepoint Services When I try to search for a document on any SharePoint site, I recieve an "Internal Server Error Exception". However when I checked the log files, I couldn't find any error messages matching with the given correlation ID. The search was working 2-3 weeks ago. Also 2 weeks ago, I started receiving warnings in the Health Analyzer saying “The Security token service is not available”. I am wondering if the security token service breaking down is related to the search issues, and if so what suggestions I could try to fix this issue. I am also unable to access the secure store service. In Central Administration->Application Management->Manage Service Applications, I try to click on the Secure Store Service, but there is no Proxy attached to the service, and I receive a message “No Secure Store Service Application Proxy ID was found”. When I check the Logfile, I receive these errors: 08/10/2010 11:11:32.94               w3wp.exe (0x18E4)                                      0x0ADC SharePoint Foundation     &nb

I need help for Reporting Service

  
I used Reporting Service 2005. I need draw line on last row of each page. Please help.
Categories: 
ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend