Tracking Forums, Newsgroups, Maling Lists
Home Scripts Tutorials Tracker Forums
  Advanced Search
  HOME    TRACKER    MS SQL Server






SuperbHosting.net & Arvixe.com have generously sponsored dedicated servers and web hosting to ensure a reliable and scalable dedicated hosting solution for BigResource.com.







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


 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 Complete Forum Thread with Replies
Sponsored Links:

Related Messages:
The Request Failed With HTTP Status 401: Unauthorized.
Dear MSDN!
 
We are trying to get Reporting Services working. But we get following error:
 

The request failed with HTTP status 401: Unauthorized.





I think i have tried it all:
-Allowed .net forms klient "Trust for delegation"


-Explicit set

Me.ReportViewer1.ServerReport.ReportServerCredentials.ImpersonationUser



-EnableNegotiate=true





Environment:
=========
Server:
ReportingServer 2005 on a 2003 sp1.




Client:
====


2003 sp1
xp sp2


Report:
=====


A simple report that shows one column from a database.
Datasource with hard coded user and password. (Credentials stored securely in the report server)


Application:

=======
VB.NET 2005 forms appliaction with ReportViewer control. Server Report.


Code sample:


=========
Me.ReportViewer1.ServerReport.ReportServerCredentials.ImpersonationUser = System.Security.Principal.WindowsIdentity.GetCurrent
ReportViewer1.ServerReport.ReportServerUrl = New Uri("http://reportserver.mycompany.se/ReportServer")
ReportViewer1.ServerReport.ReportPath = "/ReportCurrency/Report1"
Me.ReportViewer1.RefreshReport()

User:

===

The test user is domain admin.




Reporting Services configuration:

=====================

Report Server Virtual Directory Settings:
-Website=Default Web Site and DefaultAppool.



Report Manager Virtual Directory Settings:
-Website=Default Web Site and  ReportServerAppPool (Identity CLASOHLSONSQLReportingService)


Windows Service Identity:
-Service Accout=mydomainSQLReportUser Windows Account.

Web Service Identity:



-ASP.NET Service Account=mydomainSQLReportUser
-Report Server=ReportServer
-Report Manager=DefaultAppPool







Eventviewer Security Error:

==================






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: 10.200.1.74

Source Port: 1171

Thanks in advance!

View Replies !   View Related
The Request Failed With HTTP Status 401: Unauthorized.
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 Replies !   View Related
The Request Failed With HTTP Status 401: Unauthorized.
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 Replies !   View Related
The Request Failed With HTTP Status 401: Unauthorized
 

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 Replies !   View Related
The Request Failed With HTTP Status 401: Unauthorized.
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 Replies !   View Related
The Request Failed With HTTP Status 401: Unauthorized. ReportingService2005
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 Replies !   View Related
The Request Failed With HTTP Status 401: Unauthorized &&".
 

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 Replies !   View Related
Moving ReportServer : The Request Failed With HTTP Status 401: Unauthorized
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 Replies !   View Related
The Request Failed With HTTP Status 401: Unauthorized. - ReportingService2005 Webservice
 
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 Replies !   View Related
The Request Failed With HTTP Status 401: Unauthorized. - ReportService2005.asmx
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 Replies !   View Related
The Request Failed With HTTP Status 401: Unauthorized. (Microsoft.SqlServer.Management.UI.RSClient)
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 Replies !   View Related
&&"The Request Failed With HTTP Status 401: Unauthorized&&" SQl Server Reports
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 Replies !   View Related
&&"The Request Failed With HTTP Status 401: Unauthorized.&&" - SQL Reporting Services
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 Replies !   View Related
Getting Exception &&"The Request Failed With HTTP Status 401: Unauthorized.&&"
I am trying to run my report in report viewer in window forms. I am getting this exception at runtime
The request failed with HTTP status 401: Unauthorized.
I have found that I need to implement

IReportServerCredentials

interface. I don't know how exactly it will works in VB.NET.
 
Any Idea about it?
 
Thanks,
 
Somay

View Replies !   View Related
The Request Failed With HTTP Status 400: Bad Request. (Microsoft.SqlServer.Management.UI.RSClient)
I get this error message when I try to connect to Reporting Services via the Management Studio.
 
I can see my machine listed in the Server Name > Browse For More > Local Servers dialogue. But no luck,
 
Ive tried:
 
Servername: localhost
Servername: DED1774 (the machine name)
Servername: localhost/reportserver
Servername: DED1774/reportserver
Servername: http://ded1774/reportserver (from the rsreportserver.config file

<UrlRoot>http://ded1774/reportserver</UrlRoot>)

 

I've Googled the error message and found postings for solutions, but none of these helped. Can anyone suggest some simple steps I can take to try to find the issue and get the connection working?
 
Thanks

View Replies !   View Related
HTTP: 401 Unauthorized When Request Own Report
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 Replies !   View Related
The Request Failed With HTTP Status 400: Bad Request - Reporting Services
hi all

recently i configured report server, but when i hot URL i am getting message as
The request failed with HTTP status 400: Bad Request
when i look in event logs i found as :Report Server (MSSQLSERVER) cannot connect to the report server database.:

Windows service accoutn (Sql reporting services) running on a Domain account,
webservice account is running on NT authorityNetworkservice, do i need to change this web service account to machineaspnet account ? if so how can i change this

And also Intialization tab is disabled in Reporting configuration tool? why i am seeing this as disabled.
Appreciate your help guys !! its urgent

View Replies !   View Related
Intermittant Error: Http Status 401 Unauthorized
We have two users that were recieving error:http status 401 unauthorized. Unable to load Reporting Services Reports. Unable to call report server. They got the error two days ago. Yesterday evening they had no problem. And now today they are getting the error again. Any suggestions?

