A Request To Send Data To The Computer Running IIS Has Failed

Dec 6, 2007

We have developed a Winmobile 5.0 application using VS2005 and Sql 2005 CE. We have successfuly installed the Server Agent on the web server and using the url 'http://websitename/rdatest/sqlcesa30.dll' have received an acknowledgement from the server agent. When we set up the Web Syncronization Wizard we kept things simple and opted for anonymous access. However, our Sql 2005 is based on a separate dedicated server which can be accessed by the web server. Our website, also written in VS2005, uses the following connection string to access the Sql 2005 database for our website.

"server=172.18.22.222; database=Audit; uid=steve; pwd=letmein"

When using the following code in our PDA application we have tried the above string as well as another interpretation with the same resulting error 'A request to send data to the computer running IIS has failed, for more information please see HResult'. The code we are using is..

Using rda As New SqlCeRemoteDataAccess()
Dim sCon As String = "Provider=SQLOLEDB;Data Source=172.18.22.222; Initial Catalog=Audit ; UserID=steve; Password=letmein"
Dim sCon As String = "server=172.18.22.222; database=Audit; uid=steve; pwd=letmein"
rda.InternetUrl = "http://websitename/rdatest/sqlcesa30.dll"
rda.LocalConnectionString = "Data Source=Program FilesTestSysTestdata.sdf"

Try
rda.Pull("Detail", "SELECT Details, Actions FROM Detail", sCon, RdaTrackOption.TrackingOff, "DtlErrors")
Catch sqlCeEx As SqlCeException
RecError( sqlCeEx.ToString)
End Try
End Using


Having tried both connection strings we feel the error is caused by something else possibly on our dedicated Sql server. Would really appreciate any help.

View 4 Replies


ADVERTISEMENT

Help Please...request To Send Data To The Computer Running IIS Has Failed

Apr 4, 2006

Hello,

   I am trying to complete the BOL sample "Creating a Mobile Application with SQL Server Mobile". Using SQL 2k5 and VS Team Suite. I have the emulator about to get on to the internet and can even get to the http://sqlce.domain.com/sqlmobile/sqlcesa30.dll url but when runing the vb.net code I get the error 28037 "A request to send data to the computer running IIS has failed. For more information, see HRESULT.". Any help would be greatly appreciated. No software firewalls are running. I have a dns entry that points to my laptop for testing. The sync function code is below.

Sub sync()

Dim repl As New SqlCeReplication()

repl.InternetUrl = "http://sqlce.domain.com/SQLMobile/sqlcesa30.dll"

repl.Publisher = "MY-LAPTOPDBSERVER"

repl.PublisherDatabase = "SQLMobile"

repl.PublisherSecurityMode = SecurityType.NTAuthentication

repl.Publication = "SQLMobile"

repl.Subscriber = "SQLMobile"

repl.SubscriberConnectionString = "Data Source='" + filename + "';Max Database Size=128;Default Lock Escalation =100;"

Try

repl.AddSubscription(AddOption.CreateDatabase)

repl.Synchronize()

Catch err As SqlCeException

MessageBox.Show(err.ToString)

End Try

End Sub

 

http://sqlce.domain.com/sqlmobile/sqlcesa30.dll?diag
SQL Server Mobile Server Agent Diagnostics
2006/04/04 15:28:51



General Information


Item
Value

Server Name
sqlce.domain.com

URL
/SQLMobile/sqlcesa30.dll

Authentication Type
Anonymous

Server Port
80

HTTPS
off

Server Software
Microsoft-IIS/5.1

Replication
Allowed

RDA
Allowed

Logging Level
1


Impersonation and Access Tests


Action
Status
ErrorCode

Impersonate User
SUCCESS
0x0

ReadWriteDeleteMessageFile
SUCCESS
0x0


SQL Server Mobile Modules Test


Module
Status
ErrorCode
Version

SQLCERP30.DLL
SUCCESS
0x0
3.0.5207.0

SQLCESA30.DLL
SUCCESS
0x0
3.0.5207.0


Reconciler Test


