Enterprise Manager won't work - "snap-in failed to initialize"

On one node of a cluster I have I began getting this message today after a
failover. How do I resolve? I've tried copying SQLEM.msc and replacing it
an it in 80\tools\binn but it still doesn't work. This is the exact error
message:
Snap-in failed to initialize
Name: Microsoft SQL Enterprise Manager
Clsid: {0100100-1816-11D0-8EF5-00AA0062C8F}See this KB Article. it may helpful
http://support.microsoft.com/?kbid=297064
Petchikumar
"Cathy Soloway" wrote:

> On one node of a cluster I have I began getting this message today after a
> failover. How do I resolve? I've tried copying SQLEM.msc and replacing i
t
> an it in 80\tools\binn but it still doesn't work. This is the exact error
> message:
> Snap-in failed to initialize
> Name: Microsoft SQL Enterprise Manager
> Clsid: {0100100-1816-11D0-8EF5-00AA0062C8F}
>|||That didn't work either. I called support and they walked me through
checking out all the DLLs and functionality and finally suggested we do a
re-boot. Will try that over the weekend. Thanks for the response, though.
"Petchikumar" wrote:
[vbcol=seagreen]
> See this KB Article. it may helpful
> http://support.microsoft.com/?kbid=297064
>
> Petchikumar
>
> "Cathy Soloway" wrote:
>

Enterprise Manager won't work - "snap-in failed to initialize"

On one node of a cluster I have I began getting this message today after a
failover. How do I resolve? I've tried copying SQLEM.msc and replacing it
an it in 80\tools\binn but it still doesn't work. This is the exact error
message:
Snap-in failed to initialize
Name: Microsoft SQL Enterprise Manager
Clsid: {0100100-1816-11D0-8EF5-00AA0062C8F}See this KB Article. it may helpful
http://support.microsoft.com/?kbid=297064
Petchikumar
"Cathy Soloway" wrote:
> On one node of a cluster I have I began getting this message today after a
> failover. How do I resolve? I've tried copying SQLEM.msc and replacing it
> an it in 80\tools\binn but it still doesn't work. This is the exact error
> message:
> Snap-in failed to initialize
> Name: Microsoft SQL Enterprise Manager
> Clsid: {0100100-1816-11D0-8EF5-00AA0062C8F}
>|||That didn't work either. I called support and they walked me through
checking out all the DLLs and functionality and finally suggested we do a
re-boot. Will try that over the weekend. Thanks for the response, though.
"Petchikumar" wrote:
> See this KB Article. it may helpful
> http://support.microsoft.com/?kbid=297064
>
> Petchikumar
>
> "Cathy Soloway" wrote:
> > On one node of a cluster I have I began getting this message today after a
> > failover. How do I resolve? I've tried copying SQLEM.msc and replacing it
> > an it in 80\tools\binn but it still doesn't work. This is the exact error
> > message:
> >
> > Snap-in failed to initialize
> > Name: Microsoft SQL Enterprise Manager
> > Clsid: {0100100-1816-11D0-8EF5-00AA0062C8F}
> >

Enterprise Manager question

When I click on a server node in EM, I am prompted to
enter the sa password in hte usual dialog box. However for
one particular server I get this dialog box twice - why is
this different to the others?
TIA,
BBSounds to me like something introduced by installing a security hotfix. Chan you check if that
differ on the server or client level?
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"BB" <anonymous@.discussions.microsoft.com> wrote in message
news:01d601c4a1a5$83884c40$a501280a@.phx.gbl...
> When I click on a server node in EM, I am prompted to
> enter the sa password in hte usual dialog box. However for
> one particular server I get this dialog box twice - why is
> this different to the others?
> TIA,
> BB

Enterprise Manager question

When I click on a server node in EM, I am prompted to
enter the sa password in hte usual dialog box. However for
one particular server I get this dialog box twice - why is
this different to the others?
TIA,
BB
Sounds to me like something introduced by installing a security hotfix. Chan you check if that
differ on the server or client level?
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"BB" <anonymous@.discussions.microsoft.com> wrote in message
news:01d601c4a1a5$83884c40$a501280a@.phx.gbl...
> When I click on a server node in EM, I am prompted to
> enter the sa password in hte usual dialog box. However for
> one particular server I get this dialog box twice - why is
> this different to the others?
> TIA,
> BB

Enterprise Manager is not displaying any database information.

We have SQL 2000 Active/Active 2 node cluster. Yesterdat
we did a memory switch to use more than 2GB RAM after that
Enterprise Manager on one node is not displaying any
database information. All the databases is up its just
Enterprise Manager piece is not working. If I do clink on
new database thru ENterprise Manage It display following
message. Any idea ..
Error 220: Airthmetic overflow error for datatype
smallint, value = 32891Hi Avnish,
Try this:
From Query Analzyer, run this query:
use master
go
select * from sysdatabases
go
Do you get the same error?
Sincerely,
Yih-Yoon Lee [Microsoft]
Microsoft SQL Server Support
This posting is provided "AS IS" with no warranties, and confers no rights.
Subscribe to MSDN & use http://msdn.microsoft.com/newsgroups.

Enterprise Manager Hangs....

1. SQL Server 2K with Service Pack 3.x.

Steps to generate error in Enterprise Manager.

Right click on Database node, select All Tasks and Restore Database... Hourglass appears for ever.

All Tasks--> Backup Database... and All Tasks--> Attach Database... works fine.

Installed the SP4 and reinstalled the Enterprise Manager component. No help. Still the same hourglass at this stage.

2. When the above steps are repeated from other PC(Enterprise Manager), the hour glass appears. Irrespective from which EM (different PC) I run the above steps the EM hangs.

What would be the cause and remedy.

Thank you for your thoughts.

Smith

Here is the update on this issue...

Restore database window appears after long wait.... more than an hour.........

It never use to be so earlier.

What got changed recently?

SQL Server was writing the backup files(full backup, differential backup and transactional backup on UNC path) to Windows 2K Server and lately started writing to Windows Server 2003.

When the restore is selected it will list all the backup set files and its path. Is the EM taking longtime to read this list? Does the new file system is delaying the read?

Any thoughts?

Thank you,

|||

Run a trace and see what commands, statements are being executed when it hangs. That should give you more to figure out the issue.

-Sue

Enterprise Manager Hangs....

1. SQL Server 2K with Service Pack 3.x.

Steps to generate error in Enterprise Manager.

Right click on Database node, select All Tasks and Restore Database... Hourglass appears for ever.

All Tasks--> Backup Database... and All Tasks--> Attach Database... works fine.

Installed the SP4 and reinstalled the Enterprise Manager component. No help. Still the same hourglass at this stage.

2. When the above steps are repeated from other PC(Enterprise Manager), the hour glass appears. Irrespective from which EM (different PC) I run the above steps the EM hangs.

What would be the cause and remedy.

Thank you for your thoughts.

Smith

Here is the update on this issue...

Restore database window appears after long wait.... more than an hour.........

It never use to be so earlier.

What got changed recently?

SQL Server was writing the backup files(full backup, differential backup and transactional backup on UNC path) to Windows 2K Server and lately started writing to Windows Server 2003.

When the restore is selected it will list all the backup set files and its path. Is the EM taking longtime to read this list? Does the new file system is delaying the read?

Any thoughts?

Thank you,

|||

|||

|||

Run a trace and see what commands, statements are being executed when it hangs. That should give you more to figure out the issue.

-Sue

Entering Empty Node Using An Updategram

Hi there,
I was wondering if anyone has found how to add an empty (not NULL) node
to an update. I found if you create a node you can get it to enter an
empty space by setting the default value to ('') on the database so
that when you query the data you have an empty node returned. The
problem I'm having is when I want to "blank" a node so I have something
like:
<before>
<node>Some text</node>
</before>
<after>
<node/>
</after>
which will result in a NULL value. Is there something I can put in the
after node that will result in it producing the same as ('') or
something to that effect?
Thanks,
GaryGary,
I'm assuming you are using the XML datatype and want to perform this DML via
the .modify() method.
In that case, you can use the replace value of DML statement. The new value
you want is "empty" or (). Here is an example:
declare @.x xml
set @.x = '<foo>bar</foo>'
set @.x.modify('replace value of /foo[1]/text()[1] with ()')
select @.x
You will most likely need to modify this DML if you are using a typed xml
column.
Regards,
Galex Yen
"Gary" wrote:

> Hi there,
> I was wondering if anyone has found how to add an empty (not NULL) node
> to an update. I found if you create a node you can get it to enter an
> empty space by setting the default value to ('') on the database so
> that when you query the data you have an empty node returned. The
> problem I'm having is when I want to "blank" a node so I have something
> like:
> <before>
> <node>Some text</node>
> </before>
> <after>
> <node/>
> </after>
> which will result in a NULL value. Is there something I can put in the
> after node that will result in it producing the same as ('') or
> something to that effect?
> Thanks,
> Gary
>|||you need to use xsi:nil. Here is the documentation and an example:
http://msdn2.microsoft.com/en-us/library/ms171764.aspx
<ROOT xmlns:sql="urn:schemas-microsoft-com:xml-sql"
xmlns:updg="urn:schemas-microsoft-com:xml-updategram"
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">
<updg:sync mapping-schema='StudentSchema.xml'>
<updg:before/>
<updg:after>
<Student SID="S00004" lname="Elmaci" minitial="" years="2">
<fname xsi:nil="true">
</fname>
</Student>
</updg:after>
</updg:sync>
</ROOT>
"Gary" wrote:

> Hi there,
> I was wondering if anyone has found how to add an empty (not NULL) node
> to an update. I found if you create a node you can get it to enter an
> empty space by setting the default value to ('') on the database so
> that when you query the data you have an empty node returned. The
> problem I'm having is when I want to "blank" a node so I have something
> like:
> <before>
> <node>Some text</node>
> </before>
> <after>
> <node/>
> </after>
> which will result in a NULL value. Is there something I can put in the
> after node that will result in it producing the same as ('') or
> something to that effect?
> Thanks,
> Gary
>

Entering Empty Node Using An Updategram

Hi there,
I was wondering if anyone has found how to add an empty (not NULL) node
to an update. I found if you create a node you can get it to enter an
empty space by setting the default value to ('') on the database so
that when you query the data you have an empty node returned. The
problem I'm having is when I want to "blank" a node so I have something
like:
<before>
<node>Some text</node>
</before>
<after>
<node/>
</after>
which will result in a NULL value. Is there something I can put in the
after node that will result in it producing the same as ('') or
something to that effect?
Thanks,
Gary
Gary,
I'm assuming you are using the XML datatype and want to perform this DML via
the .modify() method.
In that case, you can use the replace value of DML statement. The new value
you want is "empty" or (). Here is an example:
declare @.x xml
set @.x = '<foo>bar</foo>'
set @.x.modify('replace value of /foo[1]/text()[1] with ()')
select @.x
You will most likely need to modify this DML if you are using a typed xml
column.
Regards,
Galex Yen
"Gary" wrote:

> Hi there,
> I was wondering if anyone has found how to add an empty (not NULL) node
> to an update. I found if you create a node you can get it to enter an
> empty space by setting the default value to ('') on the database so
> that when you query the data you have an empty node returned. The
> problem I'm having is when I want to "blank" a node so I have something
> like:
> <before>
> <node>Some text</node>
> </before>
> <after>
> <node/>
> </after>
> which will result in a NULL value. Is there something I can put in the
> after node that will result in it producing the same as ('') or
> something to that effect?
> Thanks,
> Gary
>
|||you need to use xsi:nil. Here is the documentation and an example:
http://msdn2.microsoft.com/en-us/library/ms171764.aspx
<ROOT xmlns:sql="urn:schemas-microsoft-com:xml-sql"
xmlns:updg="urn:schemas-microsoft-com:xml-updategram"
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">
<updg:sync mapping-schema='StudentSchema.xml'>
<updg:before/>
<updg:after>
<Student SID="S00004" lname="Elmaci" minitial="" years="2">
<fname xsi:nil="true">
</fname>
</Student>
</updg:after>
</updg:sync>
</ROOT>
"Gary" wrote:

> Hi there,
> I was wondering if anyone has found how to add an empty (not NULL) node
> to an update. I found if you create a node you can get it to enter an
> empty space by setting the default value to ('') on the database so
> that when you query the data you have an empty node returned. The
> problem I'm having is when I want to "blank" a node so I have something
> like:
> <before>
> <node>Some text</node>
> </before>
> <after>
> <node/>
> </after>
> which will result in a NULL value. Is there something I can put in the
> after node that will result in it producing the same as ('') or
> something to that effect?
> Thanks,
> Gary
>