View Replies !   View Related
The Request Failed With HTTP Status 405: Method Not Allowed.
"The request failed with HTTP status 405: Method Not Allowed"
That Error i have all the time i connect my Windows Server Sp1, MSSQL,IIS 6.0 computer
by adress http://localhost/Reports
when i`m trying to access the ReportServer by http://localhost/ReportServer it give me blank page with :
localhost/ReportServer - /




Microsoft SQL Server Reporting Services Version 9.00.2047.00
 
I don`t know what to do.... i try ALL, Giving Privileges to all user, Starting Report Server Service under Administrator,
Giving Privileges in DCOM utility in Event Viewer.... not any errors ALL services are working IIS Working i can connect to Web Sites which are under IIS,i tryed change Pool Identety==usless i spend 2 week trying to solve it
That error killing me pleace could any one help me.... pleace send an email :/ any advice ;(
in Reporting Services Log is only one message:



Code Block
w3wp!ui!1!11/6/2007-19:25:23:: e ERROR: The request failed with HTTP status 405: Method Not Allowed.
w3wp!ui!1!11/6/2007-19:25:24:: e ERROR: HTTP status code --> 500
-------Details--------
System.Net.WebException: The request failed with HTTP status 405: Method Not Allowed.
   at Microsoft.SqlServer.ReportingServices2005.RSConnection.GetSecureMethods()
   at Microsoft.ReportingServices.UI.Global.RSWebServiceWrapper.GetSecureMethods()
   at Microsoft.SqlServer.ReportingServices2005.RSConnection.IsSecureMethod(String methodname)
   at Microsoft.SqlServer.ReportingServices2005.RSConnection.ValidateConnection()
   at Microsoft.ReportingServices.UI.ReportingPage.EnsureHttpsLevel(HttpsLevel level)
   at Microsoft.ReportingServices.UI.ReportingPage.ReportingPage_Init(Object sender, EventArgs args)
   at System.EventHandler.Invoke(Object sender, EventArgs e)
   at System.Web.UI.Control.OnInit(EventArgs e)
   at System.Web.UI.Page.OnInit(EventArgs e)
   at System.Web.UI.Control.InitRecursive(Control namingContainer)
   at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)
w3wp!ui!1!11/6/2007-19:25:25:: e ERROR: Exception in ShowErrorPage: System.Threading.ThreadAbortException: Thread was being aborted.
   at System.Threading.Thread.AbortInternal()
   at System.Threading.Thread.Abort(Object stateInfo)
   at System.Web.HttpResponse.End()
   at System.Web.HttpServerUtility.Transfer(String path, Boolean preserveForm)
   at Microsoft.ReportingServices.UI.ReportingPage.ShowErrorPage(String errMsg) at    at System.Threading.Thread.AbortInternal()
   at System.Threading.Thread.Abort(Object stateInfo)
   at System.Web.HttpResponse.End()
   at System.Web.HttpServerUtility.Transfer(String path, Boolean preserveForm)
   at Microsoft.ReportingServices.UI.ReportingPage.ShowErrorPage(String errMsg)
 
 



One of my MSSQL instances show me : The report server is not responding. Verify that the report server is running and can be accessed from this computer.
But all services are working
 

View Replies !   View Related
The Request Failed With Http Status 401 In Reporting Services 2005
I get the title error message when running a report in reporting services (not when going in to edit for report name etc). I'm trying to obtain statistics from the ReportingServices database executionlog table to find out who ran a report (using the execution sample reports from the installation disk by user) and to see how long it took and what were the parameters that were entered. The problem is, when you set Anonymous Access in IIS to get round this access problem and set it to be a specific user (lets call the user Mr X) all reports are permanently flagged as being created and modified by Mr X rather than the user who's made the amendment if an existing report or the creator of the new report. Also, the executionlog table in the reportserver database flags ALL reports as being run by Mr X even though they've been run by many different users. Is there a way around this please?

View Replies !   View Related
System.Net.WebException: The Request Failed With HTTP Status 404: Object Not Found.
We did configure reporting services to use a custom security extension on a Windows  2000 sp4 machine and using IIS 5.0.

The website for reporting services is not using the default website in IIS. It uses IP address : 192.168.1.20 and host header name is rpt2.compagny.com. When accessing the report manager at http://rpt2.compagny.com/reports$sql_2005 from another machine or on the machine where reporting services is installed  we get an error message.  

Error Message : The attempt to connect to the report server failed.  Check your connection information and that the report server is a compatible version. 

The RSWebApplication.config file looks like the following :

<UI>

                  <CustomAuthenticationUI>

                        <loginUrl>/Pages/UILogon.aspx</loginUrl>

                  <UseSSL>False</UseSSL>

                  </CustomAuthenticationUI>

                  <ReportServerUrl>http://server name/ReportServer$sql_2005</ReportServerUrl>
                

      </UI>

The RSreportserver.config file looks like the following :

<UrlRoot>http://server name/ReportServer$SQL_2005</UrlRoot>

We already tried replacing the server name with the ip address in both the RSreportserver.config file and RSWebapplication.config file and it still does not work.

here is the logfile information :

aspnet_wp!ui!1!2/26/2007-14:41:51:: e ERROR: The attempt to connect to the report server failed.  Check your connection information and that the report server is a compatible version.
aspnet_wp!ui!1!2/26/2007-14:41:51:: e ERROR: HTTP status code --> 500
-------Details--------
Microsoft.SqlServer.ReportingServices2005.RSConnection+MissingEndpointException: The attempt to connect to the report server failed.  Check your connection information and that the report server is a compatible version. ---> System.Net.WebException: The request failed with HTTP status 404: Object Not Found.

   at Microsoft.SqlServer.ReportingServices2005.RSConnection.GetSecureMethods()

   at Microsoft.ReportingServices.UI.Global.RSWebServiceWrapper.GetSecureMethods()

   at Microsoft.SqlServer.ReportingServices2005.RSConnection.IsSecureMethod(String methodname)

   at Microsoft.SqlServer.ReportingServices2005.RSConnection.ValidateConnection()

   --- End of inner exception stack trace ---

   at Microsoft.SqlServer.ReportingServices2005.RSConnection.MissingEndpointException.ThrowIfEndpointMissing(WebException e)

   at Microsoft.SqlServer.ReportingServices2005.RSConnection.ValidateConnection()

   at Microsoft.ReportingServices.UI.ReportingPage.EnsureHttpsLevel(HttpsLevel level)

   at Microsoft.ReportingServices.UI.ReportingPage.ReportingPage_Init(Object sender, EventArgs args)

   at System.EventHandler.Invoke(Object sender, EventArgs e)

   at System.Web.UI.Control.OnInit(EventArgs e)

   at System.Web.UI.Page.OnInit(EventArgs e)

   at System.Web.UI.Control.InitRecursive(Control namingContainer)

   at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)

What should be the settings in IIS and the configuration files ?

Any help would be appreciated.


Chi

View Replies !   View Related
Configuring Reporting Service Add-in For Sharepoint - HTTP Status 401: Unauthorized.
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 Replies !   View Related
I Am Getting 'Page Cannont Be Displayed Error When Typing The URL Http://&&<ServerName&&>/ReportsServer/Pages/Folder.aspx
Hi

 

