I've only seen a corrupt sysindexes table once or twice in 20+ years. Unfortunately I do not have the answer. Both times I encountered thie error I called MS PSS because it...

Without using the /3GB switch in the boot.ini file (and other 'default' parameters), no matter what you set you min/max server memory for SQL Server to you will only see...

It is TCP port 445.

Yes. I had the same situation while back in working through a firewall with the default rule set of "DENY ALL". We used Ethereal (a network sniffing tool that's...

Staying 'conencted' is a conscious choice that each individual makes. This however is not without consequence as we all know. I personally have been on 24x7 call for more than...

If the login has no rights (are not users, nor have defined roles) to the database they cannot do anything, just see the database name ! They will also get...

SQL 2K 'standard' can only configured to use 2 Gb of RAM (1.8 or so if you look in the task manager) no matter the OS.

Check to make sure that TCP port 445 is open (not being blocked by a network firewall or the Windows firewall) in both directions between the client and server machines....

You can do something similar, say with an EMC SAN using BCVs - business continuance volumes. i.e. a second set of 'mirrored' SAN volumes. Break the pair of mirroered volumes...

To reiterate ...What's the OS and SP level ... Use My Computer|Properties ... Is it possibly Windows 2003 Web Edition ?

The message you indicate is somewhat misleading because I...

Have you tried connecting from the server console using Windows Authentication ?

The server is listening for named pipes and TCP/IP on port 1433 - both normal.

As for your space problem,...

What's the OS and SP level ... Use My Computer|Properties ... Is it possibly Windows 2003 Web Edition ?

What does the SQL Server errorlog have to say ?

Other questions for background:

• How many CPUs ? How fast are they ?
• How much RAM ?
• How many disks in the server ?
• Areyou using a SAN ?
• What is the OS version and...

Just my $0.02 ... Unplugging the network cable can have unwanted affects like jostling another server cable in the same rack - whether it be power, network, crossover or KVM....