Snap-im Failed Initialize

Snap-in Failed To Initialize

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

MMC Snap-in Failed To Initialize

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

Snap Shot Agent Refuses To Snap New Articles.

Hi There

Error Message: Failed To Initialize Distributed COM

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!

Failed To Initialize Distributed COM (CoInitializeEx Returned 80010119).

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.

Sp_browsereplcmds Causes Failed To Initialize The Common Language Runtime...

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,

Rebbrui.rll Is Missing:meta Data Services Failed To Initialize After Sp3

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!!!

Integration Services :: Error - Configuration System Failed To Initialize

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..

DB Engine :: Failed To Initialize Library With Error Number -2147467259

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"

<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>.

Distrib.exe Application Error , Application Failed To Initialize Properly(0xx0000142)

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

Snap In Errors

Hi guys, when I try to open EM I get this error.


Snap-in fialed to initialize.

Name: Microsoft Sql ent Mgr

CLSID:{00100100-186011d0-8ef5-00aa0062c58f}

Do i need to re-install the sql client tools?

Thanks for your help.

SQL Snap-In Not Initialized

I am getting the error message:

Snap-In Not Initialized

Name: Microsoft SQL Enterprise Manager

CSID:00100100-1816-11d0-8ef5-00aa0062c58f

I have tried all the suggested fixes and nothing is working.

I unstalled and reinstalled SQL 2000

I unregistered and reregistered sqlmmc.dll successfully, but the error still exists.

When I checked the registry, I do not see an entry for Microsoft SQL .

What should I do know?

Is my last resort to rebuild the server?

Thanks

MMC Couldnot Create Snap In

This is very old problem but I couldn't able to solve the following problem with the solution given for this.I had SQL 2000 installed, and later installed SQL 2005 with Visual Studio 2005. Now my enterprise manager tool no longer works in the MMC. I am not sure whether it is related to the SQL 2005 install or not.

The error I get is the :
MMC Couldnot create snap in


I reinstalled SQL 2000 enterprise manager, but it still gives the same error. Query Analyzer and other SQL utilities still work fine, as do other MMC items such as Biztalk Admin, Component Services, etc.

I tried to solve this by MMC and try to add SQL Server Enterprise manager,but I couldn't find Enterprise manager in the list.

I really appreciate if anybody can help me.
Thanks in advance

Regards,
Sireesh Chigurupati

How Do I Implement Snap Shot Replication..?

how do i implement Snap shot replication..?
(IN SQL EXPRESS SERVER)
thanks.

SQL Server 2000 Enterprise Manager Snap-in Missing

After running virus cleaning software on my HD, I suddenly find my Enterprise Manager snap-in missing and fail to initialize. Is the MMC erased or damaged? What should I do? Reinstall SQL Server 2000 or repair it? Please advise. Thanks.

Problem With Merge Replication--with Snap Shot Agent

i am having a problem with the merge replication.
has over 400 thousand records and is running on a hp server with a raid 5 configuration.
i am trying to create a merge replication on another server with the same configuration.

i am facing problems in 2 places.

firstly i created a push subscription and ran the snap shot agnt.
but the snap shot agent times out and expires .. as a result of which i am not able to create the initial snap shot on the subscribers end.

next i thought i would manualy create a snap shot
and so i backed up the dabase from the publisher and restores it on the subscription side.

now i tried to create a new subscription by chosing the option... the dabase alredy conists of the data base and schema
and i get a n error saying
"SQL Server Enterprise Manager encountered errors creating push subscriptions for the following Subscribers:

ICE: Error 20086: Publication '%s' does not support the nosync type because it contains a table that does not have a rowguidcol column

what do i do to solve this problem....
please try and give me a solution to solve either ways.

thanks,

--ggupta

How Initialize A Connection String In .Net

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


How would i initialize the connection string.


any help would be appreciated


alucke

RS 2005 Initialize Greyed Out ???

HI There

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 ???

PLEASE HELP, Thanx

How Can I Skip An Initialize Snapshot?

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).



Regards

Nobsay

Not Able To Initialize Scripting Engine

 

I have a DTS package that is running under SQL 2005 (64-bit Itanium).  It has a data driven query in it and I receive the following error:

ActiveX Scripting Transform 'DTSTransformation__1' was not able to initialize the script execution engine

I don't want to have to re-register any DLLs if I don't have to.  Shouldn't this work out of the box?

Any ideas?

Reporting Services Won't Initialize

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?

Thanks!

How To Initialize Package Variables?

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.



thanks

Report Server Does Not Initialize

I am using ms sql 2005 standard edition on windows Nt

Everything is working fine except the report server..

when i run the configuration tool and try to start the report server, it fails to start.. i am using sql on the local machine .

i have set p lmy database on the windows credentials..

i am using my machine name/user name as the account name for the database setup.

i have also used rsconfig utility to configure the report server but nothing happens after that..



pls help

Initialize All Fields When Table Is Created

Is there a way to give fields or rows default data when the table is created?

IDBInitialize::Initialize Returned 0x80004005

When executing the following SQL statement we get the error as message below:

INSERT INTO [dbo].[ProductImport] ([CustomerName], [AccountCode], [ProductCode], [Description1],
[Description2], [MaterialType], [Brand], [PGroup], [Type], [GSM], [Colour], [Size1], [Size2], [Microns],
[PriceQuantity], [PriceUnit], [Packed], [Price], [MinQuantity], [TonnePrice], [LeadTime], [WebURL])

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.

Replication Without Initialize Subscriptor With The Snapshot

Hello all,


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!

Merge Process Could Not Initialize The Subscription

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!

The Merge Process Could Not Initialize The Subscription.

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

is there anybody who has any idea about it?

Initialize A Backup Device - Without Backing Anything Up To It

Is there a way to initialize a backup device without actually backing anything up to it?

This would make my backup code much simpler.

Unable To Get Snapshot Agent To Initialize

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.

Unable To Initialize Report Server

Initialize Pull Transaction From Backup

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?