Reporting Services Menu Does Not Appear When Install Reporting Service Add-in For SharePoint

May 14, 2008

Hi all,

I have some problem about reporting service add-in.

After I install reporting service add-in for SharePoint, reporting service menu does not appear in Application Management Tab in SharePoint Central Administration.

I try to uninstall and re-install again, it remain not work.

How can I solve this problem?

Thank you very much.

View 4 Replies


ADVERTISEMENT

Reporting Services And SharePoint 2007 Install

Jul 27, 2006

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 5 Replies View Related

Reporting Services :: Where To Install SSRS SharePoint Mode In A Multi-server Environment

Aug 17, 2015

I am setting up sharepoint and sql server integration environment. I am considering the following topology: PowerPivot for SharePoint 2013 and Reporting Services in SharePoint mode Two Server Deployment

[URL]

I am looking to follow the topology example by the letter, which involves installing PowerPivot for SharePoint (aka SSAS in SharePoint mode) in the same server as my SQL, and installing SSRS in SharePoint (SP) integrated mode in the same server as SharePoint.

I understand, however, that if I wanted to install SSRS in SP mode in the same server as SQL, I could but only if the server contains the SP Object Model.

My first question is, what would involve having the SP Object Model in the SQL Server?

Would only installing SP binaries be enough; or Do I need to do a minimal install of SP in the SQL server enough for it to joing the SP farm? And most importantly, what would be the licensing implications for SP in case I want proceed down this route and have SSRS in SharePoint mode installed in the same server as the SQL?

View 4 Replies View Related

Reporting Services And Sharepoint Integration - Sharepoint Alternate Access Mappings (Zones)

Mar 2, 2007

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 22 Replies View Related

Reporting Sharepoint Install Problem

Apr 24, 2008

Hi everybody,

I have installed Reporting in SharePoint Integrated mode on a MOSS 2007 farm (with SP1 (MOSS) and SP2 (SQL Server) installed). When I want to go on the MOSS Administration => Application Management I don't see the RS administration links ...

First, i believed this is due to a problem during the RS add in for Sharepoint install, but it wasn't.

If you try to tape the links of the aspx pages of RS administration in MOSS :

http://<server_name>:<admin_port>/_layouts/ReportServer/ReportServerSiteSettings.aspx
http://<server_name>:<admin_port>/_layouts/ReportServer/ManageTrustedAccounts.aspx

You can access to the admin tools ...

I don't know why the MOSS administration page were not modify during the add in installation but the RS pages works ... : http://<server_name>:<admin_port>/_admin/applications.aspx/_admin/applications.aspx


If someone know what is the origin of this problem ...

PS : To resolve this problem we add two links in the Home pages of the central administration ...

Thanks.

Xavier.

View 1 Replies View Related

Problem For Integrating Sharepoint With Reporting Service

May 16, 2008

Hi there,

I have a problem for integrating sharepoint to reporting service. In my project web access page, when I tried to open a .rdl report, the following error occured:


An unexpected error occurred while connecting to the report server. Verify that the report server is available and configured for SharePoint integrated mode--> Server was unable to process request

Then when I go to the reporting service configuration manager. I saw that in the Server Status tab, the "Initialize" field is "No". And for the Sharepoint Integration tab, there was a blue "!" mark on it.

