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 Complete Forum Thread with Replies
Sponsored Links:
Related 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 !
View Related
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 Replies !
View Related
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 !
View Related
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 !
View Related
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 !
View Related
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 !
View Related
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 !
View Related
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 !
View Related
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 !
View Related
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 !
View Related
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 !
View Related
Sharepoint Services 3.0 Can't Connect To Configuration Database
When i try to connected to existing configuration database it's only shows NT AUTHORITYNETWORK SERVICE as my login user for database access , when i type another user , error message " you must specifay the same user account as your farm server you wish to join " how i can change it. please help me how i can change the configuration user and password for my singel farm server Thanks , i fixed it ??
View Replies !
View Related
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 !
View Related
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 !
View Related
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 !
View Related
Error During First Configuration After Installing Reporting Services (SQL Server 2005 Express)
Hi, I have problem during first configuration of Reporting Services from MS SQL 2005 Server Express with Advanced Services SP2. The error occurs when configuring virtual directory (Reporting Services Configuration Manager -> Report Server Virtual Directory). When I try to create new virtual directory I can see following messages: Number of errors: 0 Create Virtual Directory The virtual directory was created and assigned. Changing Secure Connection Level After last message Windows reports that SQL Server 2005 Reporting Configuration Tool has encountered a problem and needs to close (and I can send report to Microsoft). IIS shows that virtual directory under default web site was created. Evenet viewer (application log) shows .NET Framework 2.0 error: EventType clr20r3, P1 rsconfigtool.exe, P2 9.0.3042.0, P3 45cd6ee2, P4 rsconfigtool, P5 9.0.242.0, P6 45cd6ee2, P7 15a, P8 5, P9 system.nullreferenceexception, P10 NIL My environment: MS SQL Reporting Services Version 9.00.3042.00 Windows XP Proffessional SP2 IIS 5.1 all components are fresh new installations. The only additional configuration I've made was adding IWAM_<hostname> as WebServiceAccount, all other configuration is default. Any help would be appreciated. Best regards Slawomir Nasiadka
View Replies !
View Related
Error Received In Sql Server Reporting Services Configuration Tool When Changing Encryption Key.
I've SQL Server Reporting Services 2005 configured on my system, but now I'm NOT Able to start the report server. I get this error on http://<serverurl>/Reports/Home.aspx: The report server cannot decrypt the symmetric key used to access sensitive or encrypted data in a report server database. You must either restore a backup key or delete all encrypted content. Check the documentation for more information. (rsReportServerDisabled) (rsRPCError) Get Online Help The report server cannot decrypt the symmetric key used to access sensitive or encrypted data in a report server database. You must either restore a backup key or delete all encrypted content. Check the documentation for more information. (rsReportServerDisabled) Key not valid for use in specified state. (Exception from HRESULT: 0x8009000B) I don't want to loose any data. Please help me resolving this error. FYI, I've modified the SQL Reporting Services account LogOnAs info, in Properties of "SQL Server Reporting Services (MSSQLSERVER)" Service, in Windows Service Managment. Earlier I had .useraccount as username, I modified it to domainnameuseraccount. And then suddenlt everything broke for reporting server.
View Replies !
View Related
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 !
View Related
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 !
View Related
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 !
View Related
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 !
View Related
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 !
View Related
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 !
View Related
Installing Reporting Services For Sharepoint
Hi my current setup is: Server 1 - Office sharepoint server 2007 Server 2 - SQL Server 2005 with Service Pack 2 and reporting services When I try to install the Reporting Services Add-in for Sharepoint on Server 1, I get an error - "Setup was interrupted" Would you know how to fix it? Thank you
View Replies !
View Related
Reporting Services Sharepoint Add-in Is Timing Out
Hi, I've implemented a Reporting Services web part that is working great for the users in Sharepoint. However, after letting the browser sit idle for an hour or so, they get the following message: "An error has occurred during processing. (rsProcessingAborted) The data source 'MARP' cannot be found. (rsDataSourceNotFound)" I am assuming that the Reporting Services web part somehow stores the connection information in a Session variable, but how can I get around this problem (or give a better message to the user)? Thanks, Mark.
View Replies !
View Related
SQL Express With Advanced Services Reporting Services Security Configuration
Hi, i have a development scenario with various XP Pro (sp2) machines and no network server, the computers are conected by a switch and all computers have static IP addresses, one of the computers have and instance of SQL Exp. W Advances Services and Reporting services installed and working fine. the thing id that i can not access the reporting services from other computers on the network because they always try to log in by the use of the Guest account witch by default is disabled, i realy need other people on the network to validadde the reports that are being developed on thet machine, can some one please tell me how to configure access to then, i don't even need the users to be asked for a password can it be configured for anonymous access?? and if it can. how do i have to configure security settings in reporting services and in IIS?? Please need help fast . Thanx in advance for the help.
View Replies !
View Related
Reporting Services Option GREYED OUT!
Hello All, I have a workstation that had an installation of SQL 2K5 that a tech set up for me. Naturally, it was the wrong edition AND no components were actually installed, making my laptop into a paperweight. I advised that we get SQL Developer for the DBA's and I am trying to install but the option for Reporting Services is greyed out. I have uninstalled SQL (I think it was Standard) and I even went through the "complete uninstall" detailed in one of these threads thinking that was the problem. I am still unable to install Reporting Services. Has anyone run into this problem? PLEASE HELP! thanks!
View Replies !
View Related
Reporting Services Not An Option On Install.
I am running Vista home premium and installing SQL Express Advanced and do not get the reporting service install option during the installation. I got the warning messages during the installation that the IIS is not available but I have the IIS 7 working with all the features enabled. My ASP.NET apps work on the IIS and connect fine to SQL too, just can not seem to get the reporting services.
View Replies !
View Related
Sharepoint Webpart For Reporting Services Viewer
I am using MOSS 2007 and Reporting Services 2005. Integration part worked. But my existing report (analysis service report) with cascading parameter doesn't work in sharepoint. Every time you select a parameter you have click "Apply" to see the the cascading parameter. Is this a bug with report viewer webpart, because this works on regular sql 2005 rs viewer. SharePointHelp
View Replies !
View Related
Deploy Failed In SharePoint Add-in For Reporting Services
Hi all, I am a newbie for SSRS 2005 and have a problem about deployment step. First, I have already configured the reporting services and have also tried to create the report by SSRS. Everything is fine until the deployment of my project. The error is shown as followings: The path of the item '/DS/DSSS2' is not valid. The full path must be less than 260 characters long; other restrictions apply. If the report server is in native mode, the path must start with slash. Deploy failed And, these bellows are my details Full name path : c:mossdata eport eportml eportmlDRPSS2.smdl TargetDatasource : DS Data Source Name : DSSS2 Then, I have come back to the SharePoint portal and found that the data source folder and data model folder are created as my earlier steps (before deployment step). I, therefore, build the report by using Microsoft report builder and adding the built report into my port through the SQL Server Reporting service report viewer. It is fine and shows the result as my design. But I wonder the error warning in deployment step and would like to solve that. I think my full path name is not longer than the 260 characters as above. Have anyone suggest me about this situation for fixing the error? Thank in advance
View Replies !
View Related
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 !
View Related
Reporting Services/Sharepoint Double Login
I have a Reporting Services implementation setup to run in Native mode. Reports on the server are being accessed through a Sharepoint website that has a Report Viewer control. This is posing a problem because after the user logs into Sharepoint, they are again prompted to login to the report server. Is there a way to pass the users Sharepoint credentials to the report server to prevent this double login prompt? Thanks in advance for your help!!!
View Replies !
View Related
Reporting Services And SharePoint 2007 Install
I'm trying to install SharePoint 2007 and Reporting Services 2005 on the same server. However after installation Reporting Services will not load at http://localhost/Reports. Instead I get the following error: Server Error in '/Reports' Application. Configuration Error Description: An error occurred during the processing of a configuration file required to service this request. Please review the specific error details below and modify your configuration file appropriately. Parser Error Message: Cannot use 'partitionResolver' unless the mode is 'StateServer' or 'SQLServer'. Source Error: Line 164: </webParts> Line 165: <machineKey validationKey="DA65D9E6980E9CDB52426BF3C793EBAF7FBA3B866117F3CC" decryptionKey="9D7E984E12AA43FDECAB1E05D1E952822680D27BD1F37439" validation="SHA1" /> Line 166: <sessionState mode="SQLServer" timeout="60" allowCustomSqlDatabase="true" partitionResolverType="Microsoft.Office.Server.Administration.SqlSessionStateResolver, Microsoft.Office.Server, Version=12.0.0.0, Culture=neutral, PublicKeyToken=71e9bce111e9429c" /> Line 167: </system.web> Line 168: <runtime> Source File: C:InetpubwwwrootwssVirtualDirectoriesc76013d9-5b44-4d06-96dd-24fede1ea955web.config Line: 166 Version Information: Microsoft .NET Framework Version:2.0.50727.42; ASP.NET Version:2.0.50727.42 I assume that something is wrong with my virtual server set up. I have the Default Web Site stopped and SharePoint (80) running and set Reports and ReportServer using the Report Configuration to SharePoint (80). I can get to http://localhost/ReportServer but I get this error when running a report from there: Reporting Services Error An internal error occurred on the report server. See the error log for more details. (rsInternalError) Get Online Help The type Microsoft.SharePoint.Portal.Analytics.UI.ReportViewerMessages, Microsoft.SharePoint.Portal, Version=12.0.0.0, Culture=neutral, PublicKeyToken=71e9bce111e9429c does not implement IReportViewerMessages or could not be found Has anyone set these up on the same server? Is there a document around on how to set this up? Thanks Kevin
View Replies !
View Related
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 !
View Related
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 !
View Related
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 !
View Related
Error Installing Reporting Services Add-In For SharePoint Technologies
Hi, I have configured Report Server with SharePoint Integration mode and the Report Server database is on remote database server. Remote server has SQL Server 2005 Enterprise Edition. When I install the Report Server Add-in for sharepoint technologies, it shows the screen "Removing Backup files" and then rollbacks from that point. Message displayed "Installation was interrupted". System configuration where Reporting Server Add-In is getting installed: Windows 2003 Server + SP1 SQL Server Express Edition Report Server configured with SharePoint Integration Mode. Please update if anyone have any idea on the above mentioned issue. Idea is to use the sharepoint and reporting services in integrated mode. Thank you, Hiral
View Replies !
View Related
Error Installing Reporting Services Sharepoint Web Part
HI, I have downloaded and was trying to install the Reporting Services Sharepoint web part. As mentioned in the installation instructions I have uninstalled the previous version and then started the install. After starting to install the installation Rolls back and fails. I have checked the logs and i get the error The web configration file, C:Program FilesCommon FilesMicrosoft SharedWeb Server Extensions12configwebconfig.dlc.xml, does not have element "configuration/configSections/sectionGroup[@name='SharePoint']" or it is invalid. Install error: C:Program FilesCommon FilesMicrosoft SharedWeb Server Extensions12instsadm.exe return error code: -1 Any suggestions/ help to resolve the problem would be most welcome. Thanks in advance PMN
View Replies !
View Related
Deploying Reporting Services In An Extranet Sharepoint Site
Hi Everyone, I'd like to know who has experience in deploying reporting services reports in an Extranet Sharepoint Site. I've read some articles on it, and it says its doable. I was hoping I can get some responses in here to see how to go about doing such thing. - what first few considerations do i need to have? - setting up the environment - more importantly, security considerations since the windows authentication that is normally used won't work in an extranet environment. I am guessing that a few groups need to be created on this with only certain access allowed for each (browser capability, content management...etc) Any input would greatly help. Please enlighten me, thank you Angelie
View Replies !
View Related
Error Trying To Install Reporting Services Add-in For Sharepoint 2007
I have a 64 bit version of sharepoint 2007, when I try to install the 64bit version og Reporting Services add-in for Sharepoint the install fails. In the event log I find the following. How do I solve this. Event Type: Error Event Source: Office SharePoint Server Event Category: Office Server Shared Services Event ID: 7076 Date: 10/24/2007 Time: 3:41:44 PM User: N/A Computer: LATSPS1X Description: An exception occurred while executing the Application Server Administration job. Message: Attempted to read or write protected memory. This is often an indication that other memory is corrupt. Techinal Support Details: System.AccessViolationException: Attempted to read or write protected memory. This is often an indication that other memory is corrupt. at System.DirectoryServices.Interop.UnsafeNativeMethods.IntADsOpenObject(String path, String userName, String password, Int32 flags, Guid& iid, Object& ppObject) at System.DirectoryServices.Interop.UnsafeNativeMethods.ADsOpenObject(String path, String userName, String password, Int32 flags, Guid& iid, Object& ppObject) at System.DirectoryServices.DirectoryEntry.Bind(Boolean throwIfFail) at System.DirectoryServices.DirectoryEntry.Bind() at System.DirectoryServices.DirectoryEntry.get_IsContainer() at System.DirectoryServices.DirectoryEntries.CheckIsContainer() at System.DirectoryServices.DirectoryEntries.Find(String name, String schemaClassName) at Microsoft.SharePoint.Metabase.MetabaseObjectCollection`1.Find(String name) at Microsoft.SharePoint.Metabase.MetabaseObjectCollection`1.get_Item(String name) at Microsoft.SharePoint.Administration.SPProvisioningAssistant.ProvisionIisApplicationPool(String name, ApplicationPoolIdentityType identityType, String userName, SecureString password, TimeSpan idleTimeout, TimeSpan periodicRestartTime) at Microsoft.SharePoint.Administration.SPMetabaseManager.ProvisionIisApplicationPool(String name, Int32 identityType, String userName, SecureString password, TimeSpan idleTimeout, TimeSpan periodicRestartTime) at Microsoft.Office.Server.Administration.SharedWebServiceInstance.CreateSharedWebServiceApplicationPool(SharedResourceProvider srp) at Microsoft.Office.Server.Administration.ApplicationServerJob.ProvisionLocalSharedServiceInstances(Boolean isAdministrationServiceJob) For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.
View Replies !
View Related
Print Option Causes System Restart (Reporting Services 2000)
We are using Reporting Services 2000. The print button that is present in the browser is working just fine for some users. But some users are complaining that on clicking the print button their system restarts. Some other users are also getting the error "An error occurred during printing. (0x80004005)" However on closing the browser and opening the report in it again this issue is resolved. So, the main concern is "Restart of the machine on click of the PRINT icon in reports viewed in some application browser." Please help!!
View Replies !
View Related
Problem Configuring Reporting Services For Sharepoint Report Viewer Web Part
When configuring the Reporting Services Integration for sharepoint Report Viewer I get some wierd errors. In Reporting Services > Central Administration - Configure Reporting Services Integration - Grant Database Access: When clicking [Ok] and type the admin username & password I get the error "Report Server WMI Provider error: Not found". I've followed the installation guide and the log shows no errors in the installation or the configuration.
View Replies !
View Related
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 !
View Related
Configuration Of Reporting Services
obviously until I get this sorted I cannot deploy my reports in my Reporting Services Configuration All ticked except initialisation (3) in Database services ticked but on the right hand side there are warnings/errors Verifying Database Edition - ticked Verifying Database Version - warning The current connection string is not valid and can't be used to connect to SQL Server Where do I check this? (1) Creating A Grant Rights script for LocalSystem = ticked Assigning Reporting Services Rights to User = error (2) System.Data.SqlClient.SqlException: The role 'RSExecRole' does not exist in the current database. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at Microsoft.ReportingServices.Common.DBUtils.ApplyScript(String connectionString, String script) at ReportServicesConfigUI.SqlClientTools.SqlTools.ApplyScript(String connectionString, String script) Can someone tell me what I should be checking please? thanks
View Replies !
View Related
|
TRACKER