Reconciler
Status
ErrorCode

9.0 Database Reconciler
SUCCESS
0x0

8.0 Database Reconciler
SUCCESS
0x0


SQL Server Module Versions


Module
Version

sqloledb.dll
2000.85.1117.0

9.0 replrec.dll
2005.90.1399.0

9.0 replprov.dll
2005.90.1399.0

9.0 msgprox.dll
2005.90.1399.0

8.0 replrec.dll
2000.80.2039.0

8.0 replprov.dll
2000.80.2039.0

8.0 msgprox.dll
2000.80.2039.0

View 17 Replies View Related

A Request To Send Data To The Computer Running IIS Has Failed

Mar 28, 2006

Hi,

I Have an application for Pocket PC 2003 developed in Visual Studio 2003(VB.Net , Smart Device App). I Use Sql Server CE as the database which Synchronizes with Sql Server 2000, SP4. The IIS and the Sql Server 2000 are in different Machines. I Have Installed the proper Sqlserver Ce in the IIS machine and created virtual directory with Basic authentication.I connect my device through Active Sync 3.7. I could browse the sscesa20.dll from Pocket IE and get the ' SQL Server CE Server Agent ' message. The PC to which my pocket PC is connected is under a Proxy.

When I tried the RDA.Pull() , the function fails and returns the error
" Error Code: 80072EE7
A request to send data to the computer running IIS has failed. For more information see HRESULT. [,,,,,]
Minor Error : 28037
Source: Sql Server 2000 Windows CE Edition. "

The same application works in other network which is not under a proxy.

Any clues ?

Thanks,
Jibu
eSystem Software

View 11 Replies View Related

The 'A Request To Send Data To The Computer Running IIS Has Failed' Exception

Oct 27, 2005

Hi guys,

View 4 Replies View Related

A Request To Send Data To The Computer Running IIS Has Failed. For More Information, See HRESULT.

Jul 27, 2007

Hi,

My application is working under InternetUrl "http://servername/test/sqlcesa30.dll", but I am getting following error for "https://servername/test/sqlcesa30.dll"

"A request to send data to the computer running IIS has failed. For more information, see HRESULT."

We have proxy server top of the web server and certificate is installed on proxy server. There is no ceritificate installed on web server which is behind the firewall. Proxy server divert the request on different protocol based on "http" and "https" request and send to web server which is behind the firewall. I am not getting any error when i use RDA using http for above environment, but when i use RDA using https I am getting an above error for the same environment.

Can anyone help me to resolve this issue?

Thanks in advance

View 7 Replies View Related

Replication Error With Sqlserver Mobile:A Request To Send Data To The Computer Running IIS Is Failed, See Hrresult

Jan 27, 2006

I have smilar kind of an issue with replication. I had sucessfully done replication with Sqlce2.0 on sql server 2000. In development machine I had VS 2003, sqlce development tools.

Now I use the same code done in VS 2003 into VS2005, it sucessfully converted the code.

In server machine (win 2003) I installed sql server 2000, sql server 2000 service pack 4, SP4 merge replication components, sql server 2005 mobile server tools and .Net framework 2.0. Created pubication sucessfuly. In this machine I configured IIS as per the web synchronization wizard. Gave anyonymous permissions. Virual direcory is created sucessfully. I tested the server agent in IE http://myservername/aliasname/sqlcesa30.dll.

 SQL Server Mobile Server Agent 3.0 is shown

My application opened successfuly in windows mobile 5.0 Pocket PC emulator. When try to sync its dislays error "A request to send data to the computer running IIS is failed, see Hrresult"

No firewall in both development and server machines.

The same code works if its sqlce20 perfectly with vs2003 code. Not in this

Can anyone tell me whats wrong in this?

Regards

Arif

View 5 Replies View Related

Using Stored Procedure Send Web Request Failed

Mar 20, 2007

I am tring to use a stored procedure to run a function POST some data through HTTP, but failed. Here are the codes I used. Would appreciate if anyone can help me about that. Thank you very much.

Database Stored Procedure:

