SharePoint Server 2007 Integration With Reporting Service 2005
Jan 18, 2007
Hi,
I am working on sharepoint 2007 integration with reporting service 2005. There are few facts which i am trying to understand and need some clarifications. Please provide your comments
1) While configuring "Database setup" in Repoting Service Configuring Manager" i found two modes 1) Native and 2) SharePoint Integration. When creating a report server database if we check "Create the report server database in Sharepoint Integration Mode" then it set the mode to "SharePoint Integration Mode". There is no option of switching the same database to native mode. So i have to create another database in "Native Mode". (IS THIS CORRECT. DO WE NEED TO CREATE TWO REPORT SERVER DATABASE SEPERATE FOR SHAREPOINT INTEGRATION AND NATIVE)
2) I am using the new report viewer web part in sharepoint 2007. When i am in sharepoint integration mode i can create datasource, report model and with report builder i can create rdl file. On selecing any RDL file in doument library and it gets displayed in Report Viewer Web Part. When i switch to Native mode i want to configure the web part to use the report created with SQL Server Bussiness Intelligence Dev Studio and deployed on http://localhost:808/ReportServer. (IS THERE ANY WAY SO THAT I CAN EXPORT AND IMPORT ALL .RDL FILE FROM http://localhost:808/ReportServer to http://localhost/ReportServer)
I AM NOT ABLE TO CONFIGURE WEB PART WHEN I AM IN NATIVE MODE i.e giving path of .RDL in report textbox throw a error saying "Item not found" i tried all combination. THIS can be related to datasource not reading in .RDL file in native mode while confuring report viewer web part.
http://localhost:808/ReportServer (Report Server)
http://localhost/ReportServer (SharePoint Mode) (Default Top Level Site)
3) LAST : I want to create a .RDL file report from the data in sharepoint, say lists or news etc. So when creating a RDL file how can i connect to sharepoint database. I read some where that in previous release they used to DATA EXTENSIONS and get the data from list in sharepoint with something like http://<servername>/<sitename>/List=Announcement when creating RDL file. Is the alternative in new release to create the report based on sharpoint list data.
I have been banging my head against the wall with trying to integrate SharePoint 2007 and SQL Reporting Services. I have been following these 2 websites down to the letter in trying to configure everything:
2. http://blogs.msdn.com/sharepoint/archive/2007/02/19/microsoft-sql-server-2005-sp2-reporting-services-integration-with- wss-3-0-and-moss-2007.aspx <---SharePoint Blog Group
Basically my setup is as follows:
Server 1 = SharePoint 2007
Server 2 = SQL Server Reporting Services SP2 / SharePoint 2007 services
Server 3 = Database
Server1 is setup and running SharePoint 2007 fine with no problems. It was installed under the complete option with its own server farm. Then with the Server2, SharePoint 2007 is installed again, also under the complete complete option, and configured to join Server1's server farm. In this way, Server2 is able to supply Server1 with services and it has been said that if you are using 2 different servers, one for SharePoint and one for Reporting Services, you need to have an instance of SharePoint on the reporting services box. With a SharePoint "front-end" the reporting-services now has a way to also join Server1s farm.
This is where the headache begins....the SharePoint install is successful on Server2 and the services are started as evident through the Central Administration page. The next task is to install SQL Server 2005 Reporting Services and then the SQL Server 2005 SP2 patch.
After installing SQL Server and the SP2 patch, you go into the SQL Reporting Services Configuration Manager and setup the Report Server, Database, and SharePoint integration. I configure everything to run under the "DefaultAppPool" under IIS, and I get green accepted checkboxes on everything.
Finally, the last step is to install Microsoft SQL Server 2005 Reporting Services Add-in for Microsoft SharePoint Technologies on Server1. This add-in actually allows the connection between SharePoint on Server1 to the Reporting Services on Server2. The install is successful and the extra options for reporting pop up under Central Administration page. When configuring the final connection under the Central Admin I referred to the following Microsoft Page:
For the "manage integration settings", I set the report server to Server2 and use Windows Authentication. Then for the "grant database access" I use Server2 and login with my credentials...
PROBLEM: Then for the final step of setting the server defaults, I click on the link and get the following error:
"An unexpected error occurred while connecting to the report server. Verify that the report server is available and configured for SharePoint integrated mode. "
I have googled and tried installing/uninstalling several times, but it seems that I keep getting hung up here. When trying to access reports on the ReportServer, the same error message comes up.
If anyone is familiar with integration between SharePoint and SQL Reporting Services, and may have any ideas/comments/advice, I would greatly appreciate it. Thanks in advance! =)
I've been running around in circles all afternoon trying to create one simple report using Reporting Services (with latest SP2 installed) and SharePoint 2007. To the best of my knowledge, I have everything configured correctly:
When I access http://<server>/ReportServer, I see the server name of my SharePoint site. When I click on the name of my SharePoint site, it shows me the directory structure I have created within my SharePoint Site When I drill down in the directory, I can ultimately see the forms I created in my forms library (created via InfoPath 2007).
The next step is to create one simple report from the data in one of these forms libraries and a report on all the items within a form library. I'm stuck at the first step of creating a report, namely what to enter as the Data Source and the connection string. With a SQL database this isn't an issue.
How does one create a data source that will allow reporting over SharePoint content with the setup described above? And, if you have information that is found in the SQL Books Online, please be kind and post links so others know where to find this information.
hello good afternoon, I am having this issue, I need to move reporting services from one server to another, but I need that credentials, roles and reports stay the same. But as the reporting services is integrated with sharepoint, dont know if I can move both at the same or it has to be done one at a time. this is just data migration, but still I will like to Know how it can be done having the same structure with the roles and credentials. or it is prefered to do a ghost?? but the issue will be that we have the reporting services in one place and the data in another... don´t know how this will affect. thanks in advanced for the help.
I have just installed RS and SP2 on a server running a MOSS 2007 (with SSL using an internal certificate) and configured RS to work on Sharepoint Integrated Mode. Then I went to Sharepoint to configure RS options, but when I tried to set up the Set Servers Defaults I receive the following error:
An unexpected error occurred while connecting to the report server. Verify that the report server is available and configured for SharePoint integrated mode. --> Server was unable to process request. ---> The underlying connection was closed: Could not establish trust relationship for the SSL/TLS secure channel. ---> The remote certificate is invalid according to the validation procedure.
Also, when I try to deploy a report from SQL BI Development Studio to Sharepoint, I receive the error:
A connection could not be made to the report server https://myserver.mycompany.com.br/Reports/Site. (Microsoft Report Designer)
Server was unable to process request. ---> The underlying connection was closed: Could not establish trust relationship for the SSL/TLS secure channel. ---> The remote certificate is invalid according to the validation procedure. (System.Web.Services)
I get the following error when I try to navigate to a report/model/data source, stored in a Sharepoint Document Library using a Sharepoint URL based on an Extranet or Intranet zone - but it works OK using the url for the Default zone:
System.Web.Services.Protocols.SoapException: The specified path refers to a SharePoint zone that is not supported. The default zone path must be used. ---> Microsoft.ReportingServices.Diagnostics.Utilities.SecurityZoneNotSupportedException: The specified path refers to a SharePoint zone that is not supported. The default zone path must be used.
Is this a limitation of the SQLRS-WSS3 integration or is there a workaround?
I'm trying to install SharePoint 2007 and Reporting Services 2005 on the same server. However after installation Reporting Services will not load at http://localhost/Reports. Instead I get the following error:
Server Error in '/Reports' Application. Configuration Error
Description: An error occurred during the processing of a configuration file required to service this request. Please review the specific error details below and modify your configuration file appropriately.
Parser Error Message: Cannot use 'partitionResolver' unless the mode is 'StateServer' or 'SQLServer'.
Source Error:
Line 164: </webParts> Line 165: <machineKey validationKey="DA65D9E6980E9CDB52426BF3C793EBAF7FBA3B866117F3CC" decryptionKey="9D7E984E12AA43FDECAB1E05D1E952822680D27BD1F37439" validation="SHA1" /> Line 166: <sessionState mode="SQLServer" timeout="60" allowCustomSqlDatabase="true" partitionResolverType="Microsoft.Office.Server.Administration.SqlSessionStateResolver, Microsoft.Office.Server, Version=12.0.0.0, Culture=neutral, PublicKeyToken=71e9bce111e9429c" /> Line 167: </system.web> Line 168: <runtime> Source File: C:InetpubwwwrootwssVirtualDirectoriesc76013d9-5b44-4d06-96dd-24fede1ea955web.config Line: 166
Version Information: Microsoft .NET Framework Version:2.0.50727.42; ASP.NET Version:2.0.50727.42
I assume that something is wrong with my virtual server set up. I have the Default Web Site stopped and SharePoint (80) running and set Reports and ReportServer using the Report Configuration to SharePoint (80).
I can get to http://localhost/ReportServer but I get this error when running a report from there: Reporting Services Error
An internal error occurred on the report server. See the error log for more details. (rsInternalError) Get Online Help
The type Microsoft.SharePoint.Portal.Analytics.UI.ReportViewerMessages, Microsoft.SharePoint.Portal, Version=12.0.0.0, Culture=neutral, PublicKeyToken=71e9bce111e9429c does not implement IReportViewerMessages or could not be found
Has anyone set these up on the same server? Is there a document around on how to set this up?
Since I wasn't getting any replies with answers or suggestions to my initial posting, I figured I would continue to list the problems and solutions I've encountered while trying to setup and utilize SharePoint integration mode, and read data from SharePoint with SSRS reports (developed in VS2005). Hopefully this is helpful to anyone that is also trying to learn all this stuff and figure it out.
(Single server - W2K3R2_SP2 as: DC / SQL2005 Standard / MOSS2007 Enterprise - see the bottom of this posting for the steps I took to set that up)
Note: After I get this to work, I intend to post my experiences for setting up SharePoint Integration with SQL and SP on separate boxes.
1. In the new reporting section under SharePoint application management in the Central Admin Console, the Grant database AND Set Server Defaults work when using the domain admin account, but not when using the SQLSPS service account I used to setup both SQL and SharePoint. Why can't I use the service account? Is the domain admin account now going to be used as a service account for accessing the sharepoint database?
This question remains unanswered as of yet.
2. Reporting Services configuration tool shows Sharepoint integration as red x when I create a new database in integration mode. (the service account SQLSPS and the Server object are members of the group WSS_WPG). If I switch back to native mode (the original reportserver database), the red x goes to a blue exclamation instead. Using Service Credentials or Windows credentials (as either the service account SQLSPS or as domain admin) doesn't change anything.
RESOLVED by using a domain user account for the ReportServer WebApp. Even though everything is installed on the same machine, it seems using the default of NETWORK SERVICE wasn't acceptable. Possibly because SharePoint is configured to allow additional machines in the farm?
3. http://servername:8080/reportserver will display Report Server information as it did before the integration on port 80, but http://servername/reportserver doesn't display anything through SharePoint.
Resolved. I needed to define a repository before I could view it (go figure). When I created a sharepoint site based on a report center template, created a data connection library and report library, and then referenced that by http://servername/sites/myReportCenterSite/myReportLibrary, I was able to see the equivalent of http://servername/reports (which is now disabled due to integration mode).
4. Unable to deploy to new report center sharepoint site I mention above using Visual Studio. I kept getting "A connection could not be made to the report server http://servername/sites/ReportCenter. Server was unable to process request. The request failed with HTTP status 503: Service unavailable (System.Web.Services). In Visual Studio, the project properties were: TargetDataSourceFolder = http://servername/sites/myReportCenterSite/myDataConnectionLibrary, TargetReportFolder = http://servername/sites/myReportCenterSite/myReportLibrary, TargetServerURL = http://servername/sites/myReportCenterSite/
Found these errors in the event logs on the server.
Event Type: Warning Event Source: W3SVC Event ID: 1021 Description: The identity of application pool, 'ReportServer' is invalid. If it remains invalid when the first request for the application pool is processed, the application pool will be disabled. The data field contains the error number.
Event Type: Warning Event Source: W3SVC Event ID: 1057 Description: The identity of application pool 'ReportServer' is invalid, so the World Wide Web Publishing Service can not create a worker process to serve the application pool. Therefore, the application pool has been disabled.
Event Type: Error Event Source: W3SVC Event ID: 1059 Description: A failure was encountered while launching the process serving application pool 'ReportServer'. The application pool has been disabled.
RESOLVED the issue by changing the Application Pool used by reporting services from ReportServer to DefaultAppPool and changing the account DefaultAppPool used from NETWORK SERVICE to my service account SQLSPS. I have no idea why ReportServer is invalid, it was set to use the service account SQLSPS the same as DefaultAppPool is. Perhaps the reporting services add-on makes a change to invalidate this?
5. Attempting to read a SharePoint list using a SSRS report. This should be fun.
First, created a new custom list in the ReportCenter SharePoint sites I've been using and called it myCustomList. I added one item with a title of myCustomListItem1. I don't know if I need to do more than that for a simple test of reporting or not yet.
Second, configured new shared data source. Name = myCustomList1DataSource, type=XML, Connection String = http://servername/_vti_bin/lists.asmx (this URL is viewable in IE), Using Windows authenticaion.
Third, in VS2005 on a workstation in the domain, create new report item (report1.rdl). New dataset for report; Name=Report1DataSet, Data Source=myCustomList1DataSource (Shared), Command type = text, Query String = [See Queries and associated errors below]:
Initial query obtained from: Connecting SQL Reporting Services to a SharePoint List (David Wise) http://www.sharepointblogs.com/dwise/archive/2007/11/28/connecting-sql-reporting-services-to-a-sharepoint-list-redux.aspx
Note: Queries when executing the dataset (which errors out) and when executing a query in CAML Viewer for the same information (which does work just fine) both initially return 401.1 and 401.2 errors (as viewed in Fiddler). Since the CAML query works, I have not tracked this down yet.
Parameter; Name => listName, Value => =myCustomList
Was NOT prompted to define the query parameters
- Gets this error: "An error occurred while setting the command text property of the data extension command. The XmlDP query is invalid. (Microsoft.ReportingServices.DataExtensions)."
- Advanced information from the error => 'http' is an unexpected token. The expected token is '"' or '''. Line 2, position 19. (System.Xml)
B. Changed: Placed the namespace URL in quotes (also tried with and without / in namespace after /soap)
Parameter; Name => listName, Value => =myCustomList (also tried Value => myCustomList) (no equal sign)
Clicked "!" to execute, and got prompted to define the query parameters Entered Name => listName, Value => myCustomList
- Gets this error: "failed to execute web request for the specified URL (Microsoft.ReportingServices.DataExtensions)."
- Advanced information: <faultstring>Server did not recognize the value of HTTP Header SOAPAction: http://schemas.microsoft.com/sharepoint/soap/GetListItems/.</faultstring>
C. Try the query string that seems to work for Stramit CAML Viewer to read myCustomList
Also tried <Query xmlns="http://schemas.microsoft.com/sharepoint/soap/"> </Query>
And tried entering no query...
Parameter; Name => listName, Value => =myCustomList (also tried Value => myCustomList) (no equal sign)
Clicked "!" to execute, and got prompted to define the query parameters Entered Name => listName, Value => myCustomList
- Gets this error: "failed to execute web request for the specified URL (Microsoft.ReportingServices.DataExtensions)."
- Advanced information: <soap:Fault><soap:Code><soap:Value>soap:Receiver</soap:Value></soap:Code><soap:Reason><soap:Text xml:lang="en">Server was unable to process request. ---> Data at the root level is invalid. Line 1, position 1.</soap:Text></soap:Reason><soap: Detail /></soap:Fault>
RESOLVED. Went back to the query used in B above, and mysteriously it works now. This could be the "funny things happen" symptom I've been reading about. We'll see if it continues to function.
Here's what I've learned so far on Issue #5:
1. XML is confusing. XmlDP is even more confusing...whatever that is. Apparently it's new to/with Reporting Services in SharePoint integration mode? 2. There is far too little documentation regarding XmlDP and querying SharePoint lists from SQL Reporting Services. 3. According to http://msdn2.microsoft.com/en-us/library/ms159741.aspx: You must use the generic query designer to create the query. The query is not analyzed to identify parameters; therefore you must create parameters through the Parameter tab on the Dataset dialog box.
Tried this query:
<Query> <SoapAction>http://schemas.microsoft.com/sharepoint/soap/GetListItems</SoapAction> <Method Namespace="http://schemas.microsoft.com/sharepoint/soap/" Name="GetListItems" /> <Parameters> <Parameter Name="listName"> <DefaultValue>myCustomReport2</DefaultValue> </Parameter> <OrderBy> <FieldRef name="ows_Date" /> </OrderBy> </Parameters> </Query> I was still prompted for the listName and the list returned with ows_Date still out of order. So maybe that proves this statement is true? <translation: why make it convenient when it's already [somewhat] functional?> 4. When building the dataset, anything I place in the "Query string" box has to be enclosed in <query></query> tags or it errors out. I am trying to understand how to translate the CAML viewer query (which does work but isn't wrapped in query tags) into something that fits between query tags, and it hasn't gone well so far. <translation: To be at one with your reports Grasshopper, you must understand xml> 5. According to http://srv1/sites/ReportCenter/_vti_bin/lists.asmx, "GetListItems" operation is supported <translation: you're getting warmer...> 6. According to the soap output of my site http://srv1/sites/ReportCenter/_vti_bin/lists.asmx?op=GetListItems, I am only allowed to specify the following parameters: listName, viewName, query, viewFields, rowLimit, queryOptions and webID. <translation: that and $3.00 will get you a cup of coffee> 7. According to http://www.sharepointblogs.com/dwise/archive/2007/11/28/connecting-sql-reporting-services-to-a-sharepoint-list-redux.aspx, only listName, viewName and rowLimit parameters are usable(?) (query and queryOptions may not be working properly with SSRS). <translation: that kind of sucks> 8. When this started mysteriously working again, I tested using the "/" at the end of the namespace (wouldn't work without) and the "=" sign in front of the parameter value as defined on the parameter tab of the dataset (turns out to be optional).
As long as I can query SharePoint and get my list information back, I'm going to consider this issue closed and move on to actually using this information in a report. I'm sure that won't work right either, but why stop now?!
6. Ok, now that I can read SharePoint list data with SSRS, I need to try and actually do something with it.
A. Begin by setting up new data to report on
1. Create a new custom list (myCustomList2) and add a test record. This list will simulate the data we intend to submit to SharePoint using InfoPath, so it has a number of custom/created columns in it
2. Modify the working information from #5 above; add a new shared data source (myCustomList2DataSource), tell the dataset to use the new shared data source, change the information set in the parameter tab (Name => listName, Value => =myCustomList2) and test the dataset. Lucky me, it actually returned the record I entered on the first try.
B. Begin to build the report with the dataset returned
1. So, as I'm feeling good that it's actually reading the list in Step A without me threatening to destroy the machine, I look to the left in the Dataset results navigation pane in VS2005 and realize there are NO fields for me to choose to report on. 2. At this point, I have no clue what to do about getting this XML data into a report. Not that I have a large clue about SSRS otherwise, but I have at least been able to build SSRS reports when using a SQL database as the datasource. Fyi, http://msdn2.microsoft.com/en-us/library/ms159741.aspx states: "Reports can use data from XML documents and Web services, or embed XML in the query. There is no built-in support for retrieving XML documents from a SQL Server database.", in case anyone is trying to do that....
RESOLVED. Since the fields were not appearing automatically, I had started to add new fields to the dataset manually (if it doesn't work, beat it with a hammer, right?). I entered half a dozen or so fields, each one with the exact name as displayed in the query results, and then decided it would be fun to hit the refresh fields icon. As soon as I did that, all the fields shown in the query immediately appeared in the dataset and I was able to add them to a report. I don't know if I hit the refresh fields when working in issue #5, so I can't say if they are there now because of that, or because of adding some fields manually first, a combination of the two, or if it's just one of those mystery items I'm reading about with sharepoint reporting.
7. Rows are being returned even though they have NULL values (so far anyway), and most data is returning nicely for the bulk of the columns I created in the list I'm reporting on. Here are the current issues:
A. I have one column in my SharePoint list that is multi-lined text. If the text type is either rich text or enhanced rich text, the value returned in the query is formatted like this: "<div class=ExternalClassyadayada<div>My notes display here". If I set the column to be plain text, this doesn't happen. I will need to figure out how to filter that for my report.
RESOLVED. David Wise had some code listed at http://www.sharepointblogs.com/dwise/archive/2007/11/28/connecting-sql-reporting-services-to-a-sharepoint-list-redux.aspx that addressed this issue somewhat. I modified it to match my circumstances. Disclaimer: I'm not a programmer, so use this at your own risk.
function ExtractMultiLineText(myField as string) as string dim strBegin as string dim strEnd as string dim myBegin as integer dim myEnd as integer dim myTextLength as integer strBegin = "<div>" strEnd = "</div>" if myField = nothing then return "" if myField = "" then return "" myBegin = Instr(myField, strBegin) + Len(strBegin) myEnd = Instr(myField, strEnd) myTextLength = myEnd - myBegin
if myBegin < 1 then return myField return mid(myField, myBegin, myTextLength) end function
B. I have two columns in the SharePoint list that are set as number values with 0 decimal places. When I query those however in SSRS, they return with the number plus like 12 zeroes behind the decimal. Not a major issue, but I'll put it on the list anyway.
RESOLVED. Used the Int() function; =Int(Fields!ows_myProblemNumber)
C. If I go to "/_vti_bin/lists.asmx?op=GetListItems", it appears from the sample soap output that I am allowed to ask GetListItems for is: listName, viewName, query, viewFields, rowLimit, queryOptions and webID. As I mentioned in issue #5, according to http://www.sharepointblogs.com/dwise/archive/2007/11/28/connecting-sql-reporting-services-to-a-sharepoint-list-redux.aspx, only listName, viewName and rowLimit parameters are usable(?) and query and queryOptions may not be working properly with SSRS.
So, if I can't put anything other than this in my query string;
<Query> <Method Namespace="http://schemas.microsoft.com/sharepoint/soap/" Name="GetListItems"/> <SoapAction>http://schemas.microsoft.com/sharepoint/soap/GetListItems</SoapAction> </Query> and I only have a couple parameters to pass on top of that, then it appears to me that my options for filtering the amount of data returned from the SharePoint list is to figure out a way to do it with expressions in the parameters or in the report itself. Am I missing something? Is this really all I get to work with out-of-the-box?
More to come...
================================== Installation steps taken to build the server VM: ==================================
(Using VirtualPC 2007) 1. Build OS (2003R2SP2) and promote to DC
1a. Create domain user service account SQLSPS 2. Prep for SQL
3a. Verify SSRS works 3b. RS config tool shows SP integration as blue exclamation 3c. Use service account SQLSPS for anything requiring Windows credentials 4. Install SQL2005 SP2
4a. Verify SSRS works 4b. RS config tool shows SP integration as blue exclamation 5. Prep for SharePoint
5a. Install .NET 3.0 6. Install MOSS2007 Enterprise and configure
6a. Webapps, SSP and anything else use svc acct SQLSPS 6b. Move Default website to port 8080 and re-activate (SharePoint stopped the site) 6c. Verify SSRS works on 8080 7. Install Reporting Services Add-in 8. Create new RS database in integration mode (with service credentials)
8a. RS config tool shows SP integration as red x 9. SP central admin /application management / manage integration settings
9a. reports server = http://srv1:8080/reportserver (since default port has been moved to 8080) 10. SP central admin /application management/grant database access
10a. using the FQDN, confirm servername and default instance - click OK 10b. Prompted for an account to use to retrieve information; svc acct SQLSPS did not work, domain admin did though 11. SP central admin / application management/set server defaults
11a. Accepted all defaults 12. Verify reportserver answers at http://srv1:8080/reportserver (via reportserver AppPool and DefaultAppPool) 13. Changed the application pool identity for the ReportServer AppPool from Network Service to the domain user service account I used for all SQL and SharePoint configurations (SQLSPS) and rebooted. The red x for sharepoint integration in the RS configuration tool is now a green checkmark.
I have an intranet environment consists of two servers:
- An application server windows 2003 server with 64-bit server Sharepoint 2007 SP1 (Standard version for search) - A database server windows 2003 server with 64-bit SQL Server 2005 SP2 64-bit (Standard - 9.0.3054)
It happens regularly that the database server crash (frozen black screen) while the application server indexes (crawl) the content of the intranet site based on sharepoint. There is no alert / error in the observer of events, nor in the sql logs.
The crash is uncertain: dice once all goes well, soon after that crash. When i set the parameter search service (service management research), I can define a regulatory impact of the robot to change the number of documents at the same time : "Request 2 documents at the same time, the crash is more rare, "ask 64 documents at a time, the crash is more common.
My Intranet under sharepoint is composed of a collection site with a dozen sub-sites. There are 3 large library of PDF document. All done in the 4 go in terms of volume.
My problem for about 3-4 months. (Maybe more. Before, indexing was not yet in place).
Hi all! I'm VERY new to MOSS2007 and I have couple of questions about it and SQL Server 2005. The basic idea is to receive data from MOSS2007 into SQL Server 2005 in my own database and make some reports from there.
Which are the best practices to receive data from MOSS2007 into SQL Server 2005? Do I have to write some dlls for example with VB.NET (and use Sharepoint API calls) and use those dlls in stored procedures in SQL Server 2005? Or can I just use normal T-SQL (I believe that data in MOSS2007 is saved in lists and lists are saved in DB)?
Waiting for your replies. The more detail your answer is the more grateful I am!
Hi all (and sorry for crossposting)! I'm VERY new to MOSS2007 and I have couple of questions about it and SQL Server 2005. The basic idea is to receive data from MOSS2007 into SQL Server 2005 in my own database and make some reports from there.
Which are the best practices to receive data from MOSS2007 into SQL Server 2005? Do I have to write some dlls for example with VB.NET (and use Sharepoint API calls) and use those dlls in stored procedures in SQL Server 2005? Or can I just use normal T-SQL (I believe that data in MOSS2007 is saved in lists and lists are saved in DB)?
Waiting for your replies. The more detail your answer is the more grateful I am!
Hi, I have just install SQL 2005 SP2 and trying to get Window SharePoint Services V3 integrated with SQL 2005 SP2 reporting services. In SharePoint Central Administration, I select the Reporting Services Integration page and have setup the Report Server Web Service URL and Authentication Mode. I then goto Grant database access, specify the SQL server name, get promted for a username and password that has access SQL Reportserver and get the following error "The group name could not be found" Does anyone have any ideas? Thanks
I have some problem about reporting service add-in.
After I install reporting service add-in for SharePoint, reporting service menu does not appear in Application Management Tab in SharePoint Central Administration.
I try to uninstall and re-install again, it remain not work.
I configured Reporting Services in SharePoint Integrated Mode at a client and am running into an issue as described in this article: http://support.microsoft.com/default.aspx/kb/942530. I got the Cumulative Patch 4 (and 5) for SQL Server 2005 SP2 from Microsoft and applied it to the Reporting Services box. However, I€™m still seeing the same issue. Has anyone else run into this issue and resolved it?
I am trying to do some integration between reporting services and sharepoint. I have some instructions that tell me to click on "Site Collection Features" under site settings. I go ahead and click site settings and find no "Site Collection features" link. How do I get this link to appear?
I have a problem for integrating sharepoint to reporting service. In my project web access page, when I tried to open a .rdl report, the following error occured:
An unexpected error occurred while connecting to the report server. Verify that the report server is available and configured for SharePoint integrated mode--> Server was unable to process request
Then when I go to the reporting service configuration manager. I saw that in the Server Status tab, the "Initialize" field is "No". And for the Sharepoint Integration tab, there was a blue "!" mark on it.
I read from the web (http://www.helloitsliam.com/archive/2007/10/23/moss2007-€“-reporting-services-add-in-and-configuration.aspx) that if the database setup is ok, then the sharepoint integration will also be ok and the report manager virtual directory will turn gray. However, there is an error when setting up the database. In the task status, "Verifying Database Edition", "Verifying Database Version", "Creating a Grant Rights script for xxxxxxxxxx" and "Assigning Reporting Services Rights to User" were all marked as a green tick. However, there is a yellow "!" for "Setting Connection Info for Reporting Service" and the detailed error is as follows:
ReportServicesConfigUI.WMIProvider.WMIProviderException: The encrypted value for the "LogonCred" configuration setting cannot be decrypted. (rsFailedToDecryptConfigInformation) at ReportServicesConfigUI.WMIProvider.RSReportServerAdmin.ThrowOnError(ManagementBaseObject mo) at ReportServicesConfigUI.WMIProvider.RSReportServerAdmin.ListReportServersInDatabase(RSReportServerInfo[]& serverInfos)
Does anyone know how to solve it? Thanks in advance!!
I have an installation of Reporting Services with Sharepoint integration. Most of my reports are Analysis Services reports with MDX queries. These reports are typically with 9-10 parameters.
When I try to pull these query these reports in the sharepoint site, it takes typically 3-5 minutes before the report is rendered. If these reports are queried from BIDS itself, it takes only a couple of seconds. To make things worse, every change of parameters causes the report to re-render and the entire load time has to report itself again, which is unacceptable by any standard.
I suspect this has something to do with the report viewer render time, does anyone have similar experience or is able to advise on how this can be fixed?
Hi there, I have a stupid question When I want to configure reporting service in a computer it needs Windows SharePoint Service. But When I installed and configured it in my own PC it asked for database server location instead. Anybody have any idea about this?
I have setup the Sharepoint 2007 Reporting Services add-in and am running into an issue. I was able to get a report to show up in a report viewer webpart once, but after that, I receive a message similiar to the following (for all reports);
'Execution 'ex2ubmetmr13vdffxciursfg' cannot be found '
Any help would be appreicated. I'm including my log file for the error as well as it should be helpful.
<Header> <Product>Microsoft SQL Server Reporting Services Version 9.00.3042.00</Product> <Locale>en-US</Locale> <TimeZone>Mountain Daylight Time</TimeZone> <Path>c:Program FilesMicrosoft SQL ServerMSSQL.2Reporting ServicesLogFilesReportServer__08_06_2007_12_33_12.log</Path> <SystemName>DEV-AD-V2</SystemName> <OSName>Microsoft Windows NT 5.2.3790 Service Pack 1</OSName> <OSVersion>5.2.3790.65536</OSVersion> </Header> w3wp!webserver!6!8/6/2007-12:33:14:: i INFO: Reporting Web Server started w3wp!library!6!8/6/2007-12:33:14:: i INFO: Initializing ConnectionType to '1' as specified in Configuration file. w3wp!library!6!8/6/2007-12:33:14:: i INFO: Initializing IsSchedulingService to 'True' as specified in Configuration file. w3wp!library!6!8/6/2007-12:33:14:: i INFO: Initializing IsNotificationService to 'True' as specified in Configuration file. w3wp!library!6!8/6/2007-12:33:14:: i INFO: Initializing IsEventService to 'True' as specified in Configuration file. w3wp!library!6!8/6/2007-12:33:14:: i INFO: Initializing PollingInterval to '10' second(s) as specified in Configuration file. w3wp!library!6!8/6/2007-12:33:14:: i INFO: Initializing WindowsServiceUseFileShareStorage to 'False' as specified in Configuration file. w3wp!library!6!8/6/2007-12:33:14:: i INFO: Initializing MemoryLimit to '60' percent as specified in Configuration file. w3wp!library!6!8/6/2007-12:33:14:: i INFO: Initializing RecycleTime to '720' minute(s) as specified in Configuration file. w3wp!library!6!8/6/2007-12:33:14:: i INFO: Initializing MaximumMemoryLimit to '80' percent as specified in Configuration file. w3wp!library!6!8/6/2007-12:33:14:: i INFO: Initializing MaxAppDomainUnloadTime to '30' minute(s) as specified in Configuration file. w3wp!library!6!8/6/2007-12:33:14:: i INFO: Initializing MaxQueueThreads to '0' thread(s) as specified in Configuration file. w3wp!library!6!8/6/2007-12:33:14:: i INFO: Initializing IsWebServiceEnabled to 'True' as specified in Configuration file. w3wp!library!6!8/6/2007-12:33:14:: i INFO: Initializing MaxActiveReqForOneUser to '20' requests(s) as specified in Configuration file. w3wp!library!6!8/6/2007-12:33:14:: i INFO: Initializing MaxScheduleWait to '5' second(s) as specified in Configuration file. w3wp!library!6!8/6/2007-12:33:14:: i INFO: Initializing DatabaseQueryTimeout to '120' second(s) as specified in Configuration file. w3wp!library!6!8/6/2007-12:33:14:: i INFO: Initializing ProcessRecycleOptions to '0' as specified in Configuration file. w3wp!library!6!8/6/2007-12:33:14:: i INFO: Initializing RunningRequestsScavengerCycle to '60' second(s) as specified in Configuration file. w3wp!library!6!8/6/2007-12:33:14:: i INFO: Initializing RunningRequestsDbCycle to '60' second(s) as specified in Configuration file. w3wp!library!6!8/6/2007-12:33:14:: i INFO: Initializing RunningRequestsAge to '30' second(s) as specified in Configuration file. w3wp!library!6!8/6/2007-12:33:14:: i INFO: Initializing CleanupCycleMinutes to '10' minute(s) as specified in Configuration file. w3wp!library!6!8/6/2007-12:33:14:: i INFO: Initializing DailyCleanupMinuteOfDay to default value of '120' minutes since midnight because it was not specified in Configuration file. w3wp!library!6!8/6/2007-12:33:14:: i INFO: Initializing WatsonFlags to '1064' as specified in Configuration file. w3wp!library!6!8/6/2007-12:33:14:: i INFO: Initializing WatsonDumpOnExceptions to 'Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException,Microsoft.ReportingServices.Modeling.InternalModelingException' as specified in Configuration file. w3wp!library!6!8/6/2007-12:33:14:: i INFO: Initializing WatsonDumpExcludeIfContainsExceptions to 'System.Data.SqlClient.SqlException,System.Threading.ThreadAbortException' as specified in Configuration file. w3wp!library!6!8/6/2007-12:33:14:: i INFO: Initializing SecureConnectionLevel to '0' as specified in Configuration file. w3wp!library!6!8/6/2007-12:33:14:: i INFO: Initializing DisplayErrorLink to 'True' as specified in Configuration file. w3wp!library!6!8/6/2007-12:33:14:: i INFO: Initializing WebServiceUseFileShareStorage to 'False' as specified in Configuration file. w3wp!resourceutilities!6!8/6/2007-12:33:15:: i INFO: Reporting Services starting SKU: Enterprise w3wp!resourceutilities!6!8/6/2007-12:33:15:: i INFO: Evaluation copy: 0 days left w3wp!runningjobs!6!8/6/2007-12:33:17:: i INFO: Database Cleanup (Web Service) timer enabled: Next Event: 600 seconds. Cycle: 600 seconds w3wp!runningjobs!6!8/6/2007-12:33:17:: i INFO: Running Requests Scavenger timer enabled: Next Event: 60 seconds. Cycle: 60 seconds w3wp!runningjobs!6!8/6/2007-12:33:17:: i INFO: Running Requests DB timer enabled: Next Event: 60 seconds. Cycle: 60 seconds w3wp!runningjobs!6!8/6/2007-12:33:17:: i INFO: Memory stats update timer enabled: Next Event: 60 seconds. Cycle: 60 seconds w3wp!library!6!08/06/2007-12:33:18:: Call to GetItemTypeAction(/). w3wp!library!6!08/06/2007-12:33:18:: i INFO: Catalog SQL Server Edition = Enterprise w3wp!library!6!08/06/2007-12:33:20:: Call to ListParentsAction(/). w3wp!library!6!08/06/2007-12:33:20:: Call to ListChildrenAction(/, False). w3wp!library!6!08/06/2007-12:33:22:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.AccessDeniedException: The permissions granted to user 'DEV1Administrator' are insufficient for performing this operation., ; Info: Microsoft.ReportingServices.Diagnostics.Utilities.AccessDeniedException: The permissions granted to user 'DEV1Administrator' are insufficient for performing this operation. w3wp!security!6!08/06/2007-12:33:22:: i INFO: Exception while running with elevated privileges w3wp!security!6!08/06/2007-12:33:22:: i INFO: The permissions granted to user 'DEV1Administrator' are insufficient for performing this operation. w3wp!library!6!08/06/2007-12:33:28:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.AccessDeniedException: The permissions granted to user 'DEV1Administrator' are insufficient for performing this operation., ; Info: Microsoft.ReportingServices.Diagnostics.Utilities.AccessDeniedException: The permissions granted to user 'DEV1Administrator' are insufficient for performing this operation. w3wp!security!6!08/06/2007-12:33:28:: i INFO: Exception while running with elevated privileges w3wp!security!6!08/06/2007-12:33:28:: i INFO: The permissions granted to user 'DEV1Administrator' are insufficient for performing this operation. w3wp!library!6!08/06/2007-12:33:28:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.AccessDeniedException: The permissions granted to user 'DEV1Administrator' are insufficient for performing this operation., ; Info: Microsoft.ReportingServices.Diagnostics.Utilities.AccessDeniedException: The permissions granted to user 'DEV1Administrator' are insufficient for performing this operation. w3wp!security!6!08/06/2007-12:33:28:: i INFO: Exception while running with elevated privileges w3wp!security!6!08/06/2007-12:33:28:: i INFO: The permissions granted to user 'DEV1Administrator' are insufficient for performing this operation. w3wp!library!6!08/06/2007-12:33:29:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.AccessDeniedException: The permissions granted to user 'DEV1Administrator' are insufficient for performing this operation., ; Info: Microsoft.ReportingServices.Diagnostics.Utilities.AccessDeniedException: The permissions granted to user 'DEV1Administrator' are insufficient for performing this operation. w3wp!security!6!08/06/2007-12:33:29:: i INFO: Exception while running with elevated privileges w3wp!security!6!08/06/2007-12:33:29:: i INFO: The permissions granted to user 'DEV1Administrator' are insufficient for performing this operation. w3wp!webserver!6!08/06/2007-12:33:29:: i INFO: Processed folder '/' w3wp!library!9!08/06/2007-12:37:33:: Call to ListParentsAction(http://DEV-ad-v2/mySites). w3wp!library!9!08/06/2007-12:37:33:: Call to ListParentsAction(http://DEV-ad-v2/mySites). w3wp!library!9!08/06/2007-12:37:33:: Call to ListChildrenAction(http://DEV-ad-v2/mySites, False). w3wp!webserver!9!08/06/2007-12:37:34:: i INFO: Processed folder 'http://DEV-ad-v2/mySites' w3wp!library!9!08/06/2007-12:39:28:: Call to GetSystemPropertiesAction(). w3wp!library!9!08/06/2007-12:40:18:: Call to GetPermissionsAction(http://DEV-ad-v2). w3wp!library!9!08/06/2007-12:40:18:: Call to GetSystemPropertiesAction(). w3wp!library!9!08/06/2007-12:40:18:: Call to GetPermissionsAction(http://DEV-ad-v2/Test Reports/Report1.rdl). w3wp!library!9!08/06/2007-12:40:26:: i INFO: Call to RenderFirst( 'http://DEV-ad-v2/Test Reports/Report1.rdl' ) w3wp!library!9!08/06/2007-12:40:29:: Using folder c:Program FilesMicrosoft SQL ServerMSSQL.2Reporting ServicesRSTempFiles for temporary files. w3wp!webserver!9!08/06/2007-12:40:30:: i INFO: Processed report. Report='http://DEV-ad-v2/Test Reports/Report1.rdl', Stream='' w3wp!library!9!8/6/2007-12:43:17:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs, 0 persisted streams w3wp!library!9!8/6/2007-12:53:17:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs, 0 persisted streams w3wp!library!9!08/06/2007-12:59:05:: Call to GetItemTypeAction(http://DEV-ad-v2/Shared Documents/Reports/Report Project3). w3wp!library!9!08/06/2007-12:59:05:: Call to GetItemTypeAction(http://DEV-ad-v2/Shared Documents/Reports). w3wp!library!9!08/06/2007-12:59:05:: Call to GetItemTypeAction(http://DEV-ad-v2/Shared Documents). w3wp!library!6!08/06/2007-12:59:06:: Call to CreateFolderAction(Reports, http://DEV-ad-v2/Shared Documents). w3wp!library!6!08/06/2007-12:59:08:: Call to CreateFolderAction(Report%20Project3, http://DEV-ad-v2/Shared Documents/Reports). w3wp!library!6!08/06/2007-12:59:09:: Call to GetItemTypeAction(http://DEV-ad-v2/Shared Documents/Data Sources). w3wp!library!6!08/06/2007-12:59:09:: Call to GetItemTypeAction(http://DEV-ad-v2/Shared Documents). w3wp!library!6!08/06/2007-12:59:09:: Call to CreateFolderAction(Data%20Sources, http://DEV-ad-v2/Shared Documents). w3wp!library!6!08/06/2007-12:59:10:: Call to GetItemTypeAction(http://DEV-ad-v2/Shared Documents/Data Sources/EDR.rsds). w3wp!library!6!08/06/2007-12:59:10:: Call to CreateDataSourceAction(EDR.rsds, http://DEV-ad-v2/Shared Documents/Data Sources, True). w3wp!library!6!08/06/2007-12:59:15:: Call to GetItemTypeAction(http://DEV-ad-v2/Shared Documents/Reports/Report Project3/Report1.rdl). w3wp!library!6!08/06/2007-12:59:15:: Call to CreateReportAction(Report1.rdl, http://DEV-ad-v2/Shared Documents/Reports/Report Project3, True). w3wp!library!6!08/06/2007-12:59:18:: Call to SetItemDataSourcesAction(http://DEV-ad-v2/Shared Documents/Reports/Report Project3/Report1.rdl). w3wp!library!6!08/06/2007-13:02:46:: Call to GetPermissionsAction(http://DEV-ad-v2/Shared Documents/Reports/Report Project3/Report1.rdl). w3wp!library!6!08/06/2007-13:02:46:: Call to ListParentsAction(http://DEV-ad-v2/Shared Documents/Reports/Report Project3/Report1.rdl). w3wp!library!6!08/06/2007-13:02:49:: Call to GetPermissionsAction(http://DEV-ad-v2). w3wp!library!6!08/06/2007-13:02:50:: Call to GetSystemPropertiesAction(). w3wp!library!6!08/06/2007-13:02:50:: Call to GetPermissionsAction(http://DEV-ad-v2/Shared Documents/Reports/Report Project3/Report1.rdl). w3wp!session!6!08/06/2007-13:02:56:: i INFO: LoadSnapshot: Item with session: kabqahahtxbdrgqfqza3zf45, reportPath: http://DEV-ad-v2/Shared Documents/Reports/Report Project3/Report1.rdl, userName: SHAREPOINTsystem not found in the database w3wp!library!6!08/06/2007-13:02:56:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.ExecutionNotFoundException: Execution 'kabqahahtxbdrgqfqza3zf45' cannot be found, ; Info: Microsoft.ReportingServices.Diagnostics.Utilities.ExecutionNotFoundException: Execution 'kabqahahtxbdrgqfqza3zf45' cannot be found w3wp!webserver!6!08/06/2007-13:02:56:: e ERROR: Reporting Services error Microsoft.ReportingServices.Diagnostics.Utilities.ExecutionNotFoundException: Execution 'kabqahahtxbdrgqfqza3zf45' cannot be found at Microsoft.ReportingServices.WebServer.HttpClientRequest.InitForRequest(CatalogItemContext context, UserContext userCtx) at Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderReport(HttpResponseStreamFactory streamFactory) at Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.DoStreamedOperation(StreamedOperation operation) at Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderItem(ItemType itemType) at Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderPageContent() at Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderPage() w3wp!library!6!08/06/2007-13:03:06:: Call to GetPermissionsAction(http://DEV-ad-v2). w3wp!library!6!08/06/2007-13:03:06:: Call to GetSystemPropertiesAction(). w3wp!library!6!08/06/2007-13:03:07:: Call to GetPermissionsAction(http://DEV-ad-v2/Test Reports/Report1.rdl). w3wp!session!6!08/06/2007-13:03:10:: i INFO: LoadSnapshot: Item with session: dpeedqvwmpr3z155qsu54m55, reportPath: http://DEV-ad-v2/Test Reports/Report1.rdl, userName: SHAREPOINTsystem not found in the database w3wp!library!6!08/06/2007-13:03:10:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.ExecutionNotFoundException: Execution 'dpeedqvwmpr3z155qsu54m55' cannot be found, ; Info: Microsoft.ReportingServices.Diagnostics.Utilities.ExecutionNotFoundException: Execution 'dpeedqvwmpr3z155qsu54m55' cannot be found w3wp!webserver!6!08/06/2007-13:03:10:: e ERROR: Reporting Services error Microsoft.ReportingServices.Diagnostics.Utilities.ExecutionNotFoundException: Execution 'dpeedqvwmpr3z155qsu54m55' cannot be found at Microsoft.ReportingServices.WebServer.HttpClientRequest.InitForRequest(CatalogItemContext context, UserContext userCtx) at Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderReport(HttpResponseStreamFactory streamFactory) at Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.DoStreamedOperation(StreamedOperation operation) at Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderItem(ItemType itemType) at Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderPageContent() at Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderPage() w3wp!library!6!08/06/2007-13:03:17:: Call to GetPermissionsAction(http://DEV-ad-v2). w3wp!library!6!08/06/2007-13:03:17:: Call to GetSystemPropertiesAction(). w3wp!library!6!08/06/2007-13:03:17:: Call to GetPermissionsAction(http://DEV-ad-v2/Test Reports/Report1.rdl). w3wp!library!6!8/6/2007-13:03:17:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs, 0 persisted streams w3wp!session!6!08/06/2007-13:03:21:: i INFO: LoadSnapshot: Item with session: gn34sn55qxkdwi55k2fm4y55, reportPath: http://DEV-ad-v2/Test Reports/Report1.rdl, userName: SHAREPOINTsystem not found in the database w3wp!library!6!08/06/2007-13:03:21:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.ExecutionNotFoundException: Execution 'gn34sn55qxkdwi55k2fm4y55' cannot be found, ; Info: Microsoft.ReportingServices.Diagnostics.Utilities.ExecutionNotFoundException: Execution 'gn34sn55qxkdwi55k2fm4y55' cannot be found w3wp!webserver!6!08/06/2007-13:03:21:: e ERROR: Reporting Services error Microsoft.ReportingServices.Diagnostics.Utilities.ExecutionNotFoundException: Execution 'gn34sn55qxkdwi55k2fm4y55' cannot be found at Microsoft.ReportingServices.WebServer.HttpClientRequest.InitForRequest(CatalogItemContext context, UserContext userCtx) at Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderReport(HttpResponseStreamFactory streamFactory) at Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.DoStreamedOperation(StreamedOperation operation) at Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderItem(ItemType itemType) at Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderPageContent() at Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderPage() w3wp!library!6!08/06/2007-13:03:53:: Call to ListParentsAction(http://DEV-ad-v2/mySites). w3wp!library!6!08/06/2007-13:03:53:: Call to ListParentsAction(http://DEV-ad-v2/mySites). w3wp!library!6!08/06/2007-13:03:54:: Call to ListChildrenAction(http://DEV-ad-v2/mySites, False). w3wp!webserver!6!08/06/2007-13:03:55:: i INFO: Processed folder 'http://DEV-ad-v2/mySites' w3wp!library!6!08/06/2007-13:04:12:: Call to GetPermissionsAction(http://DEV-ad-v2). w3wp!library!6!08/06/2007-13:04:12:: Call to GetSystemPropertiesAction(). w3wp!library!6!08/06/2007-13:04:12:: Call to GetPermissionsAction(http://DEV-ad-v2/Test Reports/Report1.rdl). w3wp!session!6!08/06/2007-13:04:23:: i INFO: LoadSnapshot: Item with session: s5oz5evzesse5cugbxxu1wy3, reportPath: http://DEV-ad-v2/Test Reports/Report1.rdl, userName: SHAREPOINTsystem not found in the database w3wp!library!6!08/06/2007-13:04:23:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.ExecutionNotFoundException: Execution 's5oz5evzesse5cugbxxu1wy3' cannot be found, ; Info: Microsoft.ReportingServices.Diagnostics.Utilities.ExecutionNotFoundException: Execution 's5oz5evzesse5cugbxxu1wy3' cannot be found w3wp!webserver!6!08/06/2007-13:04:23:: e ERROR: Reporting Services error Microsoft.ReportingServices.Diagnostics.Utilities.ExecutionNotFoundException: Execution 's5oz5evzesse5cugbxxu1wy3' cannot be found at Microsoft.ReportingServices.WebServer.HttpClientRequest.InitForRequest(CatalogItemContext context, UserContext userCtx) at Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderReport(HttpResponseStreamFactory streamFactory) at Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.DoStreamedOperation(StreamedOperation operation) at Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderItem(ItemType itemType) at Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderPageContent() at Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderPage() w3wp!library!6!08/06/2007-13:09:54:: Call to GetPermissionsAction(http://DEV-ad-v2). w3wp!library!6!08/06/2007-13:09:54:: Call to GetSystemPropertiesAction(). w3wp!library!6!08/06/2007-13:09:54:: Call to GetPermissionsAction(http://DEV-ad-v2/Test Reports/Report1.rdl). w3wp!session!6!08/06/2007-13:09:57:: i INFO: LoadSnapshot: Item with session: ex2ubmetmr13vdffxciursfg, reportPath: http://DEV-ad-v2/Test Reports/Report1.rdl, userName: SHAREPOINTsystem not found in the database w3wp!library!6!08/06/2007-13:09:57:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.ExecutionNotFoundException: Execution 'ex2ubmetmr13vdffxciursfg' cannot be found, ; Info: Microsoft.ReportingServices.Diagnostics.Utilities.ExecutionNotFoundException: Execution 'ex2ubmetmr13vdffxciursfg' cannot be found w3wp!webserver!6!08/06/2007-13:09:57:: e ERROR: Reporting Services error Microsoft.ReportingServices.Diagnostics.Utilities.ExecutionNotFoundException: Execution 'ex2ubmetmr13vdffxciursfg' cannot be found at Microsoft.ReportingServices.WebServer.HttpClientRequest.InitForRequest(CatalogItemContext context, UserContext userCtx) at Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderReport(HttpResponseStreamFactory streamFactory) at Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.DoStreamedOperation(StreamedOperation operation) at Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderItem(ItemType itemType) at Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderPageContent() at Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderPage() w3wp!library!6!8/6/2007-13:13:17:: i INFO: Cleaned 0 batch records, 0 policies, 2 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs, 0 persisted streams
I'm having problems setting up Reporting Services in SharePoint Integration mode. The development environment works fine, but I can't get it to work in production.
Problem seems to be in the authentication between SharePoint and Reporting Services. When I go to "Set Server Defaults" in the SharePoint central administration I get the following message:
Code Snippet
An unexpected error occurred while connecting to the report server. Verify that the report server is available and configured for SharePoint integrated mode. --> System.Web.Services.Protocols.SoapException: Server was unable to process request. ---> System.Net.WebException: The request failed with HTTP status 401: Unauthorized. at System.Web.Services.Protocols.SoapHttpClientProtocol.ReadResponse(SoapClientMessage message, WebResponse response, Stream responseStream, Boolean asyncCall) at System.Web.Services.Protocols.SoapHttpClientProtocol.Invoke(String methodName, Object[] parameters) at Microsoft.SqlServer.ReportingServices2006.ReportingService2006.ListSecureMethods() at Microsoft.ReportingServices.SharePoint.Soap.ReportService2006.ListSecureMethods() --- End of inner exception stack trace ---
I get the same message when trying to deploy a report from Visual Studio to a SharePoint lib.
Some info:
- SP apppool is running under domain account a
- SSRS apppool is running under domain account b
- SP uses NTLM authentication
- SP and SSRS are running on different servers
- SSRS Configuration shows all green checkmarks
Things I tried:
- Basic authentication instead of Windows Integrated on SSRS
- NTLM only instead of Negotiate on SSRS
- Settings SPN's for SSRS, didn't help
- Checked NTFS rights on ReportingServer dir, were fine (Domain users have read/list)
Does anyone have an idea about how to solve this? Any help is appreciated.
Setup: Windows server 2003 SP1, SQL 2005 SP2, Sharepoint Office server 2007, Report Services addin (CTP v9.00.3027).
Using the Report server configuration tool, setting Report Server Virtual directory, end up with RS Configuration tool crashing.
It appears to be happening on the task "Changing Secure connection level", & returns "System.NullReferenceException was unhandled Message: Object reference not set to an instance of an object."
I'm configuring now Reporting Services on SQL Server 2005 in Office Sharepoint Server 2007 integration mode. In the beginning of the process, I had already installed SQL Server 2005 with RS and Office SPS 2007. I used following guides to make further steps: How to Configure Reporting Services to Use a Non-Default Web Site (Reporting Services Configuration)
How to Configure Service Accounts (Reporting Services Configuration)
How to Configure SharePoint Integration on a Standalone Server How to Configure the Report Server Integration Feature in SharePoint Central Administration
Troubleshooting a Side-by-Side Installation of Reporting Services and Windows SharePoint Services
So I installed RS add-in for SPS, made RS configuration and almost all SPS configuration. I stopped with error
"An unexpected error occurred while connecting to the report server. Verify that the report server is available and configured for SharePoint integrated mode. --> Server was unable to process request. ---> The request failed with HTTP status 404: Not Found. " in "Set server defaults" command.
My servers configuration is following: 1. Both RS and SPS are running on the same server. 2. I cannot change port of default web site, so I made different web site "Reporting services" under same web server with port 8086 (http://mtx-sps2007:8086/reportserver)
3. RS Windows service runs under domain system account that is a member of local Administrators group (account name sql2k5sps7) 4. RS Web service runs under NT AuthorityNetworkService account 5. Database connection configured using mentioned above account sql2k5sps7
6. Report Server Web Service URL in SPS is set to http://mtx-sps2007:8086/reportserver 7. Authentication Mode in SPS is set to "Trusted account" 8. My account, under which I make a connections through terminal services to SPS and RS servers and through http to reportingservices page is a member of local administrators group of both my PC and server. 9. I'm not familiar with SPS (honestly speaking, with RS too, but at least I learning this quickly, but SPS is out of my responsibilities scope) 10. ReportServer runs under separated app pool that runs under NT AuthorityNetworkService account
And now I'm fighting with this error on "Set server defaults" command. It's interesting that from my PC there is no credentials prompt when entering SPS administrations page and error is following: An unexpected error occurred while connecting to the report server. Verify that the report server is available and configured for SharePoint integrated mode But from terminal client, connected to SPS and RS server, there is a credentials prompt (I enter my credentials) and error is as mentioned abowe: An unexpected error occurred while connecting to the report server. Verify that the report server is available and configured for SharePoint integrated mode. --> Server was unable to process request. ---> The request failed with HTTP status 404: Not Found. Also, the same error I got when I tried to add a report to report viewer web part on SPS test page.
Can anyone help me with this? I would be greately appreciated to any help on resolving this issue.
Hi, I tried to install sharepoint server 2007 as a standalone in my computer. When i run the sharepoint products and technologies configuration wizard, i get the following error,
Failed to create sample data.
An exception of type System.Data.Sqlclient.SqlException was thrown. Additional Exception information: Cannot open database "SharedServices2_DB_28aa01d8************************" requested by the login. The login failed. Login failed for user "domainAdministrator"
I am presently working on a project which handles much larger amount of data. The application demands extensive reporting from the SharePoint data. I'd like to know how I can generate reports from the SharePoint lists using Reporting Services.
Maybe someone can help me. I am running the reporting service add in for Sharepoint and we have only Basic Authentication running on our site (it is on SSL). When i try and open a report in sharepoint it errors out on me. When i go back into IIS and set Windows and Basic authentication it works, but it requires me to enter our domain and username. We need to only use Basic so it will not need the domain. Anyone have any suggestions on what i can do to make this work?
I am running SQL 2005 reporting services on a windows 2003 machine with SharePoint over SSL
My reporting services web directories are virtual directories under the SharePoint website.
I am having a problem with loading https://sharepoint.mysite.com/Reports/Pages/Folder.aspx
When you first open IE and bring up the page it takes about 30 seconds to load. Once you have connected via any machine, all other machines can connect at normal speed 1-2 seconds. All testing is being done on our LAN so there is no bandwidth issues when opening the pages.
My guess is that something is going into a sleep mode, but I am not sure where that would be set.
My site crashed, so I had to rebuild the Project Site.
I used the SharePoint products and technologies configuration wizard to disconnect from the server farm (only actually running on the single server).
I then reran SharePoint products and technologies configuration wizard to setup the site.
Configured the Project Service and attached to the existing dB's.
Previously, I used the url http://servername.domain.forest/PWA/default.aspx .
Now when I attempt the use the same URL, I get the following error:
"An unexpected error has occurred"
I have tested this one 3 servers now and I receive the exact same result. Is there a path I should apply to the servers in order to allow fully qualified server names after a reinstall of the system?
I have congigured Reporting Service for Sharepoint Integrated Mode adn Created new Reprot Server DB
Sahre Point Integration is Green and verified link
In Sharepoint Central Administration
Manage Reporting Service Integratio i have selected the URL and "Trusted Account" as my web applications use "Windows Integration - NTLM".
All services, DB access everything running under one domain user account.
I am logged into sharepoint with same account. When clieck on set server defaults i get following error
An unexpected error occurred while connecting to the report server. Verify that the report server is available and configured for SharePoint integrated mode. --> Server was unable to process request. ---> The request failed with HTTP status 401: Unauthorized.
Same error when i try to add a report to a sharepoint webapplication
The domain account is part of "Farm Administration", "site colletion administrato" and local administrator also on both servers.
We have an Office SharePoint 2007 site, we developed a couple of web parts and added them to our site. We used SQL Server Reporting services 2005 as our reporting solution. The reports are hosted on the report center and when we need a report, we open it by sending a URL requesting the report, passing the report parameters in the URL query string. So the report is filtered based on the parameters passed from the web parts.
But since best practices say that you should host reports directly under SharePoint, by configuring the reporting services to run in the SharePoint integrated mode. We followed the steps and installed SharePointRS and we finally succeeded to publish the reports to a SharePoint folder, but we had a limitation: we are unable to pass the report parameters internally to the report hosted in SharePoint. If we passed them in the query string as the report center case, SharePoint neglects them totally. So the question is: how can I pass parameters internally between a SharePoint web part and a SQL server 2005 reporting services report hosted in SharePoint?
Hi I am trying to run 4 - 5 store procedure in a strict order. I have created a SSIS package whereby I trying to execute store procedure in a orderly fashion. I have created constraints between them. Yet whenever I run the package - the store procedures run out of sequence. Is there something I can do to force the store procedure in orderly manner? Help will be much appreciated.