I have set my SQL server express server and have installed SSRS (reporting services) and Business Intelligence Studio.

 

When i create a new report and delpoy that report, it successfully deploys it.

 

when I go to the below URL's from the laptop browser, I am successfully able to see my reports

 

http://lemd342608/Reports$SQLExpress/Pages/Folder.aspx - Report manager

http://localhost/reportServer$SQLExpress - report server

 

Now when I go to a external machine besides my laptop, and type in the 'URL's I am getting 'Page cannont be displayed error'.

 

DO I need to configure anything in order to allow other users to access my SSRS. I have added the users in the Reporting manager also.

 

Thanks

View Replies !   View Related
HTTP Status 400: Bad Request
I just installed sql server 2005 on a windows 2003 server.  I chose the option to install but do not configure.  After restarting, I used the Reporting SErvices Configuration Manager and it all looks ok.  When I browse to //localhost/reports I get a rs page with the message of:
The request failed with HTTP status 400: Bad Request.

View Replies !   View Related
Error In Display .rdl Report On Aspx Page
hi to all,

I am using Sql server reporting services.When i have create a report .rdl file and deploy it on Report server and than display that report on my application's .aspx page in pdf format using web services , every thing is perfactly working in my senario at the starting time but now i faced a problem with that. When record goes more than 2000 (in my senario a single record disply in a one report pdf page means for 2000 record in table that means its display in 2000 pdf page as with next forward option of pdf view),So in that cas it doesn't work, did now show any report and give the error as
ex.Message"Client found response content type of 'text/html; charset=utf-8', but expected 'text/xml'.
The request failed with the error message:
--
<?xml version="1.0" ?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.1//EN" "http://www.w3.org/TR/xhtml11/DTD/xhtml11.dtd">
<html xmlns="http://www.w3.org/1999/xhtml" >
<head>
<title>Server Unavailable
</title>
</head>
<body>
<h1><span style="font-family:Verdana;color: #ff3300">Server Application Unavailable
</span></h1>
<p>
<span style="font-family:Verdana;">
The web application you are attempting to access on this web server is currently unavailable.  Please hit the "Refresh" button in your web browser to retry your request.
</span></p>
<p>
<b>Administrator Note:
</b> An error message detailing the cause of this specific request failure can be found in the application event log of the web server. Please review this log entry to discover what caused this error to occur.
</p>
</body>
</html>

--."string

Any body have any idea please help me as soon as possible.
urgently--- any help will be appriciate.
thanks in advance.
arvind

View Replies !   View Related
HTTP Status 401: Access Denied Error In Report Manager
This didn't use to happen but now it does.

 

When I go into Report Manager, http://localhost/reports, and try running a report it is giving me this error message:

 

The request failed with HTTP status 401: Access Denied

 

But if I go directly to the Report Server, http://localhost/reportserver, and try running a report there then everything is fine.

 

Does anyone know why it is doing this all of a sudden? I did change the Reports app in ISS to allow anonymous access but have since changed it back, and it still gives this error.

View Replies !   View Related
Http Request Failed, Could Not Connect To The Server
We are using the merge replication between SQL 2000 (SP3 - 8.00.760) and HPC (SQL CE) across internet using VPN. DLL is SSCESA10.dll.

Everything was perfect till yesterday but suddenly getting the following messages

Error message:

Source : Microsoft SQL Server 2000 Windows CE Edition
Error Number : 80072EFD
Native Number : 28037
Error Description : Run
Http Request failed, Could not connect to the server
SSCE_M_HTTPREQUESTFAILED

Even after setting the level to 3, no information is getting in log file.

Even after connecting using the serial cable and relay its not connecting, not getting the ‘BODY’ message in IE on HPC.

Pls. Help, Thanks in advance.

View Replies !   View Related
Report Viewer Control And ASPX
I am trying to use the Report Viewer Control in an ASPX page but getting the following error "For security reasons DTD is prohibited in this XML document. To enable DTD processing set the ProhibitDtd property on XmlReaderSettings to false and pass the settings into XmlReader.Create method". This is with September CTP of SQL Server 2005. I am not trying to set any DTD, the same report works if displayed using the WinForm viewer control...so I am not sure why this is happening. is there any samples available for using the Report Web viewer control in an aspx page?
Thanks
Krishna

View Replies !   View Related
VS2005 ReportViewer HTTP ERROR 401 Unauthorized
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 Replies !   View Related
HTTP Error 401.2 - Unauthorized: Access Is Denied Due To Server Configuration.
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 Replies !   View Related
Report Viewer In ASP.NET - Subreport Page 2 Goes Back To Main Report Page 2 On Paging
What we've found is that when you have two reports where one navigates to the other, if you click on the second page of the second report, it takes you to the second page of the original report.  If you navigate over to the subreport again and click for the second page, it works appropriately.  This is definitely a no-go for production code and this may delay our ship date because I would think this is definitely undesirable.
 
Conditions:

ASP.NET Report Viewer using Remote Reports
Report that links to another report
Both reports return more than one page
Reporting Services installed
Steps to Reproduce:


Download the source code here.

Follow the directions (near the bottom of the post) to get the project set up.

Run it and click on a link in the first report to go to the second report.

Click the arrow for page 2 of the second report.

Notice how it takes you back to page 2 of the first report (this doesn't happen when you are in preview mode in the Reporting Services project and I don't believe it does this in a smart client application).

Click on a link in the first report to go back to the second report.

Click the arrow for page 2.

Notice how it takes you to page 2 of the second report.
 
 
Here is a link with source code and a more detailed explanation: http://geekswithblogs.net/robz/archive/2007/11/21/Reporting-Services-2005-BUG-Report-Linking-and-Paging---ASP.NET.aspx
 
So what I am looking for is both a workaround for now and if this is determined to be a bug, to be fixed in the next service pack.

View Replies !   View Related
Failed To Call SSIS Package From ASPX C# Web Page
Hi, Everyone:

    I am getting the following error message when I try to execute a SSIS package from an asp.net page written in C# 2.0.  What I am trying to do is basically just click on a button in the web page and it will execute the package.  The code to execute the package is pretty simple. I pass the path of the DTS package stored in the local folder.  This works fine in the machine where SQL2005 is installed locally.  But it fail when I have a seperate Web Server and SQL Server.  Any ideas? Do I have to install SSIS or SQL2005 on a web server as well?

 

Thanks

 

static public string Execute_SSIS_DTS(string DTS_Path)

