Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Carlh
Starting Member
3 Posts |
 Posted - 2010-07-06 : 04:29:43
|
| Hi,Im having some major issues with SQL 2000. Im running it on Server2003, SQL2000 with SP4. We have 2 servers running the exact same spec, QuadCPU, 4GIG RAM, one of which, Enterprise Manager freezes whenever the Databases tree-node is opened. Enterprise just sits there, task manager is showing it as not-responding. SQL itself is still running fine, i.e. applications (websites and VB Apps, including Citrix) can still access the data as normal, its like we've lost the front-end of the system.I cant even access the Management section of the manager, including forcing a backup of the databases, however, the nightly backup that SQL Server performs is still working, just cant get through the front-end.Our system engineer has rolled back hotfixes but the issue remains. Any ideas before I end up re-installing at 3am in the morning. Yawn. lol.Carl |
|
|
Kristen
Test
22859 Posts |
Posted - 2010-07-06 : 04:44:37
|
| Long-shot: Connection protocol? e.g. using Named pipes instead of TCP/IP?(Assuming you aren't talking about Enterprise Manager ON the server, and are connecting from a remote PC - if not does it work with Enterprise Manger ON a remote PC?) |
 |
|
|
Carlh
Starting Member
3 Posts |
Posted - 2010-07-06 : 05:28:32
|
| It wont connect via Enterprise manager ON the server itself, or on its sister server (which works fine). Does exactly the same thing remotely as it does locally, just freezes upon opening up the database node.Carl |
|
|
|
Kristen
Test
22859 Posts |
Posted - 2010-07-06 : 06:53:07
|
OK, not connection protocol then  Long-ish-shot! DBCC CHECKDB the databases in case any corruption? |
|
|
|
Carlh
Starting Member
3 Posts |
Posted - 2010-07-06 : 08:54:03
|
| I can't open up the Database node, so I cant open up the Query Window.... Applications are fine connecting and using the DBS. Just cant get to the front-end. I'll just uninstall SQL and re-install, then attach the DBs in the early hours of the morning. Thanks anyway Kristen, most appreciated. :) |
|
|
|
Kristen
Test
22859 Posts |
Posted - 2010-07-06 : 10:35:20
|
| "I can't open up the Database node, so I cant open up the Query Window"Query Analyser won't connect either? (I reckon it should, if APPs can - QA is not as bothered to load all database structure etc. to display nice GUI interface ) |
|
|
|
|
|
|
|
|
SQL 2000 Freezing