Windows 2003 Server Standard x64 bit. Whenever I run SQL Enterprise Manager
on the server via RDP, the server stops responding. At this time, when IRDP
another session I dont get the windows login screen...all I get is grey
screen and mouse pointer....it is as if the server is hung. Most of the
times, I have no other option than hard rebooting the server.
What is wrong here?
"Rajan" wrote:
> I'm running SQL 2000 Server Enterprise Edition, SP4 (hotfix - 8.00.2187) on
> Windows 2003 Server Standard x64 bit. Whenever I run SQL Enterprise Manager
> on the server via RDP, the server stops responding. At this time, when IRDP
> another session I dont get the windows login screen...all I get is grey
> screen and mouse pointer....it is as if the server is hung. Most of the
> times, I have no other option than hard rebooting the server.
> What is wrong here?
|||When you reboot the server, do you see anything in the event log or SQL
Server error logs?
Aaron Bertrand
SQL Server MVP
"Rajan" <Rajan@.discussions.microsoft.com> wrote in message
news:E79E49FB-AEC5-42ED-A296-96DBB92A9944@.microsoft.com...
> I'm running SQL 2000 Server Standard Edition, SP4 (hotfix - 8.00.2187) on
> Windows 2003 Server Standard x64 bit. Whenever I run SQL Enterprise
> Manager
> on the server via RDP, the server stops responding. At this time, when
> IRDP
> another session I dont get the windows login screen...all I get is grey
> screen and mouse pointer....it is as if the server is hung. Most of the
> times, I have no other option than hard rebooting the server.
> What is wrong here?
|||This can happen on SQL 2000 servers with lots of (large)tables (it has to
load all tables in memory) in combination with minimal availability of
resources and a very bussy database.
This can lead to a time- out in enterprise manager.
after you made the rdp session.Use query analyzer to connect to the database
Cheers,
harry
|||Nope...nothing reported in either logs.
"Aaron Bertrand [SQL Server MVP]" wrote:
> When you reboot the server, do you see anything in the event log or SQL
> Server error logs?
> --
> Aaron Bertrand
> SQL Server MVP
>
>
> "Rajan" <Rajan@.discussions.microsoft.com> wrote in message
> news:E79E49FB-AEC5-42ED-A296-96DBB92A9944@.microsoft.com...
>
>
|||Well, it might just be that you are not waiting long enough, as another
poster suggested. Can you use Query Analyzer instead? Can you use
Enterprise Manager remotely instead of only within an RDP session?
Aaron Bertrand
SQL Server MVP
"Rajan" <Rajan@.discussions.microsoft.com> wrote in message
news:8D2F17A5-2A89-418F-9980-38796783319C@.microsoft.com...[vbcol=seagreen]
> Nope...nothing reported in either logs.
> "Aaron Bertrand [SQL Server MVP]" wrote:
No comments:
Post a Comment