Enterprise Manager problem

Using SQL2000 with Enterprise Manager - sometimes, when we try to expand any
tab, such as databases or management, it comes back as empty!! Only
rebooting the server will make it come back but then at some point it stops
working again!
Any ideas much appreciated...
Best regards
Mark
Hello Mark,
Have you tried to reinstall the Enterprise Manager?
Have you applied the latest services pack of the SQL Server?
Did this issue only occur on the local server or remote server?
Please try to reinstall the Enterprise Manager and let me know the result.
Sincerely,
Wei Lu
Microsoft Online Community Support
==================================================
Get notification to my posts through email? Please refer to
http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx#notif
ications.
Note: The MSDN Managed Newsgroup support offering is for non-urgent issues
where an initial response from the community or a Microsoft Support
Engineer within 1 business day is acceptable. Please note that each follow
up response may take approximately 2 business days as the support
professional working with you may need further investigation to reach the
most efficient resolution. The offering is not appropriate for situations
that require urgent, real-time or phone-based interactions or complex
project analysis and dump analysis issues. Issues of this nature are best
handled working with a dedicated Microsoft Support Engineer by contacting
Microsoft Customer Support Services (CSS) at
http://msdn.microsoft.com/subscriptions/support/default.aspx.
==================================================
(This posting is provided "AS IS", with no warranties, and confers no
rights.)
|||Hi Wei Lu,
The problem happens on every client on which Enterprise Manager is
installed. It also happens if I make a remote connection. If we reboot the
server then the problem goes away on all clients but then just comes back
after a few days.
Interestingly, while the server is in this "broken" state, using SQL 2005
Management Studio seems to work with no problems.
Best regards
Mark
"Wei Lu [MSFT]" <weilu@.online.microsoft.com> wrote in message
news:NdFWZcMSHHA.2268@.TK2MSFTNGHUB02.phx.gbl...
> Hello Mark,
> Have you tried to reinstall the Enterprise Manager?
> Have you applied the latest services pack of the SQL Server?
> Did this issue only occur on the local server or remote server?
> Please try to reinstall the Enterprise Manager and let me know the result.
> Sincerely,
> Wei Lu
> Microsoft Online Community Support
> ==================================================
> Get notification to my posts through email? Please refer to
> http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx#notif
> ications.
> Note: The MSDN Managed Newsgroup support offering is for non-urgent issues
> where an initial response from the community or a Microsoft Support
> Engineer within 1 business day is acceptable. Please note that each follow
> up response may take approximately 2 business days as the support
> professional working with you may need further investigation to reach the
> most efficient resolution. The offering is not appropriate for situations
> that require urgent, real-time or phone-based interactions or complex
> project analysis and dump analysis issues. Issues of this nature are best
> handled working with a dedicated Microsoft Support Engineer by contacting
> Microsoft Customer Support Services (CSS) at
> http://msdn.microsoft.com/subscriptions/support/default.aspx.
> ==================================================
> (This posting is provided "AS IS", with no warranties, and confers no
> rights.)
>
|||On Feb 6, 6:54 am, "Mark Baldwin" <sWoz...@.community.nospam> wrote:
> Hi Wei Lu,
> The problem happens on every client on which Enterprise Manager is
> installed. It also happens if I make a remote connection. If we reboot the
> server then the problem goes away on all clients but then just comes back
> after a few days.
> Interestingly, while the server is in this "broken" state, using SQL 2005
> Management Studio seems to work with no problems.
>
Wei Lu asked about service packs, you didn't answer. Are the CLIENTS
at the same service pack level as the SERVER? If not, you can see
strange things like this occur.
|||Hello Mark,
Have you applied the same service pack on all the clients?
Sincerely,
Wei Lu
Microsoft Online Community Support
==================================================
Get notification to my posts through email? Please refer to
http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx#notif
ications.
Note: The MSDN Managed Newsgroup support offering is for non-urgent issues
where an initial response from the community or a Microsoft Support
Engineer within 1 business day is acceptable. Please note that each follow
up response may take approximately 2 business days as the support
professional working with you may need further investigation to reach the
most efficient resolution. The offering is not appropriate for situations
that require urgent, real-time or phone-based interactions or complex
project analysis and dump analysis issues. Issues of this nature are best
handled working with a dedicated Microsoft Support Engineer by contacting
Microsoft Customer Support Services (CSS) at
http://msdn.microsoft.com/subscriptions/support/default.aspx.
==================================================
(This posting is provided "AS IS", with no warranties, and confers no
rights.)
|||Hi ,
How is everything going? Please feel free to let me know if you need any
assistance.
Sincerely,
Wei Lu
Microsoft Online Community Support
==================================================
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
==================================================
This posting is provided "AS IS" with no warranties, and confers no rights.