I read from the web (http://www.helloitsliam.com/archive/2007/10/23/moss2007-€“-reporting-services-add-in-and-configuration.aspx) that if the database setup is ok, then the sharepoint integration will also be ok and the report manager virtual directory will turn gray. However, there is an error when setting up the database. In the task status, "Verifying Database Edition", "Verifying Database Version", "Creating a Grant Rights script for xxxxxxxxxx" and "Assigning Reporting Services Rights to User" were all marked as a green tick. However, there is a yellow "!" for "Setting Connection Info for Reporting Service" and the detailed error is as follows:

ReportServicesConfigUI.WMIProvider.WMIProviderException: The encrypted value for the "LogonCred" configuration setting cannot be decrypted. (rsFailedToDecryptConfigInformation)
at ReportServicesConfigUI.WMIProvider.RSReportServerAdmin.ThrowOnError(ManagementBaseObject mo)
at ReportServicesConfigUI.WMIProvider.RSReportServerAdmin.ListReportServersInDatabase(RSReportServerInfo[]& serverInfos)

Does anyone know how to solve it? Thanks in advance!!


Regards,
Ryan

View 1 Replies View Related

Reporting Service With Sharepoint Performance Issue

Feb 16, 2008

I have an installation of Reporting Services with Sharepoint integration. Most of my reports are Analysis Services reports with MDX queries. These reports are typically with 9-10 parameters.

When I try to pull these query these reports in the sharepoint site, it takes typically 3-5 minutes before the report is rendered. If these reports are queried from BIDS itself, it takes only a couple of seconds. To make things worse, every change of parameters causes the report to re-render and the entire load time has to report itself again, which is unacceptable by any standard.

I suspect this has something to do with the report viewer render time, does anyone have similar experience or is able to advise on how this can be fixed?


Thanks.




View 8 Replies View Related

Configure Reporting Service Not To Work With SharePoint

Jan 30, 2008

Hi there, I have a stupid question
When I want to configure reporting service in a computer it needs Windows SharePoint Service. But When I installed and configured it in my own PC it asked for database server location instead. Anybody have any idea about this?

View 1 Replies View Related

Generating Reports From SharePoint List Using Reporting Service

Feb 29, 2008

Hello Everybody,

I am presently working on a project which handles much larger amount of data. The application demands extensive reporting from the SharePoint data. I'd like to know how I can generate reports from the SharePoint lists using Reporting Services.

Planning to install in SQL Server Integrated mode


Thank you,

Arun

View 6 Replies View Related

Error With Basic Authentication - Reporting Service Add In For Sharepoint

Jun 5, 2007

Maybe someone can help me. I am running the reporting service add in for Sharepoint and we have only Basic Authentication running on our site (it is on SSL). When i try and open a report in sharepoint it errors out on me. When i go back into IIS and set Windows and Basic authentication it works, but it requires me to enter our domain and username. We need to only use Basic so it will not need the domain. Anyone have any suggestions on what i can do to make this work?

View 5 Replies View Related

Slow Respons Time From Reporting Service Over Sharepoint

Jan 29, 2007

I am running SQL 2005 reporting services on a windows 2003 machine with SharePoint over SSL

My reporting services web directories are virtual directories under the SharePoint website.

I am having a problem with loading https://sharepoint.mysite.com/Reports/Pages/Folder.aspx

When you first open IE and bring up the page it takes about 30 seconds to load. Once you have connected via any machine, all other machines can connect at normal speed 1-2 seconds. All testing is being done on our LAN so there is no bandwidth issues when opening the pages.

My guess is that something is going into a sleep mode, but I am not sure where that would be set.

Thanks for any suggestions

Robert

View 6 Replies View Related

SharePoint Server 2007 Integration With Reporting Service 2005

Jan 18, 2007

Hi,

I am working on sharepoint 2007 integration with reporting service 2005. There are few facts which i am trying to understand and need some clarifications. Please provide your comments

1) While configuring "Database setup" in Repoting Service Configuring Manager" i found two modes 1) Native and 2) SharePoint Integration. When creating a report server database if we check "Create the report server database in Sharepoint Integration Mode" then it set the mode to "SharePoint Integration Mode". There is no option of switching the same database to native mode. So i have to create another database in "Native Mode". (IS THIS CORRECT. DO WE NEED TO CREATE TWO REPORT SERVER DATABASE SEPERATE FOR SHAREPOINT INTEGRATION AND NATIVE)

2) I am using the new report viewer web part in sharepoint 2007. When i am in sharepoint integration mode i can create datasource, report model and with report builder i can create rdl file. On selecing any RDL file in doument library and it gets displayed in Report Viewer Web Part. When i switch to Native mode i want to configure the web part to use the report created with SQL Server Bussiness Intelligence Dev Studio and deployed on http://localhost:808/ReportServer. (IS THERE ANY WAY SO THAT I CAN EXPORT AND IMPORT ALL .RDL FILE FROM http://localhost:808/ReportServer to http://localhost/ReportServer)

I AM NOT ABLE TO CONFIGURE WEB PART WHEN I AM IN NATIVE MODE i.e giving path of .RDL in report textbox throw a error saying "Item not found" i tried all combination. THIS can be related to datasource not reading in .RDL file in native mode while confuring report viewer web part.

http://localhost:808/ReportServer (Report Server)

http://localhost/ReportServer (SharePoint Mode) (Default Top Level Site)

3) LAST : I want to create a .RDL file report from the data in sharepoint, say lists or news etc. So when creating a RDL file how can i connect to sharepoint database. I read some where that in previous release they used to DATA EXTENSIONS and get the data from list in sharepoint with something like http://<servername>/<sitename>/List=Announcement when creating RDL file. Is the alternative in new release to create the report based on sharpoint list data.

Thanks and i would really appreciate your help

View 3 Replies View Related

Configuring Reporting Service Add-in For Sharepoint - HTTP Status 401: Unauthorized.

Mar 22, 2007

I have the following setup

Machine 1

WSS 3.0

Installed Reporting Service Add-in

Machine 2

Reporting Service

Sharepoint Object Model

SQL Server

Sharepoint and Report Server DB

I have congigured Reporting Service for Sharepoint Integrated Mode adn Created new Reprot Server DB

Sahre Point Integration is Green and verified link



In Sharepoint Central Administration

Manage Reporting Service Integratio i have selected the URL and "Trusted Account" as my web applications use "Windows Integration - NTLM".



All services, DB access everything running under one domain user account.

I am logged into sharepoint with same account. When clieck on set server defaults i get following error