{

Microsoft.SqlServer.Dts.Runtime.Application app;

app = new Microsoft.SqlServer.Dts.Runtime.Application();

Package package = app.LoadPackage(DTS_Path, null);

DTSExecResult result = package.Execute();

return result.ToString();

}

Retrieving the COM class factory for component with CLSID {E44847F1-FD8C-4251-B5DA-B04BB22E236E} failed due to the following error: 80040154.





Line 226: static public string Execute_SSIS_DTS(string DTS_Path)
Line 227: {
Line 228: Application app = new Application();
Line 229: Package package = app.LoadPackage(DTS_Path, null);
Line 230: DTSExecResult result = package.Execute();

[COMException (0x80040154): Retrieving the COM class factory for component with CLSID {E44847F1-FD8C-4251-B5DA-B04BB22E236E} failed due to the following error: 80040154.]
   Microsoft.SqlServer.Dts.Runtime.Application..ctor() +43

[DtsPipelineException: Retrieving the COM class factory for component with CLSID {E44847F1-FD8C-4251-B5DA-B04BB22E236E} failed due to the following error: 80040154.]
   Microsoft.SqlServer.Dts.Runtime.Application..ctor() +169
   Utilities.Execute_SSIS_DTS(String DTS_Path) in c:InetpubwwwrootMasterTablesApp_CodeUtilities.cs:228
   MasterTables_Admin_MasterTables_LOINC_External.btn_SyncLISTest_Click(Object sender, EventArgs e) in c:InetpubwwwrootMasterTablesMasterTables_CustomMasterTablesCustom_LOINC_External.aspx.cs:98
   System.Web.UI.WebControls.Button.OnClick(EventArgs e) +114
   System.Web.UI.WebControls.Button.RaisePostBackEvent(String eventArgument) +141
   System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler sourceControl, String eventArgument) +32
   System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +3215

View Replies !   View Related
Error Processing Resource 'http://localhost/reports/Pages/Folder.aspx'
Hi all

After deploying my report on the report Server, I try to access it on the browser which gives me the following error.

The XML page cannot be displayed
Cannot view XML input using XSL style sheet. Please correct the error and then click the Refresh button, or try again later.


A name was started with an invalid character. Error processing resource 'http://localhost/reports/Pages/Folder.aspx'. Line...<%@ Page language="c#" Codebehind="Folder.aspx.cs" AutoEventWireup="false" Inherits="Microsoft.ReportingServices.UI.Folde...




How can I trouble shoot this error.?

Please help me out.

Thanx in advance.

Ronald

View Replies !   View Related
ReportViewer Does Not Show Report In Aspx Page
I created a report with a parameter.  The parameter was created using a dataset in the report designer.  This works fine.  I deployed the report (webhost4life) and the report runs fine in the report manager.  I am able to select my casenumber click on the default view report button and it works. 

Problem:  I embedd the report into an aspx page frmReports1.aspx.  I call this page from another page (form).  the frmReports.aspx page comes up and displays the default drop down list box with the casenumbers (fine).  I select the  casenumber and click on the view report button and NOTHING.  I here the postbacks taking place but all that happens is the default value appears in the drop down list box and the toolbar shows.  I checked permissions and everything is fine.  I searched the forum and thought i found the solution with the inLine HTML and Async (still nothing) I can only think that something is not going right with the parameter.  Here is my html, and code behind code.  any help would be greatly apprcieated.

 

Zachary

 

<%@ Page Language="VB" AutoEventWireup="false" CodeFile="frmReports1.aspx.vb" Inherits="frmReports1" %>

<%@ Register Assembly="Microsoft.ReportViewer.WebForms, Version=8.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a"

Namespace="Microsoft.Reporting.WebForms" TagPrefix="rsweb" %>



<%@ Register Assembly="Microsoft.ReportViewer.WebForms, Version=8.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a"

Namespace="Microsoft.Reporting.WebForms" TagPrefix="rsweb" %>

 

 

<html xmlns="http://www.w3.org/1999/xhtml" >

<head runat="server">

<title>Untitled Page</title>

<style>html,body,form {height:100%}</style>

</head>

<body>

<form id="form1" runat="server">

<div>

<rsweb:ReportViewer ID="rvTest" runat="server" Width="600px" ProcessingMode="Remote" AsyncRendering="false" Height="75%" >

<ServerReport

DisplayName="Billable Hours"

ReportPath="/sddmtech/SnowandIce/rptHoursWorked"

ReportServerUrl="http://sqlreport01.mysite4now.com/Reportserver" />

</rsweb:ReportViewer>

&nbsp;



</div>

</form>

</body>

</html>

 

aspx code behind

Imports System.Net

Imports System.Security.Principal

Imports Microsoft.Reporting.WebForms

Partial Class frmReports1

Inherits System.Web.UI.Page

Protected Sub rvTest_Init(ByVal sender As Object, ByVal e As System.EventArgs) Handles rvTest.Init

End Sub

<Serializable()> _

Public NotInheritable Class MyReportServerCredentials

Implements IReportServerCredentials

 

Public ReadOnly Property ImpersonationUser() As WindowsIdentity _

Implements IReportServerCredentials.ImpersonationUser

Get

Return Nothing

End Get

End Property

Public ReadOnly Property NetworkCredentials() As ICredentials _

Implements IReportServerCredentials.NetworkCredentials

Get

' Put your login and password here this works fine

Dim userName As String = ""

Dim password As String = ""

Dim domain As String = ""

Return New NetworkCredential(userName, password, domain)

'********************************************************************************

End Get

End Property

Public Function GetFormsCredentials(ByRef authCookie As System.Net.Cookie, ByRef userName As String, ByRef password As String, ByRef authority As String) As Boolean Implements Microsoft.Reporting.WebForms.IReportServerCredentials.GetFormsCredentials

End Function

End Class

Public Function GetFormsCredentials(ByRef authCookie As Cookie, _

ByRef userName As String, _

ByRef password As String, _

ByRef authority As String) _

As Boolean

authCookie = Nothing

userName = Nothing

password = Nothing

authority = Nothing

'Not using form credentials

Return False

End Function



Protected Sub form1_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles form1.Load

'ReportViewer1.ServerReport.ReportServerCredentials = New MyReportServerCredentials()

'rvTest.ServerReport.Refresh()

End Sub

Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load

rvTest.ServerReport.ReportServerCredentials = New MyReportServerCredentials()

End Sub

End Class

View Replies !   View Related
How To Bring Report Builder In Aspx Page?
 