CREATE PROCEDURE [dbo].[USP_HTTP_POST]
 @URL NCHAR(255),
 @CONTENT NCHAR(1024),
 @Result bit OUTPUT
AS
BEGIN
/***** Call Function to POST *****/
set @Result = NULL
EXECUTE @Result = [dbo].[udfHttpPost]
  @URL,
 @Content
END

Database Function:

CREATE FUNCTION [dbo].[udfHttpPost]
(@Url [nchar](255),
@Content [nchar](1024))
RETURNS [bit] WITH EXECUTE AS CALLER
AS
EXTERNAL NAME [SqlServices].[SqlServices.HttpServices].[HttpPost]

VC# Assembly Code

using System;
using System.Configuration;
using System.Collections.Generic;
using System.Text;
using System.Net;
using System.Security;
using System.Security.Permissions;
using System.IO;
using Microsoft.SqlServer.Server;

namespace SqlServices
{
 public class HttpServices
 {
  [SqlFunction(DataAccess = DataAccessKind.None)]
  public static bool HttpPost(string Url, string Content)
  {
   Url = Url.TrimEnd();
   Content = Content.TrimEnd();
   string rawOutput = "";

   //Get Access Right to Web
   WebPermission p = new WebPermission(NetworkAccess.Connect,Url);
   p.Assert();

   //Prepare the WebRequest
   WebRequest Req = (WebRequest)WebRequest.Create(Url);
   Req.Timeout = 60000;
   Req.Method = "POST";
   Req.ContentLength = Content.Length;
   Req.ContentType = "application/x-www-form-urlencoded";

   StreamWriter PostWriter = new StreamWriter(Req.GetRequestStream());
   PostWriter.Write(Content);
   PostWriter.Close();

   WebResponse Resp = Req.GetResponse();
   StreamReader sr = new StreamReader(Resp.GetResponseStream());
   rawOutput = sr.ReadToEnd();
   sr.Close();
   return true;
  } 
 }
}

System Exception:

A .NET Framework error occurred during execution of user defined routine or aggregate 'udfHttpPost':
System.Security.SecurityException: Request for the permission of type 'System.Security.Permissions.SecurityPermission, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089' failed.
System.Security.SecurityException:
   at System.Security.CodeAccessSecurityEngine.CheckNReturnSO(PermissionToken permToken, CodeAccessPermission demand, StackCrawlMark& stackMark, Int32 unrestrictedOverride, Int32 create)
   at System.Security.CodeAccessSecurityEngine.Assert(CodeAccessPermission cap, StackCrawlMark& stackMark)
   at System.Security.CodeAccessPermission.Assert()
   at SqlServices.HttpServices.HttpPost(String Url, String Content)

 

View 6 Replies View Related

Authentication Failed At The Computer Running Iis

Apr 24, 2008

Im getting this error when I try to synchronize my mobile client with SQL Server Compact 3.5 with my SQL Server 2005 database: "Authentication failed at the computer running iis"

Im debugging through a WM5-device in Device Manager 3.0. I have verified that Internet Explorer on the device manager can reach the synchronization agent. But the same credentials that I use there won´t work in my application.

Im using this code for the synchronization.

Dim repl As SqlCeReplication = New SqlCeReplication()

Try

repl.InternetUrl = "http://192.168.0.115/Sync/sqlcesa35.dll"

repl.InternetLogin = _txtUser.Text
repl.InternetPassword = _txtUser.Text
repl.Publisher = "Name"
repl.PublisherDatabase = "Mydatabase"
repl.PublisherLogin = _txtUser.Text
repl.PublisherPassword = _txtUser.Text
repl.Publication = "My Publicationl"
repl.Subscriber = "MySubscriber"
repl.SubscriberConnectionString = "Data Source=" + (System.IO.Path.GetDirectoryName(System.Reflection.Assembly.GetExecutingAssembly().GetName().CodeBase)) + "DataAppDatabase.sdf;" 'Persist Security Info=False"

repl.AddSubscription(AddOption.ExistingDatabase)
repl.Synchronize()


MessageBox.Show("Sync completed")


Catch SQLEx As SqlCeException

End Try

View 1 Replies View Related

Authentication Failed On The Computer Running IIS?

Jan 29, 2008

Hi Friends,

I am currently trying to develop a small Windows Mobile Application with SQL server Mobile edition.



To develop this , I followed this link http://msdn2.microsoft.com/en-us/library/aa454892.aspx



As I dint find Vendors.sdf database I created My own Database with student table. My database name is MyDB. I created both Mobile database (.sdf) and the same database in sql server 2005



when I run the application I can update the database upto the mobile with no problem. But when I try to Sync I am facing the following exception at the following code.



private void SyncVendors()

{

if (File.Exists(this.DataFileName))

{

this.SaveData();

_repl.Synchronize(); //exception is raised at this line

this.GetData();

}

else

MessageBox.Show("The subscription database has not yet been created. You must first select the Init Sync menu item.");

}



For the replication I used



private void InitReplication()

{

_repl.InternetUrl = @"http://XXXXXXXX/MyDB/sqlcesa30.dll";\ for security reasons I am not using my system name

_repl.Publisher = @"XXXXXXXXX";

_repl.PublisherDatabase = @"MyDB";

_repl.PublisherSecurityMode = SecurityType.NTAuthentication;

_repl.Publication = @"MyDB";

_repl.Subscriber = @"MyDB";

_repl.SubscriberConnectionString = this.DataSourceConnectionString;

_repl.LoginTimeout = 120;
//_repl.InternetLogin = "XXXXXXXXXXXXXXXXXXXX€?; //Timely I used these 2

//_repl.InternetPassword = "XXXXXX€?;

}



"An unhandled exception of type 'System.Data.SqlServerCe.SqlCeException' occurred in System.Data.SqlServerCe.dll

Additional information: Failure to connect to SQL Server with provided connection information. SQL Server does not exist, access is denied because the IIS user is not a valid user on the SQL Server, or the password is incorrect."



Or (Some times when I change the Directory Security in IIS)



An unhandled exception of type 'System.Data.SqlServerCe.SqlCeException' occurred in System.Data.SqlServerCe.dll

Additional information: Authentication failed on the computer running IIS







I tried in many ways like
Ø Resetting the firewalls ( to web server(http))
Ø In sql server I set " using both TCT/IP and named pipes
Ø In IIS virtual directory--> directory security à settings I used anonymous, base authentication, integrated Authentication. The same exception with any authentication.
Ø SQL Server Management studio à view à Registered Server Types à SQL Server Mobile. Here I added my data base MyDB.sdf.
Ø SQL Server CE Connectivity Management à selected my database à and select authentications




this is my log in virtual directory

2008/01/28 14:37:11 Hr=80004005 ERROR OpenDB failed getting pub version 28627
2008/01/28 17:05:08 Hr=80004005 ERROR OpenDB failed getting pub version 28627
2008/01/28 17:12:16 Hr=80004005 ERROR OpenDB failed getting pub version 28627
2008/01/28 17:33:35 Hr=80004005 ERROR OpenDB failed getting pub version 28627


can any one please help me?

Thanks in Advance.

View 5 Replies View Related

How To Send And Receive Data, Between Two Separate Computer?

Jul 23, 2005

hi alli have a web application on a web server.and another windows application on another computer.there are databases on each of them.how can i send and receive data between these two applications?please reply me as soon as possibleregards

View 5 Replies View Related

XML Request (send) And XML Response (receive) Data Thru BIZTALK 2006.

Oct 2, 2007

I am new to BIZTALK 2006; Please help me get started as below>>
I have XML Request (send) and XML Response (receive) data;
What are the steps needed for this to be accomplished in BizTalk to create webservice for this?
THX

View 3 Replies View Related

The Request Failed With HTTP Status 400: Bad Request. (Microsoft.SqlServer.Management.UI.RSClient)

Feb 23, 2008

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

Failed To Retrieve Data For This Request.

Apr 18, 2007

