Have you gone into SQL Server Configuration Manager (Start | All Programs | Microsoft SQL Server 2005 | Configuration Tools | SLQ Server Configuration Manager) and enabled the protocols you...

Also, if that is the real server name, user, and password, please change your password immediately. Keep in mind you just posted it to a public forum which gets indexed...

Removing BUILTIN\Administrators from the system administration role will take away "sa rights" but will still allow members of the local Administrators group to connect to SQL Server. Steve's suggestion, to...

Are you able to see any of the databases other than master (such as tempdb)? Also, are you able to log on to SQL Server as said user with another...

It's passed by the client and as a result is not guaranteed to be reliable. It's fairly easy to spoof:

Auditing with SQL Profiler

It is possible to run both SQL Server 7.0 and 2000 on the same machine. It is also possible to run SQL Server 2000 and 2005 on the same machine....

ALTER LOGIN is for SQL Server 2005... Enterprise Manager is used to manage SQL Server 2000 (and 7.0, since it supported those). SQL Server 2000 uses sp_password, and that requires...

and the wan link is down, there are procedures in place that a designated person at the facility can be guided through by a DBA

Nope, you got it. That's what...

Before going to uninstall route, which will take several hours, have you tried contacting Microsoft Support? If it's a genuine bug, you most likely won't be charged. If it isn't...

Actually it's relevant from an information disclosure issue. EM is an easy tool to see all the databases and users that exist on a SQL Server. So even though you...

How are you handling network outages?

Performance also depends on what type of virtual technology you are using. For instance, VMware ESX server has tweaks not available in GSX or in Microsoft's Virtual Server. However, as...

Strictly speaking, it is not necessary for DBAs to be administrators of the systems themselves. It tends to make the job easier for everyone around, and so some organizations consider...

There are several issues with encryption at the database level:

1) If I get access to the views, I can see the unencypted data anyway.

2) if I am a sysadmin and...

Are you able to log on as the service account and send email normally (though Outlook, not SQL Server)? If so, are you able to do so through Outlook on...