Hi
How to bring Report builder in the Ui of .net aspx pages?
I tryed withe the .exe but it is comming with a new process and come up with new IDE of Report builder, i donot required this,
I want it should come up within the Aspx page itself.
 
any input will be helpfull for me.
 
 
regrads
Bibek

View Replies !   View Related
Reporting Services Report Embed In Aspx Page
Hello,
 
I am trying to embed a Reporting Services Report in a aspx page.  I have the report embedded in the page but I am having difficulty passing a parameter to the report and getting the report to run within the page.  Any information is appreciated.
 
Thanks!

View Replies !   View Related
Showing SSRS 2005 Report On Aspx Page
Hi,
 
I have used Report viewer control to show ssrs 2005 report in my aspx page.
Can we show the SSRS 2005 report on the aspx page in any other way?
any info on this is appreciated.
 
Thanks,
Srik

View Replies !   View Related
HTTP 400: Bad Request Error. And ERROR: The Remote Name Could Not Be Resolved: 'host Header Value'
Whenever I attempt to access http://<server>/Reports, it comes back at me with an  HTTP 400: Bad Request error.

The http://<server>/ReportServer works fine. The error only occurs on /Reports, and the error is displayed using some of the page elements of the /Reports site.

 

The reportserver and reports virtual directory are running under are not running under the default website on IIS 6. i created the reports and reportserver using the reporting services configuration tools. the website has a host header value and has an ip address.

 

RSWebapplication.config looks like this :

<ReportServerUrl>http://servername/ReportServer</ReportServerUrl>    

 

RSreportserver.config looks like this :

<UrlRoot>http://servername/ReportServer</UrlRoot>      
  

i tried the following changes :

 

1 - from <ReportServerUrl>http://servername/ReportServer</ReportServerUrl>

to <ReportServerUrl>http://host header value/ReportServer</ReportServerUrl>

2 - from <UrlRoot>http://servername/ReportServer</UrlRoot> 

to <UrlRoot>http://host header value/ReportServer</UrlRoot>

 

now i get an error : ERROR: The remote name could not be resolved: 'host header value'

 

============================ RS Web app log file ============================

w3wp!ui!9!7/25/2007-10:30:07:: e ERROR: The remote name could not be resolved: 'host header value'
w3wp!ui!9!7/25/2007-10:30:07:: e ERROR: HTTP status code --> 500
-------Details--------
System.Net.WebException: The remote name could not be resolved: 'host header value'

   at Microsoft.SqlServer.ReportingServices2005.RSConnection.GetSecureMethods()

   at Microsoft.ReportingServices.UI.Global.RSWebServiceWrapper.GetSecureMethods()

   at Microsoft.SqlServer.ReportingServices2005.RSConnection.IsSecureMethod(String methodname)

   at Microsoft.SqlServer.ReportingServices2005.RSConnection.ValidateConnection()

   at Microsoft.ReportingServices.UI.ReportingPage.EnsureHttpsLevel(HttpsLevel level)

   at Microsoft.ReportingServices.UI.ReportingPage.ReportingPage_Init(Object sender, EventArgs args)

   at System.EventHandler.Invoke(Object sender, EventArgs e)

   at System.Web.UI.Control.OnInit(EventArgs e)

   at System.Web.UI.Page.OnInit(EventArgs e)

   at System.Web.UI.Control.InitRecursive(Control namingContainer)

   at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)
w3wp!ui!9!7/25/2007-10:30:07:: e ERROR: Exception in ShowErrorPage: System.Threading.ThreadAbortException: Thread was being aborted.
   at System.Threading.Thread.AbortInternal()
   at System.Threading.Thread.Abort(Object stateInfo)
   at System.Web.HttpResponse.End()
   at System.Web.HttpServerUtility.Transfer(String path, Boolean preserveForm)
   at Microsoft.ReportingServices.UI.ReportingPage.ShowErrorPage(String errMsg) at    at System.Threading.Thread.AbortInternal()
   at System.Threading.Thread.Abort(Object stateInfo)
   at System.Web.HttpResponse.End()
   at System.Web.HttpServerUtility.Transfer(String path, Boolean preserveForm)
   at Microsoft.ReportingServices.UI.ReportingPage.ShowErrorPage(String errMsg)
    
   

Why is this happening. i have no problems with http://host header value/reportserver. only with report manager.

What needs to be done to have report manager accessible via the internet ?

Any help will be appreciated.

 

Chi


       
  

 

 

 

 

View Replies !   View Related
SQL Insert In Aspx.vb File (or Share Variable With .aspx Page)
Hi,I have a form page with an insert like this:<asp:SqlDataSource ID="addProductDataSource" runat="server"    InsertCommand="INSERT INTO test(        title1,        firstName1,        lastName1,        dateOfBirth    ) VALUES (        @title1,        @firstName1,        @lastName1        @dateOfBirth    )"     ConnectionString="<%$ ConnectionStrings:yourQuoteCentreConnectionString %>">        <InsertParameters>            <asp:ControlParameter ControlID="dateOfBirth" Name="dateOfBirth" Type="DateTime" />            <asp:ControlParameter ControlID="title1" Name="title1" PropertyName="Text" />            <asp:ControlParameter ControlID="firstName1" Name="firstName1" PropertyName="Text" />            <asp:ControlParameter ControlID="lastName1" Name="lastName1" PropertyName="Text" />        </InsertParameters></asp:SqlDataSource> In default.aspx.vb I have:Protected Sub Wizard1_FinishButtonClick(ByVal sender As Object, ByVal e As System.Web.UI.WebControls.WizardNavigationEventArgs) Handles Wizard1.FinishButtonClick    'CREATE DATETIME FROM USERS BIRTH DATE        Dim dateOfBirth As New System.DateTime(applicantYear.SelectedValue, applicantMonth.SelectedValue, applicantMonth.SelectedValue, 0, 0, 0)    'INSERT TO DATABASE        addProductDataSource.Insert()End SubI would like to reference the variable dateOfBirth created in default.aspx.vb in the insert query on the page, or ideally move the insert query into the aspx.vb page.  Would this make more sense to do?Thanks,Paul

View Replies !   View Related
AspX Page Connection Error Using Sqlserver
Dear i am using visual studio.net.......... when i connect database (in sqlserver) using sqldataAdapter with datagrid in visual basic.net every thing work properly........... but when i use the same in asp.net then i get an error message on the resultant explorer page give below.


Server Error in '/studentData' Application.
--------------------------------------------------------------------------------