Enterprise Manager problem

Using SQL2000 with Enterprise Manager - sometimes, when we try to expand any
tab, such as databases or management, it comes back as empty!! Only
rebooting the server will make it come back but then at some point it stops
working again!
Any ideas much appreciated...
Best regards
MarkHello Mark,
Have you tried to reinstall the Enterprise Manager?
Have you applied the latest services pack of the SQL Server?
Did this issue only occur on the local server or remote server?
Please try to reinstall the Enterprise Manager and let me know the result.
Sincerely,
Wei Lu
Microsoft Online Community Support
========================================
==========
Get notification to my posts through email? Please refer to
http://msdn.microsoft.com/subscript...ault.aspx#notif
ications.
Note: The MSDN Managed Newsgroup support offering is for non-urgent issues
where an initial response from the community or a Microsoft Support
Engineer within 1 business day is acceptable. Please note that each follow
up response may take approximately 2 business days as the support
professional working with you may need further investigation to reach the
most efficient resolution. The offering is not appropriate for situations
that require urgent, real-time or phone-based interactions or complex
project analysis and dump analysis issues. Issues of this nature are best
handled working with a dedicated Microsoft Support Engineer by contacting
Microsoft Customer Support Services (CSS) at
http://msdn.microsoft.com/subscript...t/default.aspx.
========================================
==========
(This posting is provided "AS IS", with no warranties, and confers no
rights.)|||Hi Wei Lu,
The problem happens on every client on which Enterprise Manager is
installed. It also happens if I make a remote connection. If we reboot the
server then the problem goes away on all clients but then just comes back
after a few days.
Interestingly, while the server is in this "broken" state, using SQL 2005
Management Studio seems to work with no problems.
Best regards
Mark
"Wei Lu [MSFT]" <weilu@.online.microsoft.com> wrote in message
news:NdFWZcMSHHA.2268@.TK2MSFTNGHUB02.phx.gbl...
> Hello Mark,
> Have you tried to reinstall the Enterprise Manager?
> Have you applied the latest services pack of the SQL Server?
> Did this issue only occur on the local server or remote server?
> Please try to reinstall the Enterprise Manager and let me know the result.
> Sincerely,
> Wei Lu
> Microsoft Online Community Support
> ========================================
==========
> Get notification to my posts through email? Please refer to
> l]
> ications.
> Note: The MSDN Managed Newsgroup support offering is for non-urgent issues
> where an initial response from the community or a Microsoft Support
> Engineer within 1 business day is acceptable. Please note that each follow
> up response may take approximately 2 business days as the support
> professional working with you may need further investigation to reach the
> most efficient resolution. The offering is not appropriate for situations
> that require urgent, real-time or phone-based interactions or complex
> project analysis and dump analysis issues. Issues of this nature are best
> handled working with a dedicated Microsoft Support Engineer by contacting
> Microsoft Customer Support Services (CSS) at
> [url]http://msdn.microsoft.com/subscriptions/support/default.aspx." target="_blank">http://msdn.microsoft.com/subscript...t/default.aspx.
> ========================================
==========
> (This posting is provided "AS IS", with no warranties, and confers no
> rights.)
>|||On Feb 6, 6:54 am, "Mark Baldwin" <sWoz...@.community.nospam> wrote:
> Hi Wei Lu,
> The problem happens on every client on which Enterprise Manager is
> installed. It also happens if I make a remote connection. If we reboot the
> server then the problem goes away on all clients but then just comes back
> after a few days.
> Interestingly, while the server is in this "broken" state, using SQL 2005
> Management Studio seems to work with no problems.
>
Wei Lu asked about service packs, you didn't answer. Are the CLIENTS
at the same service pack level as the SERVER? If not, you can see
strange things like this occur.|||Hello Mark,
Have you applied the same service pack on all the clients?
Sincerely,
Wei Lu
Microsoft Online Community Support
========================================
==========
Get notification to my posts through email? Please refer to
http://msdn.microsoft.com/subscript...ault.aspx#notif
ications.
Note: The MSDN Managed Newsgroup support offering is for non-urgent issues
where an initial response from the community or a Microsoft Support
Engineer within 1 business day is acceptable. Please note that each follow
up response may take approximately 2 business days as the support
professional working with you may need further investigation to reach the
most efficient resolution. The offering is not appropriate for situations
that require urgent, real-time or phone-based interactions or complex
project analysis and dump analysis issues. Issues of this nature are best
handled working with a dedicated Microsoft Support Engineer by contacting
Microsoft Customer Support Services (CSS) at
http://msdn.microsoft.com/subscript...t/default.aspx.
========================================
==========
(This posting is provided "AS IS", with no warranties, and confers no
rights.)|||Hi ,
How is everything going? Please feel free to let me know if you need any
assistance.
Sincerely,
Wei Lu
Microsoft Online Community Support
========================================
==========
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
========================================
==========
This posting is provided "AS IS" with no warranties, and confers no rights.

Enterprise Manager problem

Using SQL2000 with Enterprise Manager - sometimes, when we try to expand any
tab, such as databases or management, it comes back as empty!! Only
rebooting the server will make it come back but then at some point it stops
working again!
Any ideas much appreciated...
--
Best regards
MarkHello Mark,
Have you tried to reinstall the Enterprise Manager?
Have you applied the latest services pack of the SQL Server?
Did this issue only occur on the local server or remote server?
Please try to reinstall the Enterprise Manager and let me know the result.
Sincerely,
Wei Lu
Microsoft Online Community Support
==================================================
Get notification to my posts through email? Please refer to
http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx#notif
ications.
Note: The MSDN Managed Newsgroup support offering is for non-urgent issues
where an initial response from the community or a Microsoft Support
Engineer within 1 business day is acceptable. Please note that each follow
up response may take approximately 2 business days as the support
professional working with you may need further investigation to reach the
most efficient resolution. The offering is not appropriate for situations
that require urgent, real-time or phone-based interactions or complex
project analysis and dump analysis issues. Issues of this nature are best
handled working with a dedicated Microsoft Support Engineer by contacting
Microsoft Customer Support Services (CSS) at
http://msdn.microsoft.com/subscriptions/support/default.aspx.
==================================================(This posting is provided "AS IS", with no warranties, and confers no
rights.)|||Hi Wei Lu,
The problem happens on every client on which Enterprise Manager is
installed. It also happens if I make a remote connection. If we reboot the
server then the problem goes away on all clients but then just comes back
after a few days.
Interestingly, while the server is in this "broken" state, using SQL 2005
Management Studio seems to work with no problems.
--
Best regards
Mark
"Wei Lu [MSFT]" <weilu@.online.microsoft.com> wrote in message
news:NdFWZcMSHHA.2268@.TK2MSFTNGHUB02.phx.gbl...
> Hello Mark,
> Have you tried to reinstall the Enterprise Manager?
> Have you applied the latest services pack of the SQL Server?
> Did this issue only occur on the local server or remote server?
> Please try to reinstall the Enterprise Manager and let me know the result.
> Sincerely,
> Wei Lu
> Microsoft Online Community Support
> ==================================================> Get notification to my posts through email? Please refer to
> http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx#notif
> ications.
> Note: The MSDN Managed Newsgroup support offering is for non-urgent issues
> where an initial response from the community or a Microsoft Support
> Engineer within 1 business day is acceptable. Please note that each follow
> up response may take approximately 2 business days as the support
> professional working with you may need further investigation to reach the
> most efficient resolution. The offering is not appropriate for situations
> that require urgent, real-time or phone-based interactions or complex
> project analysis and dump analysis issues. Issues of this nature are best
> handled working with a dedicated Microsoft Support Engineer by contacting
> Microsoft Customer Support Services (CSS) at
> http://msdn.microsoft.com/subscriptions/support/default.aspx.
> ==================================================> (This posting is provided "AS IS", with no warranties, and confers no
> rights.)
>|||On Feb 6, 6:54 am, "Mark Baldwin" <sWoz...@.community.nospam> wrote:
> Hi Wei Lu,
> The problem happens on every client on which Enterprise Manager is
> installed. It also happens if I make a remote connection. If we reboot the
> server then the problem goes away on all clients but then just comes back
> after a few days.
> Interestingly, while the server is in this "broken" state, using SQL 2005
> Management Studio seems to work with no problems.
>
Wei Lu asked about service packs, you didn't answer. Are the CLIENTS
at the same service pack level as the SERVER? If not, you can see
strange things like this occur.|||Hello Mark,
Have you applied the same service pack on all the clients?
Sincerely,
Wei Lu
Microsoft Online Community Support
==================================================
Get notification to my posts through email? Please refer to
http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx#notif
ications.
Note: The MSDN Managed Newsgroup support offering is for non-urgent issues
where an initial response from the community or a Microsoft Support
Engineer within 1 business day is acceptable. Please note that each follow
up response may take approximately 2 business days as the support
professional working with you may need further investigation to reach the
most efficient resolution. The offering is not appropriate for situations
that require urgent, real-time or phone-based interactions or complex
project analysis and dump analysis issues. Issues of this nature are best
handled working with a dedicated Microsoft Support Engineer by contacting
Microsoft Customer Support Services (CSS) at
http://msdn.microsoft.com/subscriptions/support/default.aspx.
==================================================(This posting is provided "AS IS", with no warranties, and confers no
rights.)|||Hi ,
How is everything going? Please feel free to let me know if you need any
assistance.
Sincerely,
Wei Lu
Microsoft Online Community Support
==================================================
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
==================================================This posting is provided "AS IS" with no warranties, and confers no rights.

