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


ADVERTISEMENT

The Request Failed With HTTP Status 401: Unauthorized. - SQL Reporting Services

Jan 30, 2006

Hi,

I have deployed the reports to the report server(centralized server). when i try to access the reports directly thru report server i.e http://servername//ReportServer in my local system. it asks for the username/password, when i give the username and password it accepts and shows me the report.

the same report i try to access in .NET Application, i do not know how to pass the credentials and it throws the error :"The request failed with HTTP status 401: Unauthorized ".

I am using VS 2005 and SQL Server 2005 and SQL Reporting Services 2005.

with regards

Suresh Babu


 

 

 

View 7 Replies View Related

Reporting Services :: Request Failed With HTTP Status 401 - Unauthorized (ReportViewer Control)

Mar 12, 2013

We are using SharePoint 2010 integrated with Reporting Services 2008 R2. We have successfully configured RS and we are able to create RDL reports using Report Builder from the SharePoint site.

However we are getting following error message when we host same RDL report using Report Viewer control in an application page i.e. ASPX page:

<ERROR>The request failed with HTTP status 401: Unauthorized</ERROR>

We can fix this issue by setting:

1) setting impersonation to false in web.config file:

<identity impersonate="false" />

2) Setting Report server URL to _vti_bin path:

rptViewer.ServerReport.ReportServerUrl = new Uri("http://sharepointserver:1000/_vti_bin/reportserver");

If we turn impersonation to true we get the same error. Other project module requires impersonation to be enabled. Hence we cannot proceed further with this work around/fix.

View 2 Replies View Related

The Request Failed With HTTP Status 401: Unauthorized.

Sep 14, 2006

Other postings I know have asked about this error message, but none has quite been my particular experience.



Using Visual Studio 2005 I have developed an aspx (.NET 2.0) web page, which has embedded in it, a Report Viewer object. Clicking a button calls the Reporting Services report and populates the Report Viewer object. This web-page works fine when run from Visual Studio.

Once deployed to the Web Server however, the web page produces the 401 error message.

I can also run the report fine, when running it directly from the Reporting Services Report Manager, so I know I have the proper permissions on RS itself - it fails only when I try calling the report from the ASP page.

Any help greatly appreciated.

Thanks,

Mike.

View 6 Replies View Related

The Request Failed With HTTP Status 401: Unauthorized.

Mar 16, 2007

Microsoft.Reporting.WebForms.ReportParameter[] RptParameters = new Microsoft.Reporting.WebForms.ReportParameter[3];

RptParameters[0] = new Microsoft.Reporting.WebForms.ReportParameter("spec_id", "24058");

RptParameters[1] = new Microsoft.Reporting.WebForms.ReportParameter("Meas_Details_id", "30");

RptParameters[2] = new Microsoft.Reporting.WebForms.ReportParameter("MeasID", "3");

this.ReportViewer1.ServerReport.SetParameters(RptParameters);

when am trying to run this code it is throwing this exception

The request failed with HTTP status 401: Unauthorized.

Can anyone pls help me on this

Thanks.

View 1 Replies View Related

The Request Failed With HTTP Status 401: Unauthorized.

Jan 23, 2008

Hello All,

I am getting the mentioned error: The request failed with HTTP status 401: Unauthorized, when i tried to call ReportingService2005 reference in my IIS web project.

Below is my code:

string strReport;

string strRptUrl;

string strFormat;

string strFormatCode;

ReportingService2005 rs = new ReportingService2005();

// Pass Windows Authentication credentials to Web Service

rs.Credentials = System.Net.CredentialCache.DefaultCredentials;

// Call ListChildren method to get array of reports

CatalogItem[] itmReports = rs.ListChildren(strFolder, false);

foreach (CatalogItem itm in itmReports)

{

// ListChildren returns reports, subfolders, data sources, etc.

// so we need to filer for reports only

if (itm.Type == ItemTypeEnum.Report)

{

// Use description if it exists, otherwise fallback to name

if (itm.Description != null && itm.Description.Length > 0)

{

strReport = itm.Description;

}

else

{

strReport = itm.Name;

}

strRptUrl = itm.Name;

TemplateDropDown.Items.Add(new ListItem(strReport, strRptUrl));

}

}

}

catch (Exception ex)

{

throw ex;

}

Did i missed anything. Please assist me.

Thanks in advance.

View 2 Replies View Related

The Request Failed With HTTP Status 401: Unauthorized .

Sep 20, 2007



Hi,

I have deployed the reports to the report server(centralized server). when i try to access the reports directly thru report server i.e http://servername//ReportServer in my local system. it asks for the username/password, when i give the username and password it accepts and shows me the report.