Login failed for user 'RAMIZSARDARASPNET'.
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.Data.SqlClient.SqlException: Login failed for user 'RAMIZSARDARASPNET'.

Source Error:


Line 85: 'Put user code to initialize the page here
Line 86: Dim ds As New DataSet()
Line 87: SqlDataAdapter1.Fill(ds)
Line 88: DataGrid1.DataSource = ds.Tables(0)
Line 89: DataGrid1.DataBind()


Source File: c:inetpubwwwrootstudentDataWebForm1.aspx.vb Line: 87

Stack Trace:


[SqlException: Login failed for user 'RAMIZSARDARASPNET'.]
System.Data.SqlClient.SqlConnection.Open()
System.Data.Common.DbDataAdapter.QuietOpen(IDbConnection connection, ConnectionState& originalState)
System.Data.Common.DbDataAdapter.Fill(Object data, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior)
System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior)
System.Data.Common.DbDataAdapter.Fill(DataSet dataSet)
studentData.WebForm1.Page_Load(Object sender, EventArgs e) in c:inetpubwwwrootstudentDataWebForm1.aspx.vb:87
System.Web.UI.Control.OnLoad(EventArgs e)
System.Web.UI.Control.LoadRecursive()
System.Web.UI.Page.ProcessRequestMain()




--------------------------------------------------------------------------------
Version Information: Microsoft .NET Framework Version:1.0.3705.0; ASP.NET Version:1.0.3705.0


Plz solve my problem and Reply me on ramiz_ch@hotmail.com
Plz solve my problem and Reply me on ramiz_ch@hotmail.com
Plz solve my problem and Reply me on ramiz_ch@hotmail.com

Ramiz

View Replies !   View Related
No Of Page In Report Viewer Is Not Same As The One When Printing
For example, In the report viewer, there are 3 pages, however, when I print the report, there are more pages, like 6 pages. I found that there are more records in a page in the report viewer.

Is there any way to set the number of pages in report viewer is same as the one when printing?

View Replies !   View Related
Report Viewer - Lines Per Page
 

Hello,
 
 
I am using the report viewer control to show a report I wrote with Visual studio 2005.
How can I customize the lines per page? Now the report shows 50 lines and I want to change it to 20 lines per page.
 
Thanks

 

View Replies !   View Related
Report Viewer - HTML -&&> PDF Page Size Detections
Hi.

I have an issue regarding page size detection when exporting my reports and its 16 subreports from the HTML Report Viewer to a PDF file using the control on the menu.

It always picks up only the page size of the FIRST page of the report and forces the subreports to this size.

I need the reports to alternate between A4 and A3 as the subreport size defines the page size for readability related issues.

Using Reporting Services with SQL 2005. It displays the page sizes perfectly in HTML, but on exporting to PDF it forces to a fixed size.

Any assistance will be GREATLY appreciated.

Regards,

Jan (aka Slasher)

View Replies !   View Related
MS Report Manager: Accessing Http://localhost/reports And Page Not Found
I install sql server 2005 with reporting service at Windows Server 2003. Everything is fine except that when i accessing http://localhost/reports and there is error of page not found. However, i can access http://localhost/reportserver.

i go to my IIS and found out that there is virtual directory for reportserver but do not have virtual directory for reports or report.

When I run the Reporting Services Configuration tool and click on the <Web Service Identity>, there is an error about VM properties.Other than that, everything is fine and my localhost can run and my application can retrieved,update the database.

Any idea what is happening? I did try to uninstall the whole sql and reinstall but same error. Any clue. Thanks in advance.

View Replies !   View Related
HTTP: 401 Unauthorized When Trying To Use Reporting Services And MOSS2007 In Integrated Mode
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 Replies !   View Related
How Can I Add Report To Report Viewer In Asp.net Page
 

sorry but this is my first dayes to using sql report services i make 14 report in sql report services server and do't know how can i add this reports to my aspx page
and every report have parameters how can i send this parmeter to reports when he open or load in aspx page
like companyID and employeeID
my report have his datasource and dataset
sorry but i just start to using reports services

View Replies !   View Related
Change Page Title From &&"Report Viewer/Manager&&" To The Actual Report Name?
Can a person change the page title from "Report Viewer/Manager" to the actual report name?

View Replies !   View Related
Status 401: Unauthorized. (Microsoft.SqlServer.Management.UI.RSClient)
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 Replies !   View Related
How To Access A .asp Page Or .aspx Page From A Store Procedure In Sql Server 2000
Hi, I wanted to know that can we access a webpagefrom a store procedure in sql server 2000 like we run a exe file from sql server. Bye.

View Replies !   View Related
The Request Failed With The Error Message
 

I have SSRS installed on a web server and points to another SQL Server with the ReportServer database.  Every now and then I would get this error message on Report Manger:
 
Client found response content type of '', but expected 'text/xml'. The request failed with an empty response.
 

Here is a trace from Stack Trace from ReportServerWebApp log file:
<Header>
  <Product>Microsoft SQL Server Reporting Services Version 9.00.2047.00</Product>
  <Locale>en-US</Locale>
  <TimeZone>Eastern Daylight Time</TimeZone>
  <Path>C:Program FilesMicrosoft SQL ServerMSSQL.1Reporting ServicesLogFilesReportServerWebApp__08_27_2007_00_09_07.log</Path>
  <SystemName>WATCOMWEB</SystemName>
  <OSName>Microsoft Windows NT 5.2.3790 Service Pack 1</OSName>
  <OSVersion>5.2.3790.65536</OSVersion>
</Header>
w3wp!library!6!8/27/2007-00:09:07:: i INFO: Initializing MaxActiveReqForOneUser to '20' requests(s) as specified in Configuration file.
w3wp!library!6!8/27/2007-00:09:07:: i INFO: Initializing MaxScheduleWait to default value of '1' second(s) because it was not specified in Configuration file.
w3wp!library!6!8/27/2007-00:09:07:: i INFO: Initializing DatabaseQueryTimeout to default value of '30' second(s) because it was not specified in Configuration file.
w3wp!library!6!8/27/2007-00:09:07:: i INFO: Initializing ProcessRecycleOptions to default value of '0'  because it was not specified in Configuration file.
w3wp!library!6!8/27/2007-00:09:07:: i INFO: Initializing RunningRequestsScavengerCycle to default value of '30' second(s) because it was not specified in Configuration file.
w3wp!library!6!8/27/2007-00:09:07:: i INFO: Initializing RunningRequestsDbCycle to default value of '30' second(s) because it was not specified in Configuration file.
w3wp!library!6!8/27/2007-00:09:07:: i INFO: Initializing RunningRequestsAge to default value of '30' second(s) because it was not specified in Configuration file.
w3wp!library!6!8/27/2007-00:09:07:: i INFO: Initializing CleanupCycleMinutes to default value of '10' minute(s) because it was not specified in Configuration file.
w3wp!library!6!8/27/2007-00:09:07:: i INFO: Initializing DailyCleanupMinuteOfDay to default value of '120' minutes since midnight because it was not specified in Configuration file.
w3wp!library!6!8/27/2007-00:09:07:: i INFO: Initializing WatsonFlags to default value of '1064'  because it was not specified in Configuration file.
w3wp!library!6!8/27/2007-00:09:07:: i INFO: Initializing WatsonDumpOnExceptions to default value of 'Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException,Microsoft.ReportingServices.Modeling.InternalModelingException'  because it was not specified in Configuration file.
w3wp!library!6!8/27/2007-00:09:07:: i INFO: Initializing WatsonDumpExcludeIfContainsExceptions to default value of 'System.Data.SqlClient.SqlException,System.Threading.ThreadAbortException'  because it was not specified in Configuration file.
w3wp!library!6!8/27/2007-00:09:07:: i INFO: Initializing SecureConnectionLevel to default value of '1'  because it was not specified in Configuration file.
w3wp!library!6!8/27/2007-00:09:07:: i INFO: Initializing DisplayErrorLink to 'True'  as specified in Configuration file.
w3wp!library!6!8/27/2007-00:09:07:: i INFO: Initializing WebServiceUseFileShareStorage to default value of 'False'  because it was not specified in Configuration file.
w3wp!ui!6!8/27/2007-00:09:10:: e ERROR: Client found response content type of '', but expected 'text/xml'.
The request failed with an empty response.
w3wp!ui!6!8/27/2007-00:09:10:: e ERROR: HTTP status code --> 500
-------Details--------
System.InvalidOperationException: Client found response content type of '', but expected 'text/xml'.
The request failed with an empty response.
   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.ReportingServices2005.ReportingService2005.ListSecureMethods()
   at Microsoft.SqlServer.ReportingServices2005.RSConnection.ValidateConnection()
   at Microsoft.ReportingServices.UI.ReportingPage.EnsureHttpsLevel(HttpsLevel level)
   at Microsoft.ReportingServices.UI.ReportingPage.ReportingPage_Init(Object sender, EventArgs args)
   at System.EventHandler.Invoke(Object sender, EventArgs e)
   at System.Web.UI.Control.OnInit(EventArgs e)
   at System.Web.UI.Page.OnInit(EventArgs e)
   at System.Web.UI.Control.InitRecursive(Control namingContainer)
   at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)
w3wp!ui!6!8/27/2007-00:09:13:: e ERROR: Exception in ShowErrorPage: System.Threading.ThreadAbortException: Thread was being aborted.
   at System.Threading.Thread.AbortInternal()
   at System.Threading.Thread.Abort(Object stateInfo)
   at System.Web.HttpResponse.End()
   at System.Web.HttpServerUtility.Transfer(String path, Boolean preserveForm)
   at Microsoft.ReportingServices.UI.ReportingPage.ShowErrorPage(String errMsg) at    at System.Threading.Thread.AbortInternal()
   at System.Threading.Thread.Abort(Object stateInfo)
   at System.Web.HttpResponse.End()
   at System.Web.HttpServerUtility.Transfer(String path, Boolean preserveForm)
   at Microsoft.ReportingServices.UI.ReportingPage.ShowErrorPage(String errMsg)

 
Other times I would get this error:
The request failed with the error message:
--
<html><head><title>Object moved</title></head><body> <h2>Object moved to <a href="/insightrptserver/logon.aspx?ReturnUrl=%2finsightrptserver%2fReportExe
cution2005.asmx">here</a>.</h2>
</body></html>
 
Stack Trace from ReportServerWebApp log:
<Header>
  <Product>Microsoft SQL Server Reporting Services Version 9.00.2047.00</Product>
  <Locale>en-US</Locale>
  <TimeZone>Eastern Daylight Time</TimeZone>
  <Path>C:Program FilesMicrosoft SQL ServerMSSQL.1Reporting ServicesLogFilesReportServerWebApp__08_26_2007_22_03_51.log</Path>
  <SystemName>WATCOMWEB</SystemName>
  <OSName>Microsoft Windows NT 5.2.3790 Service Pack 1</OSName>
  <OSVersion>5.2.3790.65536</OSVersion>