I am trying to load data into a SQL Server table through a web page. I am getting error like this:

Error: A transport-level error has occurred when receiving results from the server. (provider: TCP Provider, error: 0 - The specified network name is no longer available.)



I am doing the same for other tables in the same db its working fine. but its working for one table alone. The table name is like this (DTD_PUMA_DeliveryPerformance)

Is it cos of table name???

I tried with import/export wizard also its working fine but still its not working for web page.

I don t think its cos of network or OS!! Its with table or some connection property.Pls help me in solving this.

View 3 Replies View Related

Failed To Retrieve Data For This Request. (Microsoft.SqlServer.SmoEnum)

Nov 19, 2007

hi,

I´m trying to connect to a integration service hosted in a different machine, but I recive the following message:

Failed to retrieve data for this request. (Microsoft.SqlServer.SmoEnum) : access denied

I verified and the service that machine is running, maybe could be the user, I´m using windows authentication, I have no problems when I log in in the databse engine.

Can somebody help me??











View 1 Replies View Related

Failed To Retrieve Data For This Request. (Microsoft.SqlServer.SmoEnum)

May 5, 2006

After getting an RPC error when trying to login to my server via either consol or Terminal services, then rebooting, I can no longer connect to SSIS



Failed to retrieve data for this request. (Microsoft.SqlServer.SmoEnum)

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&LinkId=20476

------------------------------

Connect to SSIS Service on machine "BG-22SQL" failed:
The service did not respond to the start or control request in a timely fashion.
.


------------------------------

Connect to SSIS Service on machine "BG-22SQL" failed:
The service did not respond to the start or control request in a timely fashion.
.


View 1 Replies View Related

Request For The Permission Of Type 'System.Data.SqlClient.SqlClientPermission' Failed In MOSS 2007

Dec 6, 2007



Hi,

I have created a web part in ASP.Net. this web part is extracting data from the sql server database and displaying it on the web part page.
This web part is working fine with asp.net application, but when i deploy it with MOSS. it is reaising security exception error like.

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

I have made the entry under the safe control list of web.config file. but still i am getting error any suggestion wud be highly appreciable..

pls reply me on sanjiv.singh@kpitcummins.com.

thanks you so much.

Regards,
Sanjiv Singh

View 5 Replies View Related

How To Send Alert To A Particular Computer From Frontend

Apr 27, 2002

hi,

I am using Sql server 7.0.When i insert or update a record in a table,i need to
show a message in the front end ,that one record is added to the table.
I have written the queries for insertion and updation into the table in a storedprocdure.
Is there any way to return something from a storedprodure ,so that i can show a
message in the frontend, that a record is updated by someone..the updation will be
done in one machine(clerk's machine in bank) and the message should be shown in another machine(manger's machine in bank) who has more administrative power on the system.
does 'alert' in sql server help this.
Delphi is my frontend.

help

paul

View 2 Replies View Related

Send HTTP Request Using SQL Sever 2005

Apr 16, 2007

I have Lotus Notes Database which stores employee database. If I request following http URL on browser, which fetch data from Lotus Notes Database and response me following XML text. I need to pass some id as a parameter in HTTP request to retrieve particular data.

HTTP Request:
http://kernel.com/global/corp/ecd.nsf/xmlemployeesactivebyguid?readviewentries&StartKey=sesa249&count=1

HTTP Response:
<?xml version="1.0" encoding="UTF-8" ?>
<viewentries toplevelentries="53656">
<viewentry position="14310" unid="FC86BCB9224169F4C12570AD005A775C" noteid="D9FA2" siblings="53656">
<entrydata columnnumber="0" name="GUID">
<text>SESA24941</text>
</entrydata>
</viewentry>
</viewentries>

I need to send this http request programmatically. To do that,

1) Is thr any functionality in SQL Server 2005, which can send http request to any other server like LOTUS NOTES
2) If not,thn do you know how to do it programmatically using c# ?

When U have some time, let me know. Thanks in advance man.

Satyam

View 4 Replies View Related

Where Can I Send An Enhancement Request For Reporting Services

Aug 10, 2007



Hi All,



I looked around the Microsoft web sites but could not find anything on how to submit an enhancement request for Microsoft Reporting Services. I would like to request the ability to prevent exporting of a report without having to disable exports for all reports on the reporting server. In other words I would like certain reports to be exportable but others not.



Thanks,

View 6 Replies View Related

Transact SQL :: Send Changed Database Record To Computer

Apr 21, 2015

I have an online SQL Server database, and my web site registered clients can change the records of this database. My need: if a record of this database is changed, whole the changed record send to me and to the person who changed it immediately. I thought it could be possible through Transact-SQL,

View 2 Replies View Related

An Error Has Occurred On The Computer Running IIS

May 16, 2006

Hello All,

I'm developing pocket PC application.. when I want to replicate my data from pocket pc to development pc.. I've got this error on my pocket pc.. "An error has occurred on the computer running IIS"

Any ideas? Any help?

I'm using SQl Server 2000, SQL Server CE 2.0, VS.Net 2003



Thanks

View 3 Replies View Related

An Error Has Occurred On The Computer Running IIS

Feb 4, 2006

Hi, i was following the tutorial in SQL Mobile Books online "Creating a Mobile Application with SQL Server Mobile ", but when i try to run the application using the pocket PC 2003 emulator, the got the following error, "An error has occurred on the computer running IIS, Try restarting the IIS server.", any idea why?

View 13 Replies View Related

Running SQL Server 2000 And 2005 On The Same Computer

Nov 4, 2005

Does anyone know whether or not both versions can be installed on the same machine?

View 1 Replies View Related

How To Check Using If SQL Server Is Running On A Remote Computer

Jan 21, 2004

I am about designing an access project file that connect to a SQL Server database : it could be either on the local computer or a remote workstation, this depending on where the front end is running.

Bypassing the default log on dialog box i have set my own form that users should use to connect on adp. Then using baseconnection string i connect the adp to sql server database.

My concern is how can i check from vba if the instance of SQL Server where my back end database is located is running in order to make
users knowing that due sql server service status off their connection
tentative will fail.

inform u i can check same from console management however i would to automate same controle from my adp and avoid that users have to operate such task...

View 4 Replies View Related

The Request Failed With The Error Message

Aug 27, 2007



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

Reporting Services :: How To Retrieve Computer Name Of The Person Running A Report

Oct 9, 2009

How can I identify the computer of the person running an SRS report?  If I query HOST_NAME() it gives me the host of the reporting server, not the person browsing.So, for example, Melissa opens a browser from computer named AAA to the SRS and pulls up her report.  How do I get that report to show that the user is browsing from AAA?

View 12 Replies View Related

Login Failed For User '&&<DOMAIN&&>&&<COMPUTER&&>$'

May 20, 2008



In an attempt to improve security for our web server/db server setup, we have a SQL Server 2005 server set for Windows authentication only and a web server (both behind a firewall together on a single local domain).

The web server is using IIS7, and the default NetworkService account to run the ASP.NET processes.

I've given the NT AUTHORITYNETWORK SERVICE account access to the database in question.

The SQL authentication fails, but the account failing is NOT the NetworkService account, but the <DOMAIN><COMPUTER>$ account.

Note that if I use identity impersonation with a specific domain account, I can get the app to work. However, I do NOT want to use impersonation, I want the default NetworkService account to work.

Does anyone know why IIS, which is supposed to be using NetworkService, is instead using the <DOMAIN><COMPUTER>$ account to connect to SQL, which is then failing?

JK

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

Send Request To Stored Procedure From A Method And Receive The Resposne Back To The Method

May 10, 2007

Hi,I am trying to write a method which needs to call a stored procedure and then needs to get the response of the stored procedure back to the variable i declared in the method. private string GetFromCode(string strWebVersionFromCode, string strWebVersionString)    {      //call stored procedure  } strWebVersionFromCode = GetFromCode(strFromCode, "web_version"); // is the var which will store the response.how should I do this?Please assist.  

View 3 Replies View Related







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