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??
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.
.
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
Hi
First up - my apologies if this is not the right forum for this question. Please let me know if there is a more appropriate one for this question.
I have come across an issue with my SQL Server 2005 Express Edition install. It has been running fine since the install (a few months back). And I can still interact (query, update etc) the databases just fine. However, SQL Management Server Studio Express has started to produce an error message when I attempt to connect the Object Explorer.
The error message is shown below.
I have tried to access the link shown in the error message but there is no information provided there.
I can use SQL Management Server Studio Express to run queries on the databases so it would appear that the underlying services are all running OK.
The SQL Server is installed using SQL Authentication only and I have not made any changes to Service accounts or the services themselves. The protocols all appear to be in order too - Shared Memory, Named Pipes, TCP/IP are all enabled.
I have restarted the SQL services and even rebooted the machine, but to no avail.
I would really appreciate if anyone out there could give me some guidance on what may be causing this issue.
Note: The SQL Server is installed on WinXP Pro SP2 running in a VirtualPC. All apps are release versions (no beta or CTP)
TITLE: Microsoft SQL Server Management Studio Express
------------------------------
Failed to retrieve data for this request. (Microsoft.SqlServer.Express.SmoEnum)
For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&LinkId=20476
------------------------------
ADDITIONAL INFORMATION:
An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.Express.ConnectionInfo)
------------------------------
A severe error occurred on the current command. The results, if any, should be discarded.
A severe error occurred on the current command. The results, if any, should be discarded. (Microsoft SQL Server, Error: 0)
For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&EvtSrc=MSSQLServer&EvtID=0&LinkId=20476
------------------------------
BUTTONS:
OK
------------------------------
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,
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.
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
Hi all,
I need your help on the following:
I can't connect to Reporting Services from SQL Server Management Studio. I get the following error message:
"No connection can be made with SERVER. Additional information: Error at request with HTTP-Status 400: Bad Request (Microsoft.SqlServer.Management.UI.RSClient)"
What is wrong?? I'm running SQL Server 2005 SP2 on Windows Server 2003 hosting on an internet server.
Thanks in advanced!!
CarRoussel
I'm installing Windows Small Business Server 2003 R2 Premium. I am at the stage where I am installing the Premium Technologies. Specifically, I am trying to configure permissions for the new SHAREPOINT instance of SQL Server 2005. When I try to create the new login NT AuthorityNetwork Service, typing it exactly as specified in the instructions, I get the following error:
Create failed for Login 'NT AUTHORITYNetwork Service' (Microsoft.Sqlserver.Smo)
For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=9.00.1399.00&EvtSrc=Microsoft.SqlServer.Management.Smo.ExceptionTemplates.FailedOperationExceptionText&EvtID=Create+Login&LinkId=20476
------------------------------
ADDITIONAL INFORMATION:
An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo)
------------------------------
Windows NT user or group 'NT AUTHORITYNetwork Service' not found. Check the name again. (Microsoft SQL Server, Error: 15401)
For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=09.00.1399&EvtSrc=MSSQLServer&EvtID=15401&LinkId=20476
------------------------------
BUTTONS:
OK
------------------------------
The following links yielded nothing:
http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=9.00.1399.00&EvtSrc=Microsoft.SqlServer.Management.Smo.ExceptionTemplates
http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=09.00.1399&EvtSrc=MSSQLServer&EvtID=15401&LinkId=20476
Does anyone know what's causing this? I've done a few installs of SBS R2 Premium and this is the first time I encountered this.
I am trying to connect to SQL Server 2005 Express with JDBC. I am getting the following exception:
Code SnippetString connectionUrl = "jdbc:sqlserver://localhost:1433;" +
"databaseName=IFC3;";
// Declare the JDBC objects.
Connection con = null;
Statement stmt = null;
ResultSet rs = null;
try {
// Establish the connection.
Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");
con = DriverManager.getConnection(connectionUrl,"ifc2","password");
com.microsoft.sqlserver.jdbc.SQLServerException: The TCP/IP connection to the host has failed. java.net.ConnectException: Connection refused: connect
at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDriverError(Unknown Source)
at com.microsoft.sqlserver.jdbc.SQLServerConnection.connectHelper(Unknown Source)
at com.microsoft.sqlserver.jdbc.SQLServerConnection.loginWithoutFailover(Unknown Source)
at com.microsoft.sqlserver.jdbc.SQLServerConnection.connect(Unknown Source)
at com.microsoft.sqlserver.jdbc.SQLServerDriver.connect(Unknown Source)
at java.sql.DriverManager.getConnection(DriverManager.java:512)
at java.sql.DriverManager.getConnection(DriverManager.java:171)
at connectURL.main(connectURL.java:43)
I am using the code example that came from Microsoft for making a JDBC connection. I looked at my configuration of SQL Server and change to use a static port 1433. I shut off Windows firewall to make sure it was not blocking communication.
When I try to telnet to port 1433 it says
Connecting To 1433...Could not open connection to the host, on port 23: Connect
failed
Any suggestions?
Thanks,
Tom
ADDITIONAL INFORMATION:
System.Data.SqlClient.SqlError: The operating system returned the error '5(Access is denied.)' while attempting 'RestoreContainer::ValidateTargetForCreation' on 'c:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLAlamoDB.mdf'. (Microsoft.SqlServer.Express.Smo)
--------------------------------
Hi,
I got this error while trying to restore my database (which was running on SQL Server 2005 Express Edition) onto another machine's SQL Server 2005 Express Edition.
Can anyone plz. help me out with this error.
Thanks & Regards
Trinadh P.
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
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.
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
Hi guys,
View 4 Replies View RelatedHi,
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
I am getting the above error when I try to create Notificatioin services new Instance.
Additional Information is
Failed to connect to server ABC(Microsoft.SqlServer.ConnectionInfo)
An error occured while establishing connection to the server.When connecting to SQL Server 2005, this failure may be caused by the fact that under default settings SQL Server deoes not allow remote connections.(Provider : Named Pipes Provider, error 40 -could not open connection to SQL Server)(Microsoft SQL Server error: 53)
Please help me I am new to SQL Server 2005.I can't able to proceed.
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
I have a custom (dataset) destination component from ms samples and it has an input holds DT_NTEXT value.
Whenever I try to retrieve data from this it returns "Microsoft.SqlServer.Dts.Pipeline.BlobColumn" as value.
I try this but didn't work:
String sValue = System.Text.Encoding.Default.GetString(Convert.FromBase64String(this.dataSet.Tables[0].Rows["Data"].ToString()));
It throws an execption "invalid character in.."
Please help how I can convert this?
Thanks in advance
Hi,
We have a SSIS project where we load lot of image files using an OLE DB Source component and put it across the database as varbinary into OLEDB Destination component.
Things were fine until now where am getting an error like this. alongside the log also reads like,
There is not enough space on the disk. Long data was retrieved and can't be added to the data flow task buffer.
SSIS Error Code: DTS_E_InducedTransformFailureOnError.
Is this method of loading the files using an OleDb Souce not the efficient one ? If not is there a way I can get this done. Comments are highly appreciated!!
Thanks in Advance
when using the microsoft.sqlserver.dts.runtime to create packages programatically....
what object represents a data flow task?
I've looked through msdn and found an example, but it doesn't work. The problem is that when i use such construction
ResultSet rs1 = stmt.executeQuery("SELECT TOP 1 * FROM sys.check_constraints");
rs1.next();
Reader reader = rs1.getCharacterStream(17);
reader is set to null,but it mustn't be null cause i see some data through management studio in 17th column of sys.check_constraints table.
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
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.
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.
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.
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)
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
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
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");
"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
Having an issue updating SQL Server 2012 RTM Standard  to CU3.I'm getting the following error from the Detail log on each try: "Error: Failed to run patch request for instance: MSSQLSERVER (exit code: -2061893565)"I've tried rebooting the server, ensuring the user running the installer is a local admin account, ran the repair wizard on the SQL install...Nothing seems to work.I have two identical servers, the first has gone smoothly, this is bugging me...
Server: Dell R720XD, Dual E5-2643 CPU, 64Gb RAM, Windows Server 2008 R2 Enterprise x64, SQL Server 2012 RTM CU2 x64 Installed.
Final result: The patch installer has failed to update the following instance: MSSQLSERVER. To determine the reason for failure, review the log files.
 Exit code (Decimal):      -2061893565
 Start time:           2012-09-17 16:25:32
 End time:            2012-09-17 16:28:41
 Requested action:        Patch