Enterprise Manager over a VPN gets No items

I have an environment that has 18 separate SQL server machines. When
connected to the LAN I can connect to each and expand the databases tab no
problem. When I try the same over a VPN I find that three of my servers will
connect but on expanding the databases I get a long pause then 'No items'.
I've checked around and found some references to the same problem (SQL
server mag site) but no resolutions. I'm running XP pro and my SQL is sp3.
The three servers in question have only TCP and named pipes in the net lib,
they are all on Win2K one is on sp3, one on sp2 and one is 'out of the box'.
The VPN has ports 1433 and 1434 udp and tcp allowed.

Does anyone have any suggestions as to what is causing this, its got to be
something simple but I've been looking at this so long now I cant see the
wood for the trees.

Help appreciated.There is a least one known issue that can produce this:

http://support.microsoft.com/default.aspx?scid=kb;[LN];Q315523

Here are some comments from an MS engineer on it:

http://groups.google.ch/groups?hl=e...%40cpmsftngxa06

There are several Google groups hits on this, by the way:

http://groups.google.com/groups?hl=...ems&sa=N&tab=wg

Simon

"Simon" <spamplin@.hss.com> wrote in message
news:bdpe27$k71$1@.hercules.btinternet.com...
> I have an environment that has 18 separate SQL server machines. When
> connected to the LAN I can connect to each and expand the databases tab no
> problem. When I try the same over a VPN I find that three of my servers
will
> connect but on expanding the databases I get a long pause then 'No items'.
> I've checked around and found some references to the same problem (SQL
> server mag site) but no resolutions. I'm running XP pro and my SQL is sp3.
> The three servers in question have only TCP and named pipes in the net
lib,
> they are all on Win2K one is on sp3, one on sp2 and one is 'out of the
box'.
> The VPN has ports 1433 and 1434 udp and tcp allowed.
> Does anyone have any suggestions as to what is causing this, its got to be
> something simple but I've been looking at this so long now I cant see the
> wood for the trees.
> Help appreciated.

Enterprise Manager locks on expanding databases folder

I'm having a very irritating situation occur with
Enterprise Manager.
I expand the databases folder after logging in to our
server and the application goes into 'not responding' mode.
There are about 200 databases to list, so I tried just
putting it in background... for four hours !!!!!
I killed the EM and tried this repeatedly, to no avail.
Does anyone know why this happens and what to do about it?Randy,
Are you on the latest service pack? Assuming its SQL2000, see
FIX: Opening the Database Folder in SQL Server Enterprise Manager 2000 Takes
a Long Time
http://support.microsoft.com/default.aspx?scid=kb;en-us;282416
Dinesh.
SQL Server FAQ at
http://www.tkdinesh.com
"randyv" <randy.volters@.whaleyfoodservice.com> wrote in message
news:061001c361d3$4bd83480$a101280a@.phx.gbl...
> I'm having a very irritating situation occur with
> Enterprise Manager.
> I expand the databases folder after logging in to our
> server and the application goes into 'not responding' mode.
> There are about 200 databases to list, so I tried just
> putting it in background... for four hours !!!!!
> I killed the EM and tried this repeatedly, to no avail.
> Does anyone know why this happens and what to do about it?|||> Does anyone know why this happens and what to do about it?
http://www.aspfaq.com/2469