the same report i try to access in .NET Application, i do not know how to pass the credentials and it throws the error :"The request failed with HTTP status 401: Unauthorized ".

I am using VS 2005 and SQL Server 2005 and SQL Reporting Services 2005.

with regards

View 4 Replies View Related

The Request Failed With HTTP Status 401: Unauthorized

Mar 18, 2008



Hi,

I am using report viewer in my asp.net application When i try to access the reportserver page in my application i get this error
The request failed with HTTP status 401: Unauthorized

My webserver and the Sql server are in different computers.. The Report Server is been installed in the Webserver but in the database set up its talking to the sql server computer.. I have tried giving credentials in the webconfig file but i get the above error..

any help will appreciated.

Regards,
Karen

View 9 Replies View Related

The Request Failed With HTTP Status 401: Unauthorized. ReportingService2005

Jul 21, 2006

I have programmatically deploy SQL server Reporting Services 2005 reports via msi file. The installation was success, I was able to run the reports on localhostReports at the target machine. But I get error "The request failed with HTTP status 401: Unauthorized." when I try to access it from the ASP.NET app report menu in the target machine.

It is Windows Server 2003 standard edition, it uses Windows Authentication. I have tried setting any combination below and still doesn't work. Anybody has any other ideas?

ReportingService2005 rs = new ReportingService2005();

rs.UseDefaultCredentials = true;
rs.PreAuthenticate = true;
rs.Credentials = System.Net.CredentialCache.DefaultCredentials; or
rs.Credentials = new System.Net.NetworkCredential("Admin", "psw");

View 5 Replies View Related

The Request Failed With HTTP Status 401: Unauthorized. - ReportingService2005 Webservice

Dec 11, 2007


Hello, I am trying to schedule a report using the ReportingService2005 web service. It works in my local machine, but as soon as I deploy my web app to a server I get this exception:

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 ReportService.ReportingService2005.GetSubscriptionProperties(String SubscriptionID, ExtensionSettings& ExtensionSettings, String& Description, ActiveState& Active, String& Status, String& EventType, String& MatchData, ParameterValue[]& Parameters)
at ReportScheduling.SaveSubscription(String SubscriptionID, String ReportName, Int32 ReportID)
at ReportScheduling.ScheduleReport()

I see that a lot of people are having the same problem but no solutions are given, Answers like "use the default credentials" . Or "pass a user name and a password" are not doing anything. This has got to be a machine setting. Can anyone share the specific fix? Sad that this is not in Microsoft's standard documentation or MSDN. Very frustating.


View 4 Replies View Related

The Request Failed With HTTP Status 401: Unauthorized. - ReportService2005.asmx

Mar 9, 2006

I have a report server set up to use SSL and Basic authentication. I am trying to create an application that uses the ReportService2005 web service. I can add the web reference ok, but when I try to use it to list reports, I get the "The request failed with HTTP status 401: Unauthorized." error.

What steps do I need to take to get the authentication to work correctly? I have kerberos configured for the server, although I don't think that would matter here.

pjp

View 7 Replies View Related

The Request Failed With HTTP Status 401: Unauthorized SQl Server Reports

Sep 4, 2007

I am using SQL Server Reporting. All reports are deployed on REPORTING SERVER.
I want to implement security roles as same as in Active directory. Currently reports are being accessed using Anonymous user setting in IIS.
I have added users in SQL Server security as well as data base level. But when user accesses report following error occurs:
The request failed with HTTP status 401: Unauthorized

Please reply with solution as soon as possible. I will be very thankful to you

View 1 Replies View Related

Moving ReportServer : The Request Failed With HTTP Status 401: Unauthorized

Dec 5, 2007

Hi,
I am in the process of moving reportserver and reportmanager from one server to another due to upgrade. SQL Server remains in the same place.
I am getting the above error when trying to conenct to my reportmanger
https://reportshare.thegmcgroup.local/reports
I have SSL set up using SELFSSL.exe
I can access the lisy of report vis
https://reportshare.thegmcgroup.local/reportserver
BUT get the error when trying the previous URL

Any ideas?

SQL Server 2005
Windows 2003 Server
All SP added and up to date.

View 3 Replies View Related

The Request Failed With HTTP Status 401: Unauthorized. (Microsoft.SqlServer.Management.UI.RSClient)

Dec 21, 2006

I know that another thread dealt with this error message before but after trying all the suggestions of that thread without success, I thought my problem may be different.

I have SSRS 2005 installed on my local machine (TAH112) and it worked flawlessly for months. Suddenly it stopped working today. The Reporting Services Configuration tool shows everything is normal (green buttons all the way except for encryption keys button that is blue and Execution Account button that is yellow).