Instance MSSQLSERVER overall summary:
 Final result:          The patch installer has failed to update the shared features. To determine the reason for failure, review the log files.
 Exit code (Decimal):      -2061893565
 Start time:           2012-09-17 16:27:21
 End time:            2012-09-17 16:28:39
 Requested action:        Patch
[code]...
hi all
i hav a database with some images...images r stored in binary data form
i want to retrieve that image from database and display it in a details View
im inserting images to database like this
public void OnUpload(Object sender, EventArgs e)
{
int len = Upload.PostedFile.ContentLength;
byte[] pic = new byte[len];
Upload.PostedFile.InputStream.Read (pic, 0, len);
SqlConnection connection = new SqlConnection ("integrated Security=SSPI;Persist Security Info=False;Initial Catalog=dbAsoftWeb;Data Source=ASP");
try
{
connection.Open ();
SqlCommand cmd = new SqlCommand("insert into tblStock " + "(Image, Image_Data,[DESC],PRICE,BAL_QTY,PV) values (@pic, @text, @lblProd, @lblPrice, @lblPV, @lblQty) ", connection);
cmd.Parameters.Add("@pic", pic);
cmd.Parameters.Add("@text", Comment.Text);
cmd.Parameters.Add("@lblProd", txtProdName.Text);
cmd.Parameters.Add("@lblPrice", txtPrice.Text);
cmd.Parameters.Add("@lblPV", txtPV.Text);
cmd.Parameters.Add("@lblQty", txtQty.Text);
cmd.ExecuteNonQuery ();
}
finally
{
connection.Close ();
}
im able to get the image in to form but i want to display it in a detailsview
how cani do it..can any one explain me
thanks in advance
Hari