Failed To Initialize Distributed COM (CoInitializeEx Returned 80010119).
Dec 10, 2007
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.
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?
SELECT [CustomerName], [AccountCode], [ProductCode], [Description1], [Description2], [MaterialType], [Brand], [PGroup], [Type], [GSM], [Colour], [Size1], [Size2], [Microns], [PriceQuantity], [PriceUnit], [Packed], [Price], [MinQuantity], [TonnePrice], [LeadTime], [WebURL] FROM OPENROWSET('Microsoft.Jet.OLEDB.4.0', ' Text;Database=D:ApplicationsxxxxxxxxxAppRootxxxxxxxxxSQLCatalogues;HDR=YES', 'SELECT * FROM [product_test.csv]') AS ImportFile WHERE [ImportFile].[MaterialType] IN (1, 2, 3, 4)
Error message Server: Msg 7399, Level 16, State 1, Line 5 OLE DB provider 'Microsoft.Jet.OLEDB.4.0' reported an error. [OLE/DB provider returned message: Unspecified error] OLE DB error trace [OLE/DB Provider 'Microsoft.Jet.OLEDB.4.0' IDBInitialize::Initialize returned 0x80004005: ].
This is being run on Microsoft SQL Server 2000 - 8.00.2039 (Intel X86) Windows 2003, build 3790.srv03_gdr.070301-2306
Have checked a number of knowledge base articles C:Windowssystem32msjet40.dll version 4.0.8618.0
REGEDT32: HKEY_LOCAL_MACHINESOFTWAREODBC, Administrator/everyone full access
D:ApplicationsxxxxxxxxxAppRootxxxxxxxxxSQLCatalogues has full permissions for Administrator/everyone groups
Can anyone suggest the next step to identifying a possible cause to this issue.
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?
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..
I 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"
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
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).
Hi i am working on sending data from a dat file to table in sql server Database and i am using the Data conversion transformation in ssis to convert string of fixed length into numeric (11,5) which is the datatype for the price field in the table and its returning an error saying that status vale 6 and error text as Conersion Failed sue to overflow of specific type ... Can anyone let me know how to overcome this error.
I am using windows 2003 server and i have installed SSAS 2005 and configured http request for AS 2005 with this below url : http://www.microsoft.com/technet/prodtechnol/sql/2005/httpasws.mspx. I had tried all the possiblities given in this url. But i am getting like "Test connection failed because of error initializing provider. The HTTP Server returned the following error : Not found" when i create udl file. Moreover i have installed MSOLAP 3.0 and OLAP 9.0 provider and MSXML 6.0 Parser.
I have a strange problem. I have some code that executes a sql query. If I run the query in SQL server query analyzer, I get a set of data returned for me as expected. This is the query listed on lines 3 and 4. I just manually type it into query analyzer. Yet when I run the same query in my code, the result set is slightly different because it is missing some data. I am confused as to what is going on here. Basically to examine the sql result set returned, I write it out to an XML file. (See line 16). Why the data returned is different, I have no idea. Also writing it out to an XML file is the only way I can look at the data. Otherwise looking at it in the debugger is impossible, with the hundreds of tree nodes returned. If someone is able to help me figure this out, I would appreciate it. 1. public DataSet GetMarketList(string region, string marketRegion)2. {3. string sql = @"SELECT a.RealEstMarket FROM MarketMap a, RegionMap b " + 4."WHERE a.RegionCode = b.RegionCode"; 5. DataSet dsMarketList = new DataSet();6. SqlConnection sqlConn = new SqlConnection(intranetConnStr); 7. SqlCommand cmd = new SqlCommand(sql,sqlConn);8. sqlConn.Open();9. SqlDataAdapter adapter = new SqlDataAdapter(cmd); 10. try11. {12. adapter.Fill(dsMarketList); 13. String bling = adapter.SelectCommand.CommandText;//BRG 14. dsMarketList.DataSetName="RegionMarket"; 15. dsMarketList.Tables[0].TableName = "MarketList"; 16. dsMarketList.WriteXml(Server.MapPath ("myXMLFile.xml" )); // The data written to 17. myXMLFile.xml is not the same data that is returned when I run the query on line 3&4 18. // from the SQL query 19. } 20. catch(Exception e) 21. { 22. // Handle the exception (Code not shown)
I found the following link which seems to be the problem we're experiencinghttp://support.microsoft.com/kb/937517
The link includes a workaround which is the following: "To prevent the SQLNCLI provider from sending an attention signal to the server, use the SQLNCLI provider to consume fully any rowsets that the OLE DB consumer creates. "
How do I use the SQLNCLI provider to fully consume any rowsets?
i am using a control that i downloaded from the control gallery It has a line for a connection string.
which i put on in there: data source=server;initial catalog=database;user id=blahblah;password=557896 and i get an error:
Exception Details: System.InvalidOperationException: The ConnectionString property has not been initialized.
Source Error:
An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.
Stack Trace:
[InvalidOperationException: The ConnectionString property has not been initialized.] System.Data.SqlClient.SqlConnection.Open() +433 Microsoft.Vote.VoteButtonClick(Object sender, EventArgs e) +289 System.Web.UI.WebControls.Button.OnClick(EventArgs e) +108 System.Web.UI.WebControls.Button.System.Web.UI.IPostBackEventHandler.RaisePostBackEvent(String eventArgument) +57 System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler sourceControl, String eventArgument) +18 System.Web.UI.Page.RaisePostBackEvent(NameValueCollection postData) +33 System.Web.UI.Page.ProcessRequestMain() +1277
I have installed Reportin Services 2005 , X64. I selected install but do not configure.
Afterwards i applied Service Pack 1 and ran all the hotfixes for sql components as per KB 918222.
The i launch the RS configuration manager i succesffuly setup Report Server/Manager Virtual DIrectory and servcie identity.
I then setup the database, i create a new database to the local 2005 instance i just installed with RS, the databse is created successfully.
Basically i have green ticks all the way, however Initialize is greyed out i cannot take the option to initialize the server ???
When i try to restart the RS service it says that the service failed to repond in a timely fashion, when i check the even log the servcie only started 10 minutes later, and there are no errors ?
WHen i go back to RS config manager , initialize is till greyed out , this is the last step i ahve to do but i cannot take the option ???
Hence you have a database which huge tables and a transactional replication (push subscriptions).
Now my question:
1. if I have to initialize a snapshot but I would like to do it without the snapshot agent, what methods are available?
2. Usually the distribution agent will request an initialize snapshot. How can I tell him, that I would like to use an alternative method and that the distribution agent should NOT request a snapshot?
3. Any suggestions about a good practive for materializing huge and big tables wihtout using the disitrbution agent (e.g. "switch off" replication, bcp table out of the primary site and bcp it into the target site, "start" distribution agent so that it doesn't request a snapshot).
I have just completed a fresh install of SSRS 2005. Now, when I try to initialize it, it fails. I then try to delete any encrypted content and get the following error:
Code Snippet ReportServicesConfigUI.WMIProvider.WMIProviderException: The encrypted value for the "LogonCred" configuration setting cannot be decrypted. (rsFailedToDecryptConfigInformation) at ReportServicesConfigUI.WMIProvider.RSReportServerAdmin.ThrowOnError(ManagementBaseObject mo) at ReportServicesConfigUI.WMIProvider.RSReportServerAdmin.DeleteEncryptedInformation()
From what I know, Reporting Services has never been installed on the machine in question. And if so, then haow can I get around this encrypted key issue?
I have a For Loop container where each iteration a Master record is inserted. I also have a number of package variables capturing rowcounts from the dataflow task. I later update the master record with the rowcounts. How do I initialize the package variables containing the rowcounts because currently, some of the rowcounts are being populated with rowcounts from another file.
I am developing a system using SQL Server replication between SQL Server EXPRESS 2005 clients and SQL Server 2005 servers. I initialize the replica databases with a script, then I do not want to initilize the subscriber with the snapshot; I configure each subscriber to "not initilize", but when I run the first synchronization the snapshot copy process is always is executed.
Maybe am I forgetting something? Can I use this SQL Server EXPRESS - SQL Server replication scheme without initialize the subscribers with the snapshot? Thaks for reading!
I am experiencing some replication problems. I have a test server with a test database which has been working just fine with some simple Merge Replication. That old server is now been targeted for decommissioning. I have moved the test database to another test server and have set everything conceivable up the same as it was on the prior server but I am experiencing errors that I have not been able to resolve. I am using the same Domain User account with the same privileges on both systems...
The first error I receive in my SQL Server error logs is:
Message Error: 14151, Severity: 18, State: 1.
Rapidly followed by the following error message:
Message Replication-Replication Merge Subsystem: agent SOURCE-DATABASE-MERGE-DESTINATION-16 failed. The merge process could not initialize the subscription. Ensure that the subscription registration exists at the publisher, and reregister the subscription if necessary.
From within the Replication Monitor I look into the subscription and I can see the following error message:
Command attempted:
{call sys.sp_MSmergesubscribedb ('true', 0) }
Error messages:
The merge process could not initialize the subscription. Ensure that the subscription registration exists at the publisher, and reregister the subscription if necessary. (Source: MSSQL_REPL, Error number: MSSQL_REPL-2147201011) Get help: http://help/MSSQL_REPL-2147201011
INSERT failed because the following SET options have incorrect settings: 'ANSI_PADDING'. Verify that SET options are correct for use with indexed views and/or indexes on computed columns and/or query notifications and/or xml data type methods. (Source: MSSQLServer, Error number: 1934) Get help: http://help/1934
I have looked into the help links from above, researched codes and also browsed this forum and others to no avail so far. Any help or suggestions would be greatly appreciated! THANKS!
I met some problems in merge replication with sql server 2005 (sp2).
one user who is using the PDA (SQL Mobile 2005) try to sync with server, the error info is coming.
the error in replication monitor is shown as following: Error messages: The merge process could not initialize the subscription. Ensure that the subscription registration exists at the publisher, and reregister the subscription if necessary. (Source: MSSQL_REPL, Error number: MSSQL_REPL-2147201011) Get help: http://help/MSSQL_REPL-2147201011 The subscription could not be found. (Source: MSSQLServer, Error number: 20021) Get help: http://help/20021 The subscription has expired. Mark the subscription for reinitialization and restart the Merge Agent to reinitialize the subscription. (Source: MSSQL_REPL, Error number: MSSQL_REPL-2147200980) Get help: http://help/MSSQL_REPL-2147200980
I am unable to get my snapshot agent to initialize. When I start the "View Snapshot Agent Status" and press the Start button, it appears that the snapshot agent attempts to starts and then it doesn't.
I have configured the a distribution server and need to push a replication to another database, both can connect, etc.
I used the wizard to configure the distributon server and subscription server. I am using AdventureWorks, and am attempting to replicate a single small table.
I'm trying to initialize a subscriber from a backup for a pull subscription. The publisher was started before the full backup was made. I followed the instructions @ Books Online topic "Initializing a Transactional Subscription Without a Snapshot" http://msdn2.microsoft.com/en-us/library/ms151705.aspx and How to: Initialize a Transactional Subscriber from a Backup (Replication Transact-SQL Programming) http://msdn2.microsoft.com/it-it/library/ms147834.aspx . I initialized the subscriber by restoring the db before I run the create subscriber scripts. All agents run successfully except for the following:
The network setup is that the publisher and the subscriber are in 2 different domains with the distribution database at the publisher. The subscriber agent is able to connect and run however the error on the subscriber side is:
"Agent message code 14080. The remote server "subscriber" does not exist, or has not been designated as a valid Publisher, or you may not have permission to see available Publishers."
The warning on the publisher side is in the Replication Monitor where in the status it says Uninitialized Subscription.
Any ideas on why it says it isn't initialized? Is there a StoredProc that I have to execute to initialize from backup?
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