Enterprise manager is slow!

I have a number of machines connecting to SQL server.
When using Enterprise Manager, half of them take around 5
minutes to expand the database tree, while the other half
are fine. The only difference in the computer I can find
is that the slow ones are running Delphi. Is there a
known issue with EM and Delphi? If not, can anyone
suggest things I can try to sort out this problem?
"Graeme" <anonymous@.discussions.microsoft.com> wrote in message
news:1ba201c49a3e$27b13030$a501280a@.phx.gbl...
> I have a number of machines connecting to SQL server.
> When using Enterprise Manager, half of them take around 5
> minutes to expand the database tree, while the other half
> are fine. The only difference in the computer I can find
> is that the slow ones are running Delphi. Is there a
> known issue with EM and Delphi? If not, can anyone
> suggest things I can try to sort out this problem?
As a troubleshooting step, if you de-install Delphi on one of the problem
clients, then EM loads faster?
Steve

Enterprise Manager - Database list hangs

I have this problem on a couple of machines, where when I expand the
Database list under the server (typically the local server, i.e. the one EM
is installed on) it takes a very long time to respond and sometimes hangs
for over 10 minutes.
The only KB article I could find was referring to a problem with a large
number of databases, whereas these only have about 10-20 databases on them.
I assume it's some sort of name resolution problem - any ideas how to debug
what's happening?
Paul
See of you have ODBC tracing turned on...
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"Paul Hatcher" <phatcher@.nospam.cix.co.uk> wrote in message
news:%23zkR9x0wFHA.2924@.TK2MSFTNGP15.phx.gbl...
>I have this problem on a couple of machines, where when I expand the Database list under the server
>(typically the local server, i.e. the one EM is installed on) it takes a very long time to respond
>and sometimes hangs for over 10 minutes.
> The only KB article I could find was referring to a problem with a large number of databases,
> whereas these only have about 10-20 databases on them.
> I assume it's some sort of name resolution problem - any ideas how to debug what's happening?
> Paul
>
|||Tibor, thanks but no cigar - not turned on.
I'll try using the profiler any see if I can see anything - there's no
obvious CPU actvitity whilst it's hanging so I think it might be down to
networking issues of some sort.
Paul
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
message news:ObaZv60wFHA.720@.TK2MSFTNGP10.phx.gbl...
> See of you have ODBC tracing turned on...
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
> Blog: http://solidqualitylearning.com/blogs/tibor/
>
> "Paul Hatcher" <phatcher@.nospam.cix.co.uk> wrote in message
> news:%23zkR9x0wFHA.2924@.TK2MSFTNGP15.phx.gbl...
>
|||Also make sure autoclose is turned off for the databases and
that you have applied the latest service packs on the client
where Enterprise Manager seems to hang. There were some
fixes for the issue you described in one of the service
packs.
-Sue
On Thu, 29 Sep 2005 10:24:30 +0100, "Paul Hatcher"
<phatcher@.nospam.cix.co.uk> wrote:

>Tibor, thanks but no cigar - not turned on.
>I'll try using the profiler any see if I can see anything - there's no
>obvious CPU actvitity whilst it's hanging so I think it might be down to
>networking issues of some sort.
>Paul
>"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
>message news:ObaZv60wFHA.720@.TK2MSFTNGP10.phx.gbl...
>
|||Paul
Check the service pack version of Enterprise Manager. There was a bug in an
earlier build (before sp3) where EM did a self join of sysdatabases, and if
that was combined with the autoclose option as Sue suggested, it could take
a LONG time to open the list. Make sure you check the version of the tools
on the client machine, not the version of the server. Sometimes people
forget to apply a sp to all the clients.
HTH
Kalen Delaney, SQL Server MVP
www.solidqualitylearning.com
"Paul Hatcher" <phatcher@.nospam.cix.co.uk> wrote in message
news:%23zkR9x0wFHA.2924@.TK2MSFTNGP15.phx.gbl...
>I have this problem on a couple of machines, where when I expand the
>Database list under the server (typically the local server, i.e. the one EM
>is installed on) it takes a very long time to respond and sometimes hangs
>for over 10 minutes.
> The only KB article I could find was referring to a problem with a large
> number of databases, whereas these only have about 10-20 databases on
> them.
> I assume it's some sort of name resolution problem - any ideas how to
> debug what's happening?
> Paul
>