Here is the full message from the Event Log.
Failed to initialize Distributed COM (CoInitializeEx returned 80010119). Heterogeneous queries and remote procedure calls are disabled. Check the DCOM configuration using Component Services in Control Panel.
Any ideas as to how to troubleshoot or solve this?
Thanks!
I'm receiving this error message when trying to install SQL Server 2005 Express Edition on Windows Vista Home Premium:
Product: Microsoft SQL Server 2005 Express Edition -- Error 29521. SQL Server Setup failed to execute a command for server configuration. The error was [Microsoft][SQL Native Client][SQL Server]The server could not load DCOM.. Refer to the server error logs and Setup logs for detailed error information.
In the ERRORLOG file, the error is:
Failed to initialize Distributed COM (CoInitializeEx returned 80010119). Heterogeneous queries and remote procedure calls are disabled. Check the DCOM configuration using Component Services in Control Panel.
There is no Component Services in the Control Panel. Do they just mean Services? If so, how do you configure DCOM in the Services?
Thanks in advance for your help!
Below is the complete ERRORLOG:
2007-12-06 11:16:09.69 Server Microsoft SQL Server 2005 - 9.00.3042.00 (Intel X86)
Feb 9 2007 22:47:07
Copyright (c) 1988-2005 Microsoft Corporation
Express Edition on Windows NT 6.0 (Build 6000: )
2007-12-06 11:16:09.72 Server (c) 2005 Microsoft Corporation.
2007-12-06 11:16:09.72 Server All rights reserved.
2007-12-06 11:16:09.72 Server Server process ID is 5672.
2007-12-06 11:16:09.72 Server Authentication mode is MIXED.
2007-12-06 11:16:09.72 Server Logging SQL Server messages in file 'c:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLLOGERRORLOG'.
2007-12-06 11:16:10.31 Server Registry startup parameters:
2007-12-06 11:16:10.31 Server -d c:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLDATAmaster.mdf
2007-12-06 11:16:10.31 Server -e c:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLLOGERRORLOG
2007-12-06 11:16:10.31 Server -l c:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLDATAmastlog.ldf
2007-12-06 11:16:10.31 Server Command Line Startup Parameters:
2007-12-06 11:16:10.31 Server -m SqlSetup
2007-12-06 11:16:10.31 Server SqlSetup
2007-12-06 11:16:10.31 Server -Q
2007-12-06 11:16:10.31 Server -q SQL_Latin1_General_CP1_CI_AS
2007-12-06 11:16:10.31 Server -T 4022
2007-12-06 11:16:10.31 Server -T 3659
2007-12-06 11:16:10.31 Server -T 3610
2007-12-06 11:16:10.31 Server -T 4010
2007-12-06 11:16:10.38 Server SQL Server is starting at normal priority base (=7). This is an informational message only. No user action is required.
2007-12-06 11:16:10.38 Server Detected 2 CPUs. This is an informational message; no user action is required.
2007-12-06 11:16:10.53 Server Using dynamic lock allocation. Initial allocation of 2500 Lock blocks and 5000 Lock Owner blocks per node. This is an informational message only. No user action is required.
2007-12-06 11:16:10.67 Server The time stamp counter of CPU on scheduler id 1 is not synchronized with other CPUs.
2007-12-06 11:16:10.71 Server Database Mirroring Transport is disabled in the endpoint configuration.
2007-12-06 11:16:10.73 spid4s Warning ******************
2007-12-06 11:16:10.73 spid4s SQL Server started in single-user mode. This an informational message only. No user action is required.
2007-12-06 11:16:10.73 spid4s Starting up database 'master'.
2007-12-06 11:16:10.91 spid4s Recovery is writing a checkpoint in database 'master' (1). This is an informational message only. No user action is required.
2007-12-06 11:16:11.02 spid4s SQL Trace ID 1 was started by login "sa".
2007-12-06 11:16:11.07 spid4s Starting up database 'mssqlsystemresource'.
2007-12-06 11:16:11.09 spid4s The resource database build version is 9.00.3042. This is an informational message only. No user action is required.
2007-12-06 11:16:11.69 spid4s Password policy update was successful.
2007-12-06 11:16:11.71 spid7s Starting up database 'model'.
2007-12-06 11:16:11.71 spid4s Server name is 'FRANK-LAPTOP-PCSQLEXPRESS'. This is an informational message only. No user action is required.
2007-12-06 11:16:11.71 spid4s Starting up database 'msdb'.
2007-12-06 11:16:12.48 spid7s Clearing tempdb database.
2007-12-06 11:16:12.59 Server A self-generated certificate was successfully loaded for encryption.
2007-12-06 11:16:12.60 Server Server local connection provider is ready to accept connection on [ \.pipeSQLLocalSQLEXPRESS ].
2007-12-06 11:16:12.60 Server Dedicated administrator connection support was not started because it is not available on this edition of SQL Server. This is an informational message only. No user action is required.
2007-12-06 11:16:12.62 Server SQL Server is now ready for client connections. This is an informational message; no user action is required.
2007-12-06 11:16:13.15 spid7s Starting up database 'tempdb'.
2007-12-06 11:16:13.31 spid4s Recovery is complete. This is an informational message only. No user action is required.
2007-12-06 11:16:17.13 spid51 Setting database option RECOVERY to SIMPLE for database model.
2007-12-06 11:16:17.46 spid51 Configuration option 'show advanced options' changed from 0 to 1. Run the RECONFIGURE statement to install.
2007-12-06 11:16:17.53 spid51 Configuration option 'default language' changed from 0 to 0. Run the RECONFIGURE statement to install.
2007-12-06 11:16:17.53 spid51 Configuration option 'default full-text language' changed from 1033 to 1033. Run the RECONFIGURE statement to install.
2007-12-06 11:16:17.55 spid51 Configuration option 'show advanced options' changed from 1 to 0. Run the RECONFIGURE statement to install.
2007-12-06 11:16:18.28 spid51 Setting database option NEW_BROKER to ON for database tempdb.
2007-12-06 11:16:18.37 spid51 Setting database option NEW_BROKER to ON for database msdb.
2007-12-06 11:16:18.65 spid51 Configuration option 'show advanced options' changed from 0 to 1. Run the RECONFIGURE statement to install.
2007-12-06 11:16:18.66 spid51 Configuration option 'user instances enabled' changed from 1 to 1. Run the RECONFIGURE statement to install.
2007-12-06 11:16:18.68 spid51 Configuration option 'show advanced options' changed from 1 to 0. Run the RECONFIGURE statement to install.
2007-12-06 11:16:21.64 Server Error: 17102, Severity: 16, State: 1.
2007-12-06 11:16:21.64 Server Failed to initialize Distributed COM (CoInitializeEx returned 80010119). Heterogeneous queries and remote procedure calls are disabled. Check the DCOM configuration using Component Services in Control Panel.
2007-12-06 11:20:10.69 Server CPU time stamp frequency has changed from 52964 to 1017280 ticks per millisecond. The new frequency will be used.
2007-12-06 11:24:10.70 Server CPU time stamp frequency has changed from 1017280 to 1144761 ticks per millisecond. The new frequency will be used.
2007-12-06 11:32:10.70 Server CPU time stamp frequency has changed from 1144761 to 1030017 ticks per millisecond. The new frequency will be used.
2007-12-06 12:05:17.64 spid4s SQL Server is terminating in response to a 'stop' request from Service Control Manager. This is an informational message only. No user action is required.
2007-12-06 12:05:17.64 spid4s SQL Trace was stopped due to server shutdown. Trace ID = '1'. This is an informational message only; no user action is required.
When I boot my computer (Windows Home Premium 64bit) there is a pop up that says "Configuration System failed to initialize" and I don't know what might cause this..
View 2 Replies View RelatedI have a procedure that works fine from SSMS but sometimes fails when running via SQL Agent. The SP sends emails..Here is the error message "Failed to initialize sqlcmd library with error number -2147467259"
<p>Javier Villegas | <a href="http://www.twitter.com/javier_vill" target="_blank" title="Twitter" rel="nofollow"> @javier_vill</a> |Â <a href="http://sql-javier-villegas.blogspot.com/"
rel="nofollow">http://sql-javier-villegas.blogspot.com/</a></p>.
Hi, I am working on vs2005 with sql server 2000. I have used TransactionScope class. Example Reference: http://www.c-sharpcorner.com/UploadFile/mosessaur/TransactionScope04142006103850AM/TransactionScope.aspx The code is given below. using System.Transactions; protected void Page_Load(object sender, EventArgs e) { System.Transactions.TransactionOptions transOption = new System.Transactions.TransactionOptions(); transOption.IsolationLevel = System.Transactions.IsolationLevel.ReadCommitted; transOption.Timeout = new TimeSpan(0, 2, 0); using (System.Transactions.TransactionScope tranScope = new System.Transactions.TransactionScope(TransactionScopeOption.Required,transOption)) { using (SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["nwConnString"].ConnectionString)) { int i; con.Open(); SqlCommand cmd = new SqlCommand("update products set unitsinstock=100 where productid=1", con); i = cmd.ExecuteNonQuery(); if (i > 0) { using (SqlConnection conInner = new SqlConnection(ConfigurationManager.ConnectionStrings["pubsConnString"].ConnectionString)) { conInner.Open(); SqlCommand cmdInner = new SqlCommand("update Salary set sal=5000 where eno=1", conInner); i = cmdInner.ExecuteNonQuery(); if (i > 0) { tranScope.Complete(); // this statement commits the executed query. } } } } // Dispose TransactionScope object, to commit or rollback transaction. } } It gives error like
"The partner transaction manager has disabled its support for remote/network transactions. (Exception from HRESULT: 0x8004D025)" The database I have used is northwind database and pubs database which is by default in sql server 2000. So, Kindly let me know how to proceed further. Thanks in advance,Arun.
have SQL Server 2005 std edition SP1 installed on Windows 2003 Std edition .Configured Transactional (single Publisher and no clustered environment.)
Replication past two months working fine, Now
1.Distrib.exe application err is coming.
Due to which my job is failing (Distributor to Subscriber).
Iam attaching thw file.
Thanks
Sandeep
Hello,
I have a bundling package that runs about 20 other packages. It has been working fine for a while but a couple of days ago it fail with the following message,
Error 0x800706BE while loading package file "D:PackagesToradSales.dtsx". The remote procedure call failed.
I´m running the SSIS packages in an 64-bit environment.
Thankful for help with this!
//Patrick
This is the message I get when I try to create a report that has a lot of fields, I'm guessing that might be the problem.
Warning 1 Deserialization failed: The value must be between 0cm and 406.34921cm.
Parameter name: Width Line 10, position 30. 10 0
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
hi,
I'm working on "MERGE REPLICATION"...i followed the procedure same as the book
"SQL SERVER CE DATABASE DEVELOPMENT WITH the .NET COMPACT FRAMEWORK"Author Rob Tiffany, ch9,10
i got one error msg that..."a request to send data to the computer funning IIS failed,for more information seeHRESULT " ..When my program hits rep.Syncronize()...
here my codes
\\\\\\\\\\\
rep = New SqlCeReplication
rep.InternetUrl= "https://seawolf/fieldagentrda/sscesa20.dll"
rep.InternetLogin = "robtiffany"
rep.InternetPassword = "pinnacle"
rep.Publisher = "seawolf"
rep.PublisherDatabase = "IntelligenceData"
rep.PublisherLogin = "sa"
rep.PublisherLogin = "apress"
rep.Publication = "IntelligenceDataPublication"
rep.Subscriber = "subscriber"
rep.SubscriberConnectionString="Datasource=My Documents" & _"IntelligenceData.sdf;" & _ "SSCE:Database Password=apress"
If File.Exists("MyDocumentsIntelligenceData.sdf") Then
rep.Synchronize()
Else
MessageBox.Show("You must first create a database", "Error")
End If
\\\\\\\\\\\\\\\\\\\
can anyone help me ,how to solve this issue?
Thanks in advance
When try to run report, I receive this message:€œLogon failed.
For more information about this error navigate to the report server on the local server machine, or enable remote errors
We just have Reporting Services server (2005) up and running, my roles are browser, Content Manager, My Reports, Publisher, Report Builder. I was able to deployed the report and set up data source. Connect using credentials supplied by suer running the report, and use as Windows credentails when connecting to the data source checked.
Did a search on but can't find any messages that related to this problem.
Please advise.
When i try to open Sql Server Enterpris Manager the following error msg appers
Snap-in Failed to initialize
Name- unknown
CLSID{--}
how to solve this pbm help me very urgent
I am getting this problem when I try to open a DTS package.
MMC: Snap-in Failed to Initialize: Name: Meta Data Services:
CLSID(xxxxxxxxxxx)
Have anyone encountered this problem?
Lystra
I have problem with sql server configuration tool. it can not be opened
View 3 Replies View RelatedRe: SQL Server 2000 Developer Edition
Error message: Setup failed to configure the server
I'm attempting to install SQL Server 2000 Developer Edition on a 2nd workstation in our area for development and practice with having this 2nd workstation as a "local" (test) SQL Server box. The install fails with the above mentioned message. (We have a database running in production on SQL Server 2000 and we need a place to simply copy the database and run tests on it)
The target PC is running WInXP Pro-SP3 and has IIS installed, along with Visual Studio 2005 & .Net framework, etc.
I downloaded it (via MSDN license) and accepted the defaults on the install.
Any feedback is appreciated.
Thanks,
RLN
Hi when I am performing a merge replication between my PDA (SQL CE) and SQL I get the above message. There is no information about it anywhere.
Any ideas?
Thanks in advance.
Hi,
I can't seem to fix the following error in my stored procedure.
Error Message: Conversion failed when converting the nvarchar value '1007-001' to data type int.
The line of code in my stored procedure that seems to be the problem is the following:
CASE WHEN [Order Details].[Job No] IS NULL THEN [Orders].[Order No] ELSE [Order Details].[Job No] END
Order No has a data type of INT and Job No has a data type NVARCHAR(8). In the above case statement i'm not trying to convert anything but just display a column depending on the out come of the case statement. If anyone knows how to get around this error you help would be very welcome.
When executing
exec distribution..sp_browsereplcmds
SQL Server 2005 Standard SP1 says:
Msg 6513, Level 16, State 27, Procedure sp_browsereplcmds, Line 110Failed to initialize the Common Language Runtime (CLR) v2.0.50727 due to memory pressure. Please restart SQL server in Address Windowing Extensions (AWE) mode to use CLR integration features.I have two (nearly) identically machines (test has 2, prod has 4 CPUs), both 3071MB RAM, Win 2k3 Server SP1, both have no AWE running.
On test-machine the procedure works fine, on production in doesn't.
I checked performance. Test machine has about 180MB available memory, production about 160MB (nearly constant). Thread count for process sqlservr is constant and similar at about 65.
Any idea why it runs on test but not on production machine?
Cheers,
Hi!
I have crl stored procedure with distributed transaction in it. I really need such transaction. When a poison message occurs 5 time my queue is turned off.
I've read about handling poison messages in msdn (save transaction and rollback part of it), but it works only with local transaction. What should I do?
An important point is that messages shoold be processed in right order, I can't receive message and put it to the end of queue.
I want to try process poison message constantly.
I doesn't want to stop receiving messages in that queue.
Thanks.
kostya
I installed sp3 on my sql2000 server and now when I open up enterprise manager I get the following:
1st message:
rebbrui.rll is missing
2nd message:
snap in failed to initialize
name: meta data services
Thanks in advance for your help!!!
When installing SQLEXPRESS I am getting this message:
Setup failed because service MSSQL$SQLExpress is disabled for the current hardware profile. Services must be set with the current Hardware Profile logon property enabled.
Anybody knows how to fix this problem?
Eitan
Hi,
I am using distributed transactions where in I start a TransactionScope in BLL and receive data from service broker queue in DAL, perform various actions in BLL and DAL and if everything is ok call TransactionScope.Commit().
I have a problem where in if i run multiple instances of the same app ( each app creates one thread ), the threads pop out the same message and I get a deadlock upon commit.
My dequeue SP is as follows:
CREATE PROC [dbo].[queue_dequeue]
@entryId int OUTPUT
AS
BEGIN
DECLARE @conversationHandle UNIQUEIDENTIFIER;
DECLARE @messageTypeName SYSNAME;
DECLARE @conversationGroupId UNIQUEIDENTIFIER;
GET CONVERSATION GROUP @conversationGroupId FROM ProcessingQueue;
if (@conversationGroupId is not null)
BEGIN
RECEIVE TOP(1) @entryId = CONVERT(INT, [message_body]), @conversationHandle = [conversation_handle], @messageTypeName = [message_type_name] FROM ProcessingQueue WHERE conversation_group_id=@conversationGroupId
END
if @messageTypeName in
(
'http://schemas.microsoft.com/SQL/ServiceBroker/EndDialog',
'http://schemas.microsoft.com/SQL/ServiceBroker/Error'
)
begin
end conversation @conversationHandle;
end
END
Can anyone explain to me why the threads are able to pop the same message ? I thought service broker made sure this cannot happen?
Full message:
Connection handshake failed. An OS call failed: (8009030c) 0x8009030c(The logon attempt failed). State 66
Under these conditions, setting trustworthy on on the sending and receiving databases will solve this issue
1) Communicating between multiple instances
2) Using Kerberos security (NT Authentication, i.e. not certificates)
I installed Micrsoft Server Desktop Engine from the CD I received in
my ASP.net book. The installation went fine and then I went to the DOS
prompt and did the "setup SAPWD..." and it ran. I restarted my computer and
opened ASP Matrix and went to the Data tab and proceed to connect to
the server. It gave me an error message it couldn't connect.
So I
uninstalled MSDE and made sure the sql2ksp3 folder was gone. So I went
ahead and installed the MSDE again from the CD again and then went to
DOS
to do the setup. It ran through the setup until the very end with 11
seconds remaining and received error message " Setup failed to
configure the server. Refer to the server error logs and setup logs for
more information. I have tried it several times and it always
stops around 11 seconds. I have tried to install the download from
microsoft.com
instead the CD and that didn't work also. So at this point I
am stuck. PLEASE HELP!
I also checked my Registry keys for a file called PendingFileRenameOperations and it wasn't in the registry keys.
If anyone has any suggestions I would appreciate it.
Hi All, I am using the CSLA framework for the data access with SQL Server 2005 and we are not using distributed transaction. When we are using this architecture for our local machine it is working fine and our DB is in local machine itself.
But I am getting the following error in our development server and our DB is in the Network. " DataPortal.Fetch failed
(DataPortal.Fetch failed (DataPortal.Fetch failed (Network access for
Distributed Transaction Manager (MSDTC) has been disabled. Please enable DTC for
network access in the security configuration for MSDTC using the Component
Services Administrative tool.))) ---> DataPortal_Fetch method call failed
---> DataPortal.Fetch failed (DataPortal.Fetch failed (Network access for
Distributed Transaction Manager (MSDT... Procedure Script call failed." Please help me out to get rid of it. Your help would be appreciated.
RegardsGomaz
Distributed transactions were happily running between our SQL servers and then we installed Windows 2003 Server SP2 and all of a sudden we got this nice error message when attempting a remote data update via linked servers. I couldn't even run "BEGIN DISTRIBUTED TRANSACTION" without getting the error message. The full error message is:
"Enlist operation failed: 0x8004d00e(XACT_E_NOTRANSACTION). SQL Server could not register with Microsoft Distributed Transaction Coordinator (MSDTC) as a resource manager for this transaction. The transaction may have been stopped by the client or the resource manager."
Apparently, SP2 disables network DTC access (how nice, I feel more secure knowing that my data can't be updated remotely anymore).
Solution:
From Control Panel | Add or Remove Programs | Add Remove Windows Components
Select "Application Server" and click the "Details" button
Check "Enable network DTC access" and click OK for however many prompts it takes to apply the changes.
****NOTE**** this change WILL SHUT DOWN SQL SERVER so plan accordingly (this would have been handy to know in advance since I ran it in the middle of the workday and everyone got disconnected).
Hope this helps!
Newbie strikes again.. I'm attempting to connect to a SQL Server database (using VS 2005). My code generated no errors in the build but when I tried to access the database, I got the following message:"The ConnectionString property has not been initialized."My connection string is stored in my web.config file. My code goes as follows:Dim strSQL As String = "SQL string stored here"Dim objConnection as SqlConnection = New SQLConnection(ConfigurationManager.AppSettings("name of connection string is here"))Dim objCommand as SQLCommand = New SqlCommand(strSQL, objConnection)objConnection.Open()Then I go on to open my reader and such. Where should I be initializing the ConnectionString property?TIA,Lesley
View 1 Replies View RelatedCan anyone give a quick description of the meaning of this message andwhat needs to be done to get a connection.I'm running DBArtisan with SQLServer 2000 client SP4 installed.I also get the same message with MS Enterprise Manager so this iscoming out of the actual ODBC connection attempt.Thanks in advance!
View 1 Replies View Related
Hi all,
can anyone tell me if an oleDb connection (provider is Jet 4.0 to Access database) can be enlisted in a Distributed Transaction?
The goal is to copy data from SqlServer to Access within a transaction.
Pier
Hello everyone,
I have three merge publications that use web synchronization. The first publication works with no problem. When I try and sync the second publication, I get the following error messages:
"The operation timed out"
"The Processing of the response message failed".
So, I upped the query timeout from 300 seconds to 900 seconds. Now I get the following error messages:
"The connection with the server was terminated abnormally"
"The Processing of the response message failed".
I am using the Synchronize applet (found in the Accessories menu) to test my publications.
The third publication also works with no problem, so I do not see why the second one fails.
The only difference between the three is the following:
The first replicates a small handful of UDF's
The second replicates all tables (and has some filtering applied)
The third replicates all stored procs, views, and remaining UDF's.
Any ideas?
Thanks...
Hello everybody,I was configuring a SqlDataSource control using SQL Authentication mode.I first added a database file (testdb.mdf) through Solution Explorer-Add New Items. Then through Database Explorer I created a table named "info"Then while configuring the SqlDataSource control I used the SQL Authentication mode and attached the "testdb.mdf" database file.Test Connection showed success. But when I hit the Ok button of the wizard it displayed the following error message:Failed to generate a user instance of SQL Server. Only an integrated connection can generate a user instance.While configuring the SqlDataSource control I clicked "New Connection". Under Data Source section I tried both Microsoft SQL Server and Microsoft SQL Server Database File. And in both the cases I attached a databese file(testdb.mdf). Plz enlighten me on this.Thanks and Regards,Sankar.
View 1 Replies View RelatedI have SSIS packages created to import .xls files into sql tables. I now have vb.net code within which I am trying to execute individual packages whenever my code notices the .xls files being deposited within a network folder. When I try to run my code I get the error message:
Assertion Failed:Abort=Quit, Retry=Debug, Ignore=Continue
at STrace.ReadTraceValues()
at STrace..cctor()
at STrace.Trace(String strComponentName, String strLine)
at ManagedHelper.GetNextManagedInfo(DTS_Managed_INFO&nextManagedInfo)
here is my code:
Sub RunPackage(ByVal pkgCMD As String)
'
Dim app As New Application
Dim pkg As New Package
Dim pkgResults As DTSExecResult
'Dim pkgevents As IDTSEvents
'
pkg = app.LoadPackage(pkgCMD, Nothing)
pkgResults = pkg.Execute()
The error occurs during the pkg=app.LoadPackage(pkgCMD, Nothing) statement. Any idea of how I determine why the SSIS package will not load thru my vb app? It runs fine if I load the SSIS package in SSBIDS.
Thanks for any help or guidance.
I am getting the following error when with SQL Express.SQL Server blocked access to STATEMENT 'OpenRowset/OpenDatasource' of component 'Ad Hoc Distributed Queries' because this component is turned off as part of the security configuration for this server. A system administrator can enable the use of 'Ad Hoc Distributed Queries' by using sp_configure. For more information about enabling 'Ad Hoc Distributed Queries', see "Surface Area Configuration" in SQL Server Books Online. While I was very please to see such a verbose error and directions on where to find the answer I have yet to figure out how to turn this option on... I tried sp_configure 'Ad Hoc Distributed Queries', 1 but got the following error The configuration option 'Ad Hoc Distributed Queries' does not exist, or it may be an advanced option.If I execute only sp_configure it does not list Ad Hoc Distributied Queries as an option. I checked the sql Books Online and it tells me to use the Surface configuration tool which SQL Express does not seem to have.... Could someone help me out with this?Thanks - Mark
View 3 Replies View Related