An unexpected error occurred while connecting to the report server. Verify that the report server is available and configured for SharePoint integrated mode. --> Server was unable to process request. ---> The request failed with HTTP status 401: Unauthorized.



Same error when i try to add a report to a sharepoint webapplication

The domain account is part of "Farm Administration", "site colletion administrato" and local administrator also on both servers.

Can someone let me know how to fix this.

View 15 Replies View Related

SQL 2005 SP2 Reporting Services And Window SharePoint Services V3 Integration Config Issue

Mar 23, 2007

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 5 Replies View Related

Installing Reporting Services For Sharepoint

May 29, 2007

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 3 Replies View Related

Sharepoint Webpart For Reporting Services Viewer

Mar 19, 2007

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 1 Replies View Related

Sharepoint List As Datasource In Reporting Services ?

Oct 25, 2007



Hi everybody,

I was wondering if it's possible to use a sharepoint list as datasource in reporting services ? If yes, what's your trick ?
Is it possible to use a directory as datasource in reporting services ?


Thanks for your response,


Have a nice day,

Aurore

View 3 Replies View Related

Reporting Services / SharePoint Integration Issue

Feb 18, 2008

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 1 Replies View Related

Reporting Services Subscriptions / Sharepoint Question

Jul 18, 2007

I'm trying to create a subscription that places a file (excel or PDF) in sharepoint. I haven't been able to find a path that works. I was wondering if anyone else had had this issue and how they overcame it.


Thanks.

View 1 Replies View Related

Reporting Services/Sharepoint Double Login

Oct 23, 2007

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 1 Replies View Related

Reporting Services :: Integrated Mode With SharePoint?

Nov 21, 2015

I verified logs for reporting services integrated with SharePoint and I found many errors like this:

Cannot find site lookup info for request Uri [URL].

what is wrong with configuration?

View 2 Replies View Related

Reporting Services And Sharepoint Integration Issue

Nov 14, 2007

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 1 Replies View Related

Sharepoint List Reporting Services Extension

Sep 17, 2007

Is Microsoft planning to include reporting services extensionsion for usering Sharepoint lists as datasource in MS SQL Server 2008?
And what about reporting services extension for building semantic model on Sharepoint lists?

-- Thanks,

View 1 Replies View Related

How To Install SQL Reporting Service

Apr 17, 2008

I have already Installed SQL Server management studio express edition in my computer. Now I want to install SQL reporting service.
Can anyone please guide me to how to do that.
Thanks
Kalloo 
 
 

View 1 Replies View Related

SQL Server 2005 Reporting Services Add-in For SharePoint, Installation

Nov 27, 2006

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 6 Replies View Related

Reporting Services Vs SharePoint Integrate Mode (urgent)

Aug 27, 2007

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 6 Replies View Related

SharePoint Reporting Services Integration 'Execution ... Cannot Be Found'

Aug 6, 2007

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 2 Replies View Related

Reporting Services In SharePoint Integration Mode Problems

Jun 30, 2007

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 10 Replies View Related

Reporting Services :: SSRS Reports Not Running Through Sharepoint

Sep 29, 2015

We couldn't get the report through SSRS deployed URL. Ā We found dead locks in SQL DB end.how to proceed further issue resolution.

View 5 Replies View Related

Error Installing Reporting Services Sharepoint Web Part

Feb 20, 2007

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 1 Replies View Related

Prerequisite Not Met, Please Install SQL Reporting Service

Jan 24, 2007

We have SQL 2005 SP1 and SMS SP2 on a W2K server. Each time we try to install DCM 2.0 report engine, we get a prompt:

Prerequsiste not met, please install SQL reporting services

Being new to SQL 2005, it appears that reporting services and Visual Studio both installed with no problems. Have we missed something? Please advise. Thanks.

View 1 Replies View Related

Problems Configuring SQL Reporting Services In SharePoint Integrated Mode

Apr 13, 2008

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 9 Replies View Related

Reporting Services :: How To Get Add-in For SharePoint Version To Sync With SSRS Engine

Oct 23, 2015

I have installed SQL 2012 on my DB Server. The SSRS database version table(s) list the current version as 163. The Version number that's displayed in the Programs and Features for SSRS Add-in for SharePoint (yes, on the db server) is 11.2.5623.0.

On my two SharePoint servers the version number for SSRS Add-in for SharePoint shows 11.2.2058. I have installed SQL Server 2012 Service Pack 2 on all three machines. When the SharePoint box calls into SSRS to render a report I get this error:

The version of the report server database is either in a format that is not valid, or it cannot be read. The found version is '163'. The expected version is '162'. --->

Microsoft.ReportingServices.Library.InvalidReportServerDatabaseException:

The version of the report server database is either in a format that is not valid, or it cannot be read. The found version is '163'. The expected version is '162'.

what else I need to install - and where - to correct this error. What is expecting version '162' and why?

View 2 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved