Problem With (SQL Server 2005) Reporting Services Drill Through Using SWITCH Function In Sharepoint Integration Mode
When deploying reports to a report server in Sharepoint Integration mode (post SQL 2005 SP2), when using the SWITCH function when drilling through to another report ('jump to report'), you have to append the ".rdl" entension to the report name.
For example, on a report server in native mode, the following will work:
=SWITCH(Fields!Region.Value="US","USRegionDrillDownReport",
Fields!Region.Value="Europe","EURegionDrillDownReport")
When deploying to a report server in Sharepoint Integration mode, you must do the following:
=SWITCH(Fields!Region.Value="US","USRegionDrillDownReport.rdl",
Fields!Region.Value="Europe","EURegionDrillDownReport.rdl")
When doing this, the deployed report will work, but the link in the Visual Studio developer environment will no longer work (and vice versa).
View Complete Forum Thread with Replies
Related Forum Messages:
Installing SQL Server Reporting Services With SharePoint Integration Mode
Hello: I can't seem to get Reporting Server to work with Sharepoint Server 2007. My results are similar to the thread http://forums.microsoft.com/TechNet/ShowPost.aspx?PostID=1801673&SiteID=17 but with slightly different results. Server is running 32-bit Windows 2003 running Reporting Services only. Everything is green (except Reporting Services Manager which is greyed out) in Reporting Services configuration manager. Windows Service account is set to a domain (Windows)account. This server is also running SharePoint Server 2007 as a Web Front End within our SharePoint farm, and the Reporting Services add-in has been loaded on the machine. Issue 1: I cannot connect to the reporting service server AT ALL. When I type the URL into IE, I get the message: Reporting Services Error The report server has encountered a configuration error. See the report server log files for more information. (rsServerConfigurationError) The log file states: w3wp!library!1!09/20/2007-16:08:50:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.ServerConfigurationErrorException: The report server has encountered a configuration error. See the report server log files for more information., SharePoint content service is null. Report Server may not have joined the SharePoint farm, or Report Server service account may not have been granted access to farm.; Info: Microsoft.ReportingServices.Diagnostics.Utilities.ServerConfigurationErrorException: The report server has encountered a configuration error. See the report server log files for more information. The report service service account (I am assuming it is the one I used to install Reporting Services and as the Windows account above can log in to SharePoint central admin just fine. And I can see the reporting server in the server farm in SharePoint central admin. Issue 2: (It may be related) I can access "Manage Integration Settings" and "Grant Database Access" fine in SharePoint central admin. I am using trusted account because we are are using NTLM authentication. When I type in the database access it seems to find the report server because it doesn't throw an error. When I click on Set Server Defaults I get: An unexpected error occurred while connecting to the report server. Verify that the report server is available and configured for SharePoint integrated mode. Thanks in advance for any assistance you can provide. I can't seem to find any info on this of help.
View Replies !
Reporting Services In SharePoint Integration Mode Problems
Hi, 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.
View Replies !
SQL Server 2005 Reporting Services Integration With SharePoint 2007
Hello Everyone, 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: 1. http://msdn2.microsoft.com/en-us/library/bb326356.aspx <---Microsoft's Steps 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: http://msdn2.microsoft.com/en-us/library/bb326213.aspx 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! =) --A4orce84
View Replies !
SQL 2005 SP2 Reporting Services And Window SharePoint Services V3 Integration Config Issue
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
View Replies !
Reports Cannot Be Deployed From VS 2005 To Reporting Services In WSS Integration Mode
I tried to deploy reports from VS 2005 on Dev to Prod (different domain, in WSS integration mode) , but VS keeps showing the login window ... I set up TargetDataSourceFolder, TargetReportFolder and TargetServerURL in VS 2005 on my Dev machine as mentioned in MSDN article "Deploying Reports, Models, and Shared Data Sources to a SharePoint Site" and tried to deploy reports to Prod machine. But VS 2005 keeps showing "Report Services Login" window to me, even when I used Administrator account of that Prod machine. The WSS log file on the Prod machine shows this error: "The file you are attempting to save or retrieve has been blocked from this Web site by the server administrators." Any ideas? Thanks in advance! I have searched for days for this issue ...
View Replies !
Reporting Services And Sharepoint Integration - Sharepoint Alternate Access Mappings (Zones)
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? Many thanks to anyone who can help!
View Replies !
Reporting Services 2005 In SharePoint Integrated Mode With Forms Based Authentication
Well, I have SQL Server 2005 SP2 Reporting Services installed and configured in sharepoint integrated mode, so I am deploying reports in sharepoint libraries. Also I configured sharepoint to use forms authentication with builtin AspNetSqlMembership provider, but after this action I couldnot open reports through sharepoint library, instead of this, error was displayed mentioned below. I searched and found hotfix Cumulative Update 3 build 3186 for this issue, request it from microsoft support and applied it, but nothing has changed! Error I have been experiencing 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. --> The request failed with the error message: -- <html><head><title>Object moved</title></head><body> <h2>Object moved to <a href="/_layouts/login.aspx?ReturnUrl= %2f_vti_bin %2fReportServer%2fReportService2006.asmx">here</a>.</h2> </body></html> I continued to dig and find out that this hotfix should update Microsoft.ReportingServices.SharePoint.UI.WebParts.dll from version 9.0.3042.0 to new version 9.0.3180.0, but when I checked file version after applying hotfix, it remained the same as was before i.e. 9.0.3042.0. Apparently this cumulative update does not fix this issue. anyone has any idea how to solve it? Thanks in advance. sorry for my poor english :-)
View Replies !
How To Get Server Mode Option In Reporting Services Configuration For Sharepoint?
Hi All, I want to deploy my reports in a Sharepoint site. So I need to change the Deployment mode from Native to Sharepoint Integrated mode. When go to Reporting Services Configuration and in Database Setup - the Server Mode option is not visible. Anyone help me what is the reason for this or How to get Server Mode option in Database Setup in Reporting Services Configuration menu. However the system installed with Sharepoint and SSRS SP2. Thanks in advance, Senthil
View Replies !
SharePoint Server 2007 Integration With Reporting Service 2005
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. Thanks and i would really appreciate your help
View Replies !
Configuring Reporting Services Integration With Sharepoint
The first two steps of integration went fine. However, when I try to set the reporting services server defaults I always get this message. Server was unable to process request. ---> The request failed with HTTP status 401: Unauthorized. Any ideas on how to get past this? I am with two different SQL servers. The sharepoint installation is on a web server and the reporting services installation is on our report server. The sharepoint databases are on a server that is not on SP2 CTP, but the reporting databases are.
View Replies !
Reporting Services / SharePoint Integration Issue
Hello all, 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? Thanks. Deepak.
View Replies !
Reporting Services And Sharepoint Integration - I'm Confused
I have 2 servers - one is the MOSS 2007 server (32-bit), the other is the SQL 2005 SP2 (64-bit) database with Reporting Services already installed. I'm trying to understand what goes where. So the first thing I did was install Reporting services, plus SQL SP2, plus the Reports Add-in, on my MOSS 2007 server. I attempted to configure Reporting Services for that server, but of course, there are no databases. So I then attempted to connect to my SQL Server. From there I can not get it to integrate with Sharepoint. After searching the Internet, I found that you need to install the basic Sharepoint installation on the same server that the Reports Server was located, so I downloaded the WSS 3.0 64-bit version and installed it on my SQL machine. I was able to configure Report Services integration with Sharepoint going through the Report Services Configuration program. Clicking on the integration link in the Config program brought me to Central Admin where I saw the options for configuring Reporting on Sharepoint. The first link asks me for my Report Server Web Service URL. Here is where I get confused. Would that be http://MOSS2007/ReportServer or would that be http://SQL2005/ReportServer? I *thought* it was the MOSS server URL. It accepts that, and I have trusted account since I made sure that every service was running with the same specific domain account. In Grant Database Access - It asks you to "specify the server and instance name of the report server". Since I have the report server program installed now on both servers, which one do I specify here? I can tell you that the database is located on the SQL 2005 server. It says it will give access to the report server web and windows service accounts to the Sharepoint database. I put in the name of the SQL server, then when prompted the domain account. This is the correct information to pass it right? Next, on the Reporting Services Server defaults page, I get the page but an error message across the top that says: The Report Server Web Service is unable to access secure information in the report server. Please verify that the WebServiceAccount is specified correctly in the report server config file. I checked the rsReportServer.config file, on the SQL server database, and that has the domain account I used. That's where I should be looking right? Now I'm dead in the water. I have read so many Microsoft MSDN posts, blog posts, and forum posts, and I'm not finding answers to my problem. Can anyone who has successfully set this up tell me if I'm doing something wrong somewhere? Thanks! Linda
View Replies !
Reporting Services And Sharepoint Integration Issue
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?
View Replies !
SharePoint Reporting Services Integration 'Execution ... Cannot Be Found'
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 Thank you, John
View Replies !
Reporting Services Vs SharePoint Integrate Mode (urgent)
Dear friends, I'm having problems changing the reporting services from native modo to integrate mode... I saw a lot of articles and tips, but I still have problems... For example, when I change my database setup to integrate mode there is all ok, but in the SharePoint tab has an image with error... and in the sharepoint server when I need to grant acess to database gets an error to... and the page that always runned : http://CGDWX01115883/ReportServer after I change to integrate does not work and gives me this error: Reporting Services Error An internal error occurred on the report server. See the error log for more details. (rsInternalError) Get Online Help Exception has been thrown by the target of an invocation. Could not load file or assembly 'Microsoft.SharePoint, Version=12.0.0.0, Culture=neutral, PublicKeyToken=71e9bce111e9429c' or one of its dependencies. The system cannot find the file specified. SQL Server Reporting Services This page must run ok, no? Get Online Help Exception has been thrown by the target of an invocation. Could not load file or assembly 'Microsoft.SharePoint, Version=12.0.0.0, Culture=neutral, PublicKeyToken=71e9bce111e9429c' or one of its dependencies. The system cannot find the file specified. SQL Server Reporting Services This page must run ok, no? http://CGDWX01115883/ReportServer CGDWX01115883 is the report server and database server SDC6001SPT01 is the SharePoint Server Could someone help me?! Thanks!
View Replies !
Problems Configuring SQL Reporting Services In SharePoint Integrated Mode
I am trying to follow the instructions on: http://technet.microsoft.com/en-us/library/bb677365.aspx they contain many "if"s and links to other sites and I got totally confused and stuck. The idea is - I need to have one machine with SQL for reporting services and SharePoint databases and the reporting services and the other machine for a complete SharePoint installation (the main server of the farm) Now I have done the following: two servers (lets call them SQL and MOSS) The domain contains the following users: sqlservices: for running all the SQL services and reporting services moss: for administering MOSS databases moss-services: for running all the MOSS services Machine SQL - installed Windows Server 2003 Standard Edition SP1, joined to the domain as SQL The following is done from a local Administrator account: IIS 6 with ASP.NET installed SQL Server 2005 with SP2, Reporting services installed but not configured all the services are running as domainsqlservices .NET 3.0 installed http://support.microsoft.com/kb/918642 fix installed done WINDOWSMicrosoft.NETFrameworkv2.0.50727aspnet_regiis €“i MOSS as Web Front installed, not configured Machine MOSS - installed Windows Server 2003 Standard Edition SP1, joined to the domain as MOSS The following is done from a local Administrator account: IIS 6 with ASP.NET installed .NET 3.0 installed http://support.microsoft.com/kb/918642 fix installed done WINDOWSMicrosoft.NETFrameworkv2.0.50727aspnet_regiis €“i Computers->My computer->DCOM Config->IIS WAMREG admin Service->PropertiesSecurity->Customize->Edit, added domainmoss-services and domainMOSS users with rights Local launch, Local activate MOSS Complete installed, configured for: New server farm Database server: SQL Username: domainMOSS Port: Default Auth: NTLM SharePointRS.msi installed to enable RS in SharePoint Admin page Then temporarily gave to the user domainMOSS sysadmin rights in the SQL server on the SQL machine to avoid errors with creating databases while configuring SharePoint from the Admin Portal. From the Admin Portal configured Office SharePoint Server Search with domainmoss-services account Shared Services Administration €“ New SSP created with 2 separate web apps for SSP and MySites, both app pools run as domainmoss-services and SSP itself runs as domainmoss-services Windows SharePoint Services Search configured, Service Account - domainmoss-services, Content Access Account - domainmoss-services Everything went OK. Now came back to the machine SQL: run Reporting Services Configuration and: Report Server Virtual Directory €“ created new, called it ReportServer. When hit Apply, the applicatin suddenly quit, but I checked €“ the Virtual Directory was registered on the IIS and working. Checked if Windows service identity is domainsqlservices, OK. Web service identity: Application Pool: New Name: ReportServer Windows Account: domainsqlservices Apply, everything went fine. Database setup: choose server SQL, Connect Database name: New name: ReportServer, checked Create the report server database in SharePoint Integrated Mode OK Credeantials Type - Service credentials (I guess it means previously set domainsqlservices will be used) Apply,OK, everything went fine. Launch SharePoint Products and Technologies Configuration Wizard, Connect to an existing farm, Database server: SQL, Retrieve datbase names: selected SharePoint_Config, Username: domainMOSS, Next, everything fine here. Now as far as I understand I need to give reporting services an access to SharePoint databases? Went to the machine MOSS, launched SharePoint 3.0 Central Administration: Application Management-> Reporting Services-> Manage integration settings, URL: http://SQL/reportserver, Windows Authentification, OK then back, Grant database access-> Server Name: SQL, OK, now it is asking for credentials. And now the problem: no matter what I enter (domainsqlservices, domainMOSS) I get a message: €žA connection to the computer cannot be established€?. Why, why, why? I can ping the server, SharePoint services are running fine and they are using the SQL server on the SQL machine and there are no errors in the event viewer (they should be if there were any problems to connect the SQL databases). If I enter wrong credentials, I receive "Unable to log on with the given username and password.", so I guess there IS a connection to the computer (or how else could SharePoint determne that login is wrong?). Also, if I open http://SQL/reportserver, I get €žThe report server has encountered a configuration error€? and the log in C:Program FilesMicrosoft SQL ServerMSSQL.2Reporting ServicesLogFiles says €žSharePoint content service is null. Report Server may not have joined the SharePoint farm, or Report Server service account may not have been granted access to farm.€? I guess it is OK while I have not granted access to the SharePoint databases? Please, show me, what did I do so wrong that €žA connection to the computer cannot be established€?? How can I grant the access and finalize configuring Reporting Services? Thanks.
View Replies !
Creating Simple Report Using Reporting Services SP2 And SharePoint 2007 Integration
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.
View Replies !
Reporting Services In Share Point Integration Mode - Deployment Error
Hi I am trying to deploy the reports on the share point site which is integrated with the reports Server. I am getting below error while deploying it. Sharepoint Server, Reports Server and Database Servers are on 3 different boxes. =================================== A connection could not be made to the report server http://vstsvr:171/sites/wslReports. (Microsoft Report Designer) =================================== Server was unable to process request. ---> The request failed with HTTP status 401: Unauthorized. (System.Web.Services) ------------------------------ Program Location: 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.ReportDesigner.Project.ReportServiceClient2006.CheckAuthenticated() at Microsoft.ReportDesigner.Project.ReportClientManager.DetectEndpointAndAuthenticate(String url, ICredentials credentials, String& authCookieName, Cookie& authCookie, EndpointType& endpointType) at Microsoft.ReportDesigner.Project.ReportClientManager.GetCredentials(String url) at Microsoft.ReportDesigner.Project.ReportProjectDeployer.PrepareDeploy() Can any one help on this. Thanks Devanand
View Replies !
SQL Server 2005 Reporting Services Add-in For SharePoint, Installation
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." any ideas?
View Replies !
SQL Server 2005 Reporting Services Integration
How can we Integrate SQL server 2005 Report builder, Report designer in a custom .Net Application ? . Please Help me. I want to provide Report Designer, Report builder and Query builder functionalities to my .Net application. How can I Integrate them in my application?
View Replies !
Migrating Reporting Services 2005 With Integrated Sharepoint 2007 To Another Server
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.
View Replies !
Problems With SharePoint Integration And Reporting On SharePoint With SSRS
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. A. Original format from posting <Query> <Method Namespace=http://schemas.microsoft.com/sharepoint/soap/ Name="GetListItems"/> <SoapAction> http://schemas.microsoft.com/sharepoint/soap/GetListItems </SoapAction> </Query> 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) <Query> <Method Namespace="http://schemas.microsoft.com/sharepoint/soap/" Name="GetListItems"/> <SoapAction>http://schemas.microsoft.com/sharepoint/soap/GetListItems </SoapAction> </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: <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 Stramit CAML query: <Query xmlns="http://schemas.microsoft.com/sharepoint/soap/"> <OrderBy> <FieldRef Name="ID" /> </OrderBy> </Query> 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 2a. Install ASP.NET, IIS (www) and .NET 2.0 3. Install SQL/SSRS 2005 Std 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.
View Replies !
Errors With SRS In Sharepoint Integration Mode
Hi Everyone, Our project has two servers. One server is running WSS 3.0 and the SQL Reporting Services web front-end. We have a second server that operates all the databases involved (WSS Content, SRS, and our application specific DB). We do not have a domain controller in our architecture. The WSS site is configured to use SQL authentication to connnect and modify the WSS Content database. We installed SRS, SRS service pack 2, and the Sharepoint add-in. We are using forms authentication for our WSS site. We would like to use SRS in Sharepoint Integration mode, but we are unable to create datasources, view reports, etc. SRS is configured to use the "Trusted Account" in WSS Central Admin. When we attempt to create a new datasource, and we received an error stating the object moved and to check that SRS is in Sharepoint integration mode. When we attempt to view a report, we get an error stating: "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 a feeling this has to do with the Windows Service Account and the Web Service Identity for SRS. What type of account should we use since we do not have a domain? Thank you, Michael milazzo
View Replies !
Hiding Reports In Sharepoint Integration Mode
I'm setting the Hidden property to True and then creating the report using the CreateReport method from the ReportingService2006 class. When I check the reportserver database Hidden is set to true. But when I call the GetProperties method it shows Hidden as being false. And in the document library the reports are visable. I tried calling the SetProperties method after I created the report but it still didn't work. Here's how I create the report. Dim props(0) As ReportServer.Property Dim SetProp As New ReportServer.Property SetProp.Name = "Hidden" SetProp.Value = "True" props(0) = SetProp rs.CreateReport(Path.GetFileName(fileName), Folder, True, bytes, props, warnings) Any idea? Thanks, -Somsong
View Replies !
Deploy Error To Sharepoint Integration Mode
Hi, I got error "A connection could not be made to the report server http://servername/sitename" when I tried to deploy the data model into sharepoint site from Businesss Inteligent studio. Howervr i am able to deploy from the sharepoint server machine locally.(with the same windows login user). All the authetication mode is Windows authetication. Any help will be very appreciated. Robert
View Replies !
SP2 Integration Mode Kills Sharepoint Central Administration
Hi I had the following setup: Farm Server 1 * Sharepoint 2007 full install Farm Server 2 * SQL Server 2005 I installed the following: * SP2 for SQL Server 2005 on Server 2 * Web-front end install of Sharepoint 2007 on Server 2 - to install the object model * SSRS2005 reporting services add-in for Sharepoint technologies on Server 2 Since doing that, I can no longer get to central administration on Server 1 - I now get the following error when navigating to central admin: Server Error in '/' Application. Runtime Error Description: An application error occurred on the server. The current custom error settings for this application prevent the details of the application error from being viewed remotely (for security reasons). It could, however, be viewed by browsers running on the local server machine. Which web.config do I have to edit to get the full error to show, and has anyone else experienced this? This happened to me when my servers were fully configured and had data - so I rebuilt them from scratch and the same problem occured again! Adam
View Replies !
Sharepoint Integration Mode Basic Authentication Problems
Hi there, I am implementing SSRS 2005 Sharepoint integration mode in a stand alone server and we are having problems with basic authentication. When the MOSS web application and the Report Server application is in Windows Integrated authentication Everything works fine and we can upload and view reports in the sharepoint site. But when we switch the MOSS web application into basic authentication and RS stays the same with windows integrated authentication the reports in sharepoint throw 401 unauthorized errors. It looks like the error occurs when accessing the _vti_bin/ReportServer/ReportService2006.asmx web service?? Anyone have any fix on this???? Does SSRS 2005 Sharepoint integration mode support Basic authentication???
View Replies !
Report Deployment Error In SharePoint Integration Mode
Hi, I get the following error when I am trying to deploy Report from Visual Studio Report Designer. SRSS is configured in SharePoint integration mode. Configuration is mentioned below. TITLE: Microsoft Report Designer ------------------------------ A connection could not be made to the report server http://rbddspsdev2:44887/. ------------------------------ ADDITIONAL INFORMATION: Server was unable to process request. ---> The request failed with HTTP status 401: Unauthorized. (System.Web.Services) ------------------------------ BUTTONS: OK Configuration is as follows. Web front end server. MOSS 2007 Standard edition 64 bit. SQL Reporting Service Add in 64 bit. SQL Server MS SQL server 2005 32 bit with sp2. Reporting Services configured. WSS 3.0 32 bit required for configuration, of SRSS in integrated mode. Windows service and web service are both running under a domain account. The account is a SharePoint Admininstrator. The account is also in Administrators, Reporting Server user and Web service group and also has a dbo rights on database.
View Replies !
How To Drill Down A Parent Child Hierarchy In Reporting Services 2005 ?
Hello, I want to enable a drill down on a parent child hierarchy, just as it is possible in the Analysis Services. An Example : Hierarchy in a company : Jack (1) is the boss, Frank (2) and Andy (3) ar the Semi-Bosses , and Julia (4), Jane (5), Henry (6), Michael (7), Will (8) , Dave (9) are normal employees . Timmy(10) is a trainee. Furthermore Frank is responsible for Julia,Jane and Henry and Andy is responsible for Michael WIll and Dave. Dave is responsible for Timmy. So we get the following tree hierarchy structure. 1 2 3 4 5 6 7 8 9 10 My Employee Dimension Attributes : Name, Parent I want to make a report, where I show the salary of each employee. But at first the user only sees 1, when he drills down he sees 2 and 3, too. When he drills down once more he sees 4 5 6 and 7 8 9, too (The user must be able to recognize which person is responsible for 456 and which for 789). And the last drill down shows 10, for which 9 is responsible ( exactly as it is possible in the analyis Service in the Cubebrowser) I have read some posts where are MDX examples which are similar to my problem, but they did not solve my problem. I hope somebody can help me JF
View Replies !
Unable To Deploy Reports From VStudio When Working In SharePoint Integration Mode
Hello, I have a configuration where my SharePoint services are running on a web machine and the SQL server reporting services are running on a different machine. I installed SQL SP2 and the SQL Server Reporting Services Add-in for SharePoint by following all the instructions listed in €œConfiguring Reporting Services for SharePoint 3.0 Integration€? (http://msdn2.microsoft.com/en-us/library/bb326356.aspx). My issue is that when I Deploy a report from a VS Report Server project by running Visual Studio on the machine where reporting servicers is running, everything works fine. But if I try the same thing on any other machine on the network, I get a €œThe file you are attempting to save or retrieve has been blocked from this Web site by the server administrators.€? message. I€™m sure I€™m missing something on the configuration but I can€™t tell what. Thanks a lot Gabo
View Replies !
Grant Database Access SharePoint Integration Mode. Connection To The Computer Cannot Be Established
The scenario: Computer A has SQL Server 2005 SP2 and Reporting Services Instance in sharepoint integration mode Computer B has SharePoint Services 3.0 Installed SharePointRS.msi on Computer B For Computer A, followed directions outlined http://technet.microsoft.com/en-us/library/aa905869.aspx For Computer A, reviewed directions outlined http://sqlblogcasts.com/blogs/stevechowles/archive/2007/07/02/reporting-services-2005-for-the-dba-changing-application-pool-identity.aspx Then in SharePoint Services Administration Application Management page, click the Grant Database Access link in the Reporting Services group. Enter the name of the server for Computer A and the instance name of the reporting services and click OK. In the enter credentials dialog, enter the domain service account and password and click OK. Message displays: "A connection to the computer cannot be established." Checked service account group membership on Computer A: member of all of the SQL groups and member of Power Users group. SETSPN was executed for Computer A for the Service Account. Hmmm... on a hunch, I added the service account to the local Administrators group and attempted the Grant Database Access procedure again. Huh? It works? Great... except operations will never go for the solution of adding a service user to the local Administrators group of a production SQL Server. Dooh! Can someone tell me the correct permissions required on Computer A so that the SharePoint integration configuration can be completed in the above scenario?
View Replies !
Drill Down Report In SQL Server 2000 Reporting Services
Hi, I want to create a drill-down report in SQL RS using stored procedures. My stored procedure returns a dataset with multiple tables. This is where the problem comes in. From the looks of it, SQL RS can only handle a dataset with one table when a stored procedure is used to retrieve the data. I haven't found any documentation on using stored procedures with SQL RS. Does that mean that I have to create two datasets, one for the master data and another one for the detail data, and render them seperately?(I was hoping to use it the way I do in .Net, with multiple tables within the dataset, a DataRelation and a DataView to filter the detail) Does anybody have an elegant work-around to this problem? Thanks. KJ PS This is my first report in SQL RS. I am basically clueless about this topic, so any suggestions will be welcome!
View Replies !
SQL 2005 Reporting Services SP2 Integration With MOSS 2007 SSL Error
Hi, 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) Can anyone help me?
View Replies !
X64 Version Of SharePoint Integration Services
I see on the download page that the SharePoint Integration component only runs on x86. Are then any plans or timetable to release an x64 version? We run both the x64 version of SharePoint 2007 and SQL 2005. This is the second SQL Server component (the first being the IIS Merge Replication agent) that has been released only for x86. What gives?
View Replies !
Setting Up Report Services Sharepoint Integration
I'm trying to setup Sharepoint Integration with report services. I have one server which has a Current Report Server and would like to set up an additional Report Server on the same machine with Report Server in Sharepoint integration mode. Then I can slowly migrate the reports off of the Report Server to Sharepoint. Is there a way to do this? What I've tried: I launched Reporting Services Configuration and noticed there is no Sharepoint Integration Mode selection so I was stumped there. Thanks for your help.
View Replies !
Reporting Service In SharePoint Integation Mode Deployment
Hi, I am facing problem in Deployement of Reports from Visual Studio 2005 into SharePoint Document Libarary. Error is : "HTTP 401 Unauthrized" (Syatem.web.service). Basically I have two machine, One is SharePoint Server Farm and another is SQL Server, Reporting Server and sharepoint Web font end installation. Sharepoint Share_Configaration and content DB are into Second machin (SQL Server). Please help me regarding this issue. Regards and Thanks, Manas
View Replies !
Microsoft SQL Server Reporting Services Integration Version 9.00
HI Guys, I installed a distributed test environment, 1 Domain controller, 1 SQL Server 2005 with report services and SharePoint 2007. I followed the recommendation for installation and having the same problem connecting to the Set Server Defaults from Central Administration/Application managment. I have followed the work around to setup the 1x2 SPN's on my domain controller and also force IIS to use NTLM, at this point my hair is about to be pulled out. as I am still getting the below 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 placed a copy of the report services log file for additional information. <Header> <Product>Microsoft SQL Server Reporting Services Version 9.00.3042.00</Product> <Locale>en-US</Locale> <TimeZone>GMT Daylight Time</TimeZone> <Path>C:Program FilesMicrosoft SQL ServerMSSQL.3Reporting ServicesLogFilesReportServerService__06_15_2007_10_51_30.log</Path> <SystemName>DMTXDW01VM2</SystemName> <OSName>Microsoft Windows NT 5.2.3790 Service Pack 1</OSName> <OSVersion>5.2.3790.65536</OSVersion> </Header> ReportingServicesService!library!4!15/06/2007-10:51:31:: i INFO: Initializing ConnectionType to '1' as specified in Configuration file. ReportingServicesService!library!4!15/06/2007-10:51:32:: i INFO: Initializing IsSchedulingService to 'True' as specified in Configuration file. ReportingServicesService!library!4!15/06/2007-10:51:32:: i INFO: Initializing IsNotificationService to 'True' as specified in Configuration file. ReportingServicesService!library!4!15/06/2007-10:51:32:: i INFO: Initializing IsEventService to 'True' as specified in Configuration file. ReportingServicesService!library!4!15/06/2007-10:51:32:: i INFO: Initializing PollingInterval to '10' second(s) as specified in Configuration file. ReportingServicesService!library!4!15/06/2007-10:51:32:: i INFO: Initializing WindowsServiceUseFileShareStorage to 'False' as specified in Configuration file. ReportingServicesService!library!4!15/06/2007-10:51:32:: i INFO: Initializing MemoryLimit to '60' percent as specified in Configuration file. ReportingServicesService!library!4!15/06/2007-10:51:32:: i INFO: Initializing RecycleTime to '720' minute(s) as specified in Configuration file. ReportingServicesService!library!4!15/06/2007-10:51:32:: i INFO: Initializing MaximumMemoryLimit to '80' percent as specified in Configuration file. ReportingServicesService!library!4!15/06/2007-10:51:32:: i INFO: Initializing MaxAppDomainUnloadTime to '30' minute(s) as specified in Configuration file. ReportingServicesService!library!4!15/06/2007-10:51:32:: i INFO: Initializing MaxQueueThreads to '0' thread(s) as specified in Configuration file. ReportingServicesService!library!4!15/06/2007-10:51:32:: i INFO: Initializing IsWebServiceEnabled to 'True' as specified in Configuration file. ReportingServicesService!library!4!15/06/2007-10:51:32:: i INFO: Initializing MaxActiveReqForOneUser to '20' requests(s) as specified in Configuration file. ReportingServicesService!library!4!15/06/2007-10:51:32:: i INFO: Initializing MaxScheduleWait to '5' second(s) as specified in Configuration file. ReportingServicesService!library!4!15/06/2007-10:51:32:: i INFO: Initializing DatabaseQueryTimeout to '120' second(s) as specified in Configuration file. ReportingServicesService!library!4!15/06/2007-10:51:32:: i INFO: Initializing ProcessRecycleOptions to '0' as specified in Configuration file. ReportingServicesService!library!4!15/06/2007-10:51:32:: i INFO: Initializing RunningRequestsScavengerCycle to '60' second(s) as specified in Configuration file. ReportingServicesService!library!4!15/06/2007-10:51:32:: i INFO: Initializing RunningRequestsDbCycle to '60' second(s) as specified in Configuration file. ReportingServicesService!library!4!15/06/2007-10:51:32:: i INFO: Initializing RunningRequestsAge to '30' second(s) as specified in Configuration file. ReportingServicesService!library!4!15/06/2007-10:51:32:: i INFO: Initializing CleanupCycleMinutes to '10' minute(s) as specified in Configuration file. ReportingServicesService!library!4!15/06/2007-10:51:32:: i INFO: Initializing DailyCleanupMinuteOfDay to default value of '120' minutes since midnight because it was not specified in Configuration file. ReportingServicesService!library!4!15/06/2007-10:51:32:: i INFO: Initializing WatsonFlags to '1064' as specified in Configuration file. ReportingServicesService!library!4!15/06/2007-10:51:32:: i INFO: Initializing WatsonDumpOnExceptions to 'Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException,Microsoft.ReportingServices.Modeling.InternalModelingException' as specified in Configuration file. ReportingServicesService!library!4!15/06/2007-10:51:32:: i INFO: Initializing WatsonDumpExcludeIfContainsExceptions to 'System.Data.SqlClient.SqlException,System.Threading.ThreadAbortException' as specified in Configuration file. ReportingServicesService!library!4!15/06/2007-10:51:32:: i INFO: Initializing SecureConnectionLevel to '0' as specified in Configuration file. ReportingServicesService!library!4!15/06/2007-10:51:32:: i INFO: Initializing DisplayErrorLink to 'True' as specified in Configuration file. ReportingServicesService!library!4!15/06/2007-10:51:32:: i INFO: Initializing WebServiceUseFileShareStorage to 'False' as specified in Configuration file. ReportingServicesService!resourceutilities!4!15/06/2007-10:51:33:: i INFO: Reporting Services starting SKU: Standard ReportingServicesService!resourceutilities!4!15/06/2007-10:51:33:: i INFO: Evaluation copy: 0 days left ReportingServicesService!resourceutilities!4!15/06/2007-10:51:33:: i INFO: Running on 2 physical processors, 2 logical processors ReportingServicesService!library!8!15/06/2007-10:51:36:: i INFO: Catalog SQL Server Edition = Standard ReportingServicesService!crypto!8!15/06/2007-10:51:36:: i INFO: Initializing crypto as user: SPSTESTserv_sharepoint ReportingServicesService!crypto!8!15/06/2007-10:51:36:: i INFO: Exporting public key ReportingServicesService!crypto!8!15/06/2007-10:51:37:: i INFO: Performing sku validation ReportingServicesService!crypto!8!15/06/2007-10:51:37:: i INFO: Importing existing encryption key ReportingServicesService!dbpolling!8!06/15/2007-10:51:40:: i INFO: EventPolling polling service started ReportingServicesService!dbpolling!8!06/15/2007-10:51:40:: i INFO: NotificationPolling polling service started ReportingServicesService!dbpolling!8!06/15/2007-10:51:40:: i INFO: SchedulePolling polling service started ReportingServicesService!dbpolling!8!06/15/2007-10:51:40:: i INFO: UpgradePolling polling service started ReportingServicesService!dbpolling!c!15/06/2007-10:51:40:: i INFO: EventPolling heartbeat thread started. ReportingServicesService!dbpolling!d!15/06/2007-10:51:40:: i INFO: NotificationPolling heartbeat thread started. ReportingServicesService!dbpolling!e!15/06/2007-10:51:40:: i INFO: Polling started ReportingServicesService!runningjobs!8!06/15/2007-10:51:40:: i INFO: Database Cleanup (NT Service) timer enabled: Next Event: 600 seconds. Cycle: 600 seconds ReportingServicesService!runningjobs!8!06/15/2007-10:51:40:: i INFO: Daily Catalog Cleanup (NT Service) timer enabled: Next Event: 54499 seconds. Cycle: 86400 seconds ReportingServicesService!runningjobs!8!06/15/2007-10:51:40:: i INFO: Running Requests Scavenger timer enabled: Next Event: 60 seconds. Cycle: 60 seconds ReportingServicesService!runningjobs!8!06/15/2007-10:51:40:: i INFO: Running Requests DB timer enabled: Next Event: 60 seconds. Cycle: 60 seconds ReportingServicesService!runningjobs!8!06/15/2007-10:51:40:: i INFO: Execution Log Entry Expiration timer enabled: Next Event: 54499 seconds. Cycle: 86400 seconds ReportingServicesService!runningjobs!8!06/15/2007-10:51:40:: i INFO: Memory stats update timer enabled: Next Event: 60 seconds. Cycle: 60 seconds ReportingServicesService!runningjobs!8!06/15/2007-10:51:40:: i INFO: SQM timer timer enabled: Next Event: 58099 seconds. Cycle: 86400 seconds ReportingServicesService!library!b!15/06/2007-11:01:40:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs, 0 persisted streams
View Replies !
Reporting Serivces In SharePoint Integrated Mode Give The Wrong User.
Hi, I'm using reporting services 2005 SP 2 in SharePoint integrated mode (with WSS 3.0) with forms authentication. Both reporting services and SharePoint are installed on same server under the same website. This setup was working correctly until I extended the site for an intranet version of the application to enable the site search to work with forms authentication (see http://technet2.microsoft.com/windowsserver/WSS/en/library/8208d71e-7c41-4845-bc06-95429de02cf11033.mspx?mfr=true) Now the search works correctly but the logged in user reported by reporting service is always the SharePoint application pool user. If I stop the intranet site reporting services reports the correct logged in user but obviously the search stops working. How do I get round this problem? Any help would be greatly appreciated. Thanks Andy
View Replies !
How Can I Show A Report From SQL Server Reporting Services Not In Integrated Mode
I've build some reports for SQL Server 2005 Reporting Services, this server is not in SharePoint Integrated Mode. Then I need to show in a web part the reports from this SSRS server. I'm trying to create a new web part that instantiates the ReportViewer object and is added to the SharePoint page, but I'm receiving an error message (Unknown error as SharePoint shows). My code is simple, I just have a property for the report URL and the object. Here it is: ReportViewer rptViewer = new ReportViewer(); rptViewer.ServerReport.ReportServerUrl = new Uri(reportServer); rptViewer.ServerReport.ReportPath = reportPath; rptViewer.ServerReport.Refresh(); this.Controls.Add(rptViewer); Do you suggest anything? How can I show my reports from a standalone SSRS server? Thanks.
View Replies !
Error Installing Notification Services, Integration Services && Workstation Components For SQL Server 2005 Standard
After upgrading from SQL Express to 2005 Standard, installation of Notification Services, Integration Services or Workstation Components results in errors: Error for NS: Failed to install and configure assemblies C:Program FilesMicrosoft SQL Server90NotificationServices9.0.242Binmicrosoft.notificationservices.dll in the COM+ catalog. Error: -2147024893 Error Message: They system cannot find the path specified. Error description: Could not load file or assembly 'System.EnterpriseServices.Wrapper.dll' or one of it's dependencies. The system cannot find the path specified. <Abort><Retry><Ignore> Database Engine, Analysis Services & Reporting Services installed/upgraded fine. Any thoughts/suggestions? Thanks J
View Replies !
RS 2005 SP2 In Sharepoint Integrated Mode
Up until an hour ago, I was using the Sql Server Reporting Services Report Viewer webpart in Sharepoint with forms authentication, and was not having an issue. The only thing that I did (or remember doing) before things went sour was upload a new report to the document list and since then whenever I try to access a report, manage the data source on a report, change the report URL in the webpart, I get the following message: An unexpected error occurred while connecting to the report server. Verify that the report server is available and configured for SharePoint integrated mode. --> The request failed with the error message: -- <html><head><title>Object moved</title></head><body> <h2>Object moved to <a href="/_layouts/login.aspx?ReturnUrl=%2f_vti_bin%2fReportServer%2fReportService2006.asmx">here</a>.</h2> </body></html> --. I found some related posts and have tried the following, but none have helped: Removed all reports and reuploaded only the one that was definitely working. I changed the application pool for the report server to be the same app pool as Sharepoint (runs under domain admin account). I changed the application pool for the report server back to it's original (which the Reporting Services Configuration prefers - was running under Network Service acct before the problem started, now running under domain admin acct) I can browse to http://server/reportserver. I'm running under forms authentication, which had been working. I can access the three configs for Reporting Services under Application Management in Central Admin - I've tried changing the settings. I can access http://server/_vti_bin/reportserver/reportservice2006.asmx as well as http://server/_vti_bin/reportserver/reportserviceauthentication.asmx (that was suggested in one post) I've restarted IIS numerous times, and also finally rebooted the server. I've created a new document list and set it for report content, just like the other list. I also just noticed that even though I've set up my admin account as a site collection administrator, I now no longer see my report options under the New button in the document library (both the old and new). I don't know if this is related. I'm sure that this is a case of something minor that I did that I forgot about. Any suggestions or other troubleshooting that I can do? Thanks! daw
View Replies !
Reporting Services Add-In For SharePoint
I am attempting to set up SharePoint and Reporting Services to run in Integrated mode. I have successfully in stalled MOSS 2007 and Reporting Services. I've installed SP2 for SQL Server and configured Reporting Services to run in Integrated mode. IIS 6 and ASP.Net v2 are also installed on the SharePoint box. For some reason I cannot get the Reportnig Services add on for Sharepoint to install. It gets to the very end of the installation and then performs a rollback. I'm logged on as an Administrator. My user is also a farm administrator. The ONLY error I find in Even Viewer is the generic 11708 "failed to install" error. Has anyone else encountered this? If so, how did you resolve the issue? Thanks!
View Replies !
Reporting Services And Sharepoint
I used a Page Viewer Web part in sharepoint 2.0 to display a reporting services report. I want to hide the reporting services toolbar in the report displaying in the Page Viewer Web part. I used the rc:Toolbar = false statement at the end of the link property in page viewer but still it display the toolbar. Please help Thanks
View Replies !
Reporting Services And Sharepoint
I want to try out some reports in Sharepoint but still be able to continue building and deploying reports for report manager. As far as I can see from the documentation, you can't do both - it's either Sharepoint or Report manager. Any comments?
View Replies !
Reporting Services And SharePoint
I have SQL 2005 Reporting Services running under MOSS (i.e. in a report library). Have created a datasource and use report builder to build a report. When I start a new report I see all the entitities (tables) in the database on the left hand side and I can drag and drop tables. I build a very simple report with 2 columns FirstName and Address and all is OK.... BUT I add the 'Name' column into the report in Report builder, I run the report and I have the following error : An error occurred during rendering of the report. The target location you specified is not supported by the report server. A report definition (.rdl), report model (.smdl), resource, or shared data source (.rsds) file must be located within a library or a folder within it. Any idea ?? Thanks for your help... Patrick
View Replies !
SQL Reporting Services And Sharepoint
I am having problems getting the SQL Report Viewer's title to stick in a sharepoint website. I have a dashboard with multiple SQL Report Viewer web parts. I can only apply the title to a single report viewer web part. When I try to apply a title to another webpart the title's for the remaining SQL Report Viewer parts revert to "Report Viewer #" I am assuming this is a bug ... but I am hopeing there is a work around.
View Replies !
Reporting Services In SharePoint
Hi, We are going to move our reports to SharePoint enviroment. We have report loggan in each report header. Reports will be shown in our intranet which already has loggan in main frame. So the report does not need to show the loggan in the report if they show in our intranet but how we can make it that loggan shows in the report when the report need to print out. Is there any setting in Reporting Services/SharePoint which can dynamically change the setting to show the loggan or not?
View Replies !
|
TRACKER