When I try to connect to the server with SSMS, I got the following error:

TITLE: Connect to Server
------------------------------

Cannot connect to http://tah112/reportserver.

------------------------------
ADDITIONAL INFORMATION:

The request failed with HTTP status 401: Unauthorized. (Microsoft.SqlServer.Management.UI.RSClient)

------------------------------
BUTTONS:

OK
------------------------------


I cannot connect to the reports from a browser either (locally or remotely).

Could anyone offer some clue to fix this?

Thanks,











View 7 Replies View Related

Report Viewer In ASPX Page- Getting An Error The Request Failed With HTTP Status 401: Unauthorized

Nov 2, 2006

I used the following reference code while creating this simple ASPX page with reportviewer control using VS 2005

http://www.tutorialsall.com/REPORTINGSVCS/WebFormsReportViewer-ReportServerCredentials/

ReportViewer is having following properties

ProcessingMode = "Remote",

ReportServerUrl = "/foldername/myreport

ReportPath = "http://report.mydomain.com/reports"

Even after using admin user we got the same problem

Please help









View 9 Replies View Related

HTTP: 401 Unauthorized When Trying To Use Reporting Services And MOSS2007 In Integrated Mode

Feb 28, 2007

Sorry for the long post, but I'm trying to include as much info as possible.

I'm having trouble getting SQL Server 2005 Reporting Services and MOSS 2007 working together in integrated mode. Everything seems to be ok, but we get a 'HTTP 401 Unauthorized' error when using the 'Set server defaults' link from MOSS 2007 Central Administration. None of the other links give this error, but I'm not sure whether MOSS just eats the error message...

Here's the background:
Sql Server 2005 is installed on a separate box, let's call it SERVER1. This Sql Server hosts both the MOSS content database as well as the reporting services database.MOSS 2007 is installed on a different box, let's call it SERVER2I've installed all the required components for both boxes with no installation errorsSSRS seems to be running fine on SERVER1. Report Manager can be used directly with a browser in native mode.SSRS also *seems* to be running fine in Integrated mode, i.e. I can create a reporting database for integrated mode:
The url http://host/ReportService/ReportService2006.asmx responds normally when I access it through browser using my domain credentialsThe url http://host/Reports/ returns a message saying that I can't access it in integrated mode, which, I take, is normal
MOSS is running ok on SERVER2
I can see that SERVER1 is in the same farm after I've installed WSS3.0 on SERVER1Also I can see the "Reporting Services" section in Central Administration
So all in all, everything seems to be ok. However, when I try to use the 'Set server defaults' link from MOSS Central Administration I get an 'HTTP 401 Unauthorized' error. I'm assuming clicking this link will result in MOSS calling the Reporting Services' SOAP endpoint ReportService2006.asmx which now seems to be the culprit. Here's why I think so:

Whenever this occurs, the IIS logs on SERVER2 show that someone from SERVER1 is indeed trying to connect to ReportService2006.asmx, but I'm not seeing any user credentials being passed (whenever I access the asmx through my web browser, the credentials I entered in the browser are recorded in the log). Furthermore, the Event Viewer on SERVER2 shows Audit Failure (code 529) events occurring every time I get the HTTP 401 error.

The Event viewer's message is as follows:

Logon Failure: Reason: Unknown user name or bad password User Name: Domain: Logon Type: 3 Logon Process: Kerberos Authentication Package: Kerberos Workstation Name: - Caller User Name: - Caller Domain: - Caller Logon ID: - Caller Process ID: - Transited Services: - Source Network Address: <SERVER1 IP> Source Port: <PORT>
From the Event Viewer message and the IIS log it would seem like my MOSS is trying anonymous access whenever it tries to access the SSRS SOAP endpoint, which of course results in a 401, since anonymous access is not allowed. Please note that if I enable anonymous access in the Reporting Services' virtual directories (just for testing), I get a different error. This indicates that the HTTP 401 indeed originates from this particular web service call.

I've heard that SPS2003 and Reporting Services don't like each other on the same box, but this is hearsay. Does anyone know if this is a confirmed fact? This box does have SPS2003 and SSRS2005 installed. I tried to uninstall the SPS2003 but that didn't help anymore.

I noticed someone having similar issues in another thread, but I
didn't see resolutions. I'm pretty baffled as to whether
this is a problem with the MOSS Add-in or the Reporting Services
installation.

Any input on this issue is very much appreciated. I'll try to also include a follow-up if we're able to get this working ourselves.

View 20 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

Problem Configuring Reporting Service

May 29, 2007

Hey there,



im having a problem that a few people seemed to have had already. The problem is again related to the Web Service Identity.



Windows Server 2000, IIS 5.0, SQL Server Express 2005 Adv, and Microsoft.Net 2.0



after installing SQL Server Express 2005 when i launch the Reporting Service Configuration it could not connect to the Server as the Reporting Service was not running.



In order to get the Reporting Service running i had to modify the rsreportserver.config file in the C:Program FilesMicrosoft SQL ServerMSSQL.2Reporting ServicesReportServer directory. Here i modified the added the following

<WebServiceAccount>IWAM_SKYREV</WebServiceAccount>

this was due to no SKYREVASPNET account being available on the server machine. (based on this article http://support.microsoft.com/default.aspx/kb/911846)



Once i changed this i could now get the Reporting Service running and access the configuration tool.



So now we come to my current problem. In the Web Service Identity it shows an exclamation. Here the ASP.net as SKYREVASPNET and when i attempt to apply this i get the following error:



ReportServicesConfigUI.WMIProvider.WMIProviderException: The account name is not valid. Specify an account in the form domainalias.


at ReportServicesConfigUI.WMIProvider.RSReportServerAdmin.SetWebServiceIdentity(String applicationPool)





Any one have any ideas for me...



View 1 Replies View Related

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

HTTP ERROR 401.1 - Unauthorized

Jun 2, 2005

Hi

View 10 Replies View Related

HTTP: 401 Unauthorized When Request Own Report

Mar 21, 2007

Hallo,

after upload a report in a root directory I cannot open this report.

details:

- iis is configured for integreted windows authentification

- windows user und reporter are the same

- user have all rigths for the root directory

View 11 Replies View Related

VS2005 ReportViewer HTTP ERROR 401 Unauthorized

Feb 9, 2006

Hi, can anyone help with this pls - it's getting very fustrating! there seems to be some messages and text on this issue (looks like a common problem that MS haven't published anything about yet!) but nothing I could make heads or tails off... so any help here would be very useful!

I'm using VS2005 (release, NOT beta), the new reportviewer web control and an ASP.NET page - really basic, nothing fancy. I've set the reportviewer properties to:

ReportServerURL= http://mytestserver/reportserver

ReportPath = /AdventureWorks Sample Reports/Company Sales

I'm testing the ASP.NET page is on my local machine - and the reportviewer is connecting to a remote test server (W2k3 SP1). When I view the page, then I get

HTTP ERROR 401 Unauthorized

Directory Security on the report server is Windows Authentication - W2K3 with SP1 and Reporting Services 2005 (release, NOT beta)

Directory Security on my local machine is Windows Authentication - XP SP2 and VS2005 (release, NOT beta)

Any ideas pls?



View 5 Replies View Related

Reporting Services :: How To Enable HTTP For Existing SSRS Service With HTTPs

May 19, 2015

How to enable http for SSRS service in my current sharepoint 2013 environment with https.

this is needed as we have a limitation in SSAS: We cannot specify HTTPS in the Analysis Services Report Action.

View 3 Replies View Related

HTTP Error 401.2 - Unauthorized: Access Is Denied Due To Server Configuration.

May 11, 2007

I am using .net 2005 as front end and Sql Server 2005 as backend, as i face the problem on client side when i installed my software it works properly but after some time i face this error "HTTP Error 401.2 - Unauthorized: Access is denied due to server configuration.
Internet Information Services (IIS)" Also some time it shows me all records. Some time it disconnect the database connection so i can not understand why it happens like this, if somebody know then please help me out this bug.

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

Status 401: Unauthorized. (Microsoft.SqlServer.Management.UI.RSClient)

Apr 30, 2008

We are in the process of setting up a test server for reporting services in which the reporting server is on a seperate IIS server as the SQL Database. I was able to resolve a previous error I was receiving when connecting to reporting services using SQL server management studio and within SQL Surface Area Configuration (HTTP Status 404: Not Found. ((Microsoft.SqlServer.Management.UI.RSClient)) by editing the URLRoot in the rsreportserver.config file. But now whenever we try to connect using SQL Management Tool from other than on the server we receive this new error:

TITLE: Connect to Server
------------------------------

------------------------------
ADDITIONAL INFORMATION:
The request failed with HTTP status 401: Unauthorized. (Microsoft.SqlServer.Management.UI.RSClient)
------------------------------
BUTTONS:
OK
------------------------------


Any Thoughts?

View 1 Replies View Related

Change Reporting Services Default URL (From Http://server/reports To Http://CompanyReports)

Jul 31, 2007

I looked online and couldn't find anything to help me make this change. I want to change the default URL for reporting services to another url. Is this possible? Any assistance would be greatly appreciated.

View 3 Replies View Related







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