</Header>
w3wp!library!6!8/26/2007-22:03:51:: i INFO: Initializing MaxActiveReqForOneUser to '20' requests(s) as specified in Configuration file.
w3wp!library!6!8/26/2007-22:03:51:: i INFO: Initializing MaxScheduleWait to default value of '1' second(s) because it was not specified in Configuration file.
w3wp!library!6!8/26/2007-22:03:51:: i INFO: Initializing DatabaseQueryTimeout to default value of '30' second(s) because it was not specified in Configuration file.
w3wp!library!6!8/26/2007-22:03:51:: i INFO: Initializing ProcessRecycleOptions to default value of '0'  because it was not specified in Configuration file.
w3wp!library!6!8/26/2007-22:03:51:: i INFO: Initializing RunningRequestsScavengerCycle to default value of '30' second(s) because it was not specified in Configuration file.
w3wp!library!6!8/26/2007-22:03:51:: i INFO: Initializing RunningRequestsDbCycle to default value of '30' second(s) because it was not specified in Configuration file.
w3wp!library!6!8/26/2007-22:03:51:: i INFO: Initializing RunningRequestsAge to default value of '30' second(s) because it was not specified in Configuration file.
w3wp!library!6!8/26/2007-22:03:51:: i INFO: Initializing CleanupCycleMinutes to default value of '10' minute(s) because it was not specified in Configuration file.
w3wp!library!6!8/26/2007-22:03:51:: i INFO: Initializing DailyCleanupMinuteOfDay to default value of '120' minutes since midnight because it was not specified in Configuration file.
w3wp!library!6!8/26/2007-22:03:51:: i INFO: Initializing WatsonFlags to default value of '1064'  because it was not specified in Configuration file.
w3wp!library!6!8/26/2007-22:03:51:: i INFO: Initializing WatsonDumpOnExceptions to default value of 'Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException,Microsoft.ReportingServices.Modeling.InternalModelingException'  because it was not specified in Configuration file.
w3wp!library!6!8/26/2007-22:03:51:: i INFO: Initializing WatsonDumpExcludeIfContainsExceptions to default value of 'System.Data.SqlClient.SqlException,System.Threading.ThreadAbortException'  because it was not specified in Configuration file.
w3wp!library!6!8/26/2007-22:03:51:: i INFO: Initializing SecureConnectionLevel to default value of '1'  because it was not specified in Configuration file.
w3wp!library!6!8/26/2007-22:03:51:: i INFO: Initializing DisplayErrorLink to 'True'  as specified in Configuration file.
w3wp!library!6!8/26/2007-22:03:51:: i INFO: Initializing WebServiceUseFileShareStorage to default value of 'False'  because it was not specified in Configuration file.
w3wp!ui!6!8/26/2007-22:07:35:: Unhandled exception: System.Net.WebException: The request failed with the error message:
--
<html><head><title>Object moved</title></head><body>
<h2>Object moved to <a href="/insightrptserver/logon.aspx?ReturnUrl=%2finsightrptserver%2fReportExecution2005.asmx">here</a>.</h2>
</body></html>
--.
   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.ReportingServices2005.Execution.ReportExecutionService.GetExecutionInfo()
   at Microsoft.SqlServer.ReportingServices2005.Execution.RSExecutionConnection.GetExecutionInfo()
   at Microsoft.Reporting.WebForms.ServerReport.GetExecutionInfo()
   at Microsoft.Reporting.WebForms.ServerReport.SetExecutionId(String executionId, Boolean fullReportLoad)
   at Microsoft.Reporting.WebForms.ServerReport.LoadFromUrlQuery(NameValueCollection requestParameters, Boolean fullReportLoad)
   at Microsoft.Reporting.WebForms.ReportDataOperation..ctor()
   at Microsoft.Reporting.WebForms.HttpHandler.GetHandler()
   at Microsoft.Reporting.WebForms.HttpHandler.ProcessRequest(HttpContext context)
   at System.Web.HttpApplication.CallHandlerExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute()
   at System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously)
w3wp!ui!5!8/26/2007-22:07:48:: Unhandled exception: System.Net.WebException: The request failed with the error message:
--
<html><head><title>Object moved</title></head><body>
<h2>Object moved to <a href="/insightrptserver/logon.aspx?ReturnUrl=%2finsightrptserver%2fReportExecution2005.asmx">here</a>.</h2>
</body></html>
--.
   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.ReportingServices2005.Execution.ReportExecutionService.GetRenderResource(String Format, String DeviceInfo, String& MimeType)
   at Microsoft.SqlServer.ReportingServices2005.Execution.RSExecutionConnection.GetRenderResource(String Format, String DeviceInfo, String& MimeType)
   at Microsoft.Reporting.WebForms.ServerReport.GetRenderResource(String format, String streamId, String& mimeType)
   at Microsoft.Reporting.WebForms.ServerReportControlSource.GetRendererImage(String streamID, String& mimeType)
   at Microsoft.Reporting.WebForms.ReportImageOperation.GetRendererImage(String resourceID, HttpResponse response)
   at Microsoft.Reporting.WebForms.ReportImageOperation.PerformOperation(NameValueCollection urlQuery, HttpResponse response)
   at Microsoft.Reporting.WebForms.HttpHandler.ProcessRequest(HttpContext context)
   at System.Web.HttpApplication.CallHandlerExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute()
   at System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously)
w3wp!ui!7!8/26/2007-22:08:22:: e ERROR: Client found response content type of '', but expected 'text/xml'.
The request failed with an empty response.
w3wp!ui!7!8/26/2007-22:08:22:: e ERROR: HTTP status code --> 500
-------Details--------
System.InvalidOperationException: Client found response content type of '', but expected 'text/xml'.
The request failed with an empty response.
   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.ReportingServices2005.ReportingService2005.ListSecureMethods()
   at Microsoft.SqlServer.ReportingServices2005.RSConnection.ValidateConnection()
   at Microsoft.ReportingServices.UI.ReportingPage.EnsureHttpsLevel(HttpsLevel level)
   at Microsoft.ReportingServices.UI.ReportingPage.ReportingPage_Init(Object sender, EventArgs args)
   at System.EventHandler.Invoke(Object sender, EventArgs e)
   at System.Web.UI.Control.OnInit(EventArgs e)
   at System.Web.UI.Page.OnInit(EventArgs e)
   at System.Web.UI.Control.InitRecursive(Control namingContainer)
   at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)
w3wp!ui!7!8/26/2007-22:08:22:: e ERROR: Exception in ShowErrorPage: System.Threading.ThreadAbortException: Thread was being aborted.
   at System.Threading.Thread.AbortInternal()
   at System.Threading.Thread.Abort(Object stateInfo)
   at System.Web.HttpResponse.End()
   at System.Web.HttpServerUtility.Transfer(String path, Boolean preserveForm)
   at Microsoft.ReportingServices.UI.ReportingPage.ShowErrorPage(String errMsg) at    at System.Threading.Thread.AbortInternal()
   at System.Threading.Thread.Abort(Object stateInfo)
   at System.Web.HttpResponse.End()
   at System.Web.HttpServerUtility.Transfer(String path, Boolean preserveForm)
   at Microsoft.ReportingServices.UI.ReportingPage.ShowErrorPage(String errMsg)

Does any know what causes these errors.  They don't appear very often, but often enought for the users to complain.
 
-waslam

View Replies !   View Related
Request For The Permission Of Type 'System.Data.SqlClient.SqlClientPermission' Failed - Server Report
I am using embedded code in a server report to access information from a SQL database.  The report runs fine on my development computer but when I deploy to the server and attempt to run from there, I receive the following error:

Request for the permission of type 'System.Data.SqlClient.SqlClientPermission, System.Data, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089' failed.

 

Here is the sample code that generates the above error.

 

Public Function SayHello() As String
      Dim strAnswer as string
      Try
          Dim cnConn As New System.Data.SqlClient.SqlConnection
          cnConn.ConnectionString = strConnString
          cnConn.Open()
          cnConn.Close()
          cnConn = Nothing
          strAnswer = "Hello"
     Catch ex As Exception
          strAnswer = ex.message
     End Try

    Return strAnswer
   End Function

 

I would prefer not to have to create a seperate DLL for these routines as they aren't used anywhere else and are small in footprint.

Any suggestions?

Sheryl

 

View Replies !   View Related

Copyright © 2005-08 www.BigResource.com, All rights reserved