Okay, this is a different scenario. The web application is connecting via a service account, so Windows authentication is being used as far as the connection between those two tiers....

I know others are doing this because I remember listening to a podcast a few weeks ago where this exact approach was taken. Basically infinite drill down.

However, it sounds...

Yup, because you'll see the events in the system and application event logs. Also, most hardware vendors have monitoring tools. For instance, HP has SIM and IBM has Director. Both...

A small but important point: it depends. Windows Vista Enterprise and Ultimate has BitLocker and this is the only full disk encryption available on a Windows platform. EFS is not...

It depends... but yes, in your curent configuration you should be connecting via Kerberos.

As for documentation, here is a Microsoft KB article on the subject:

How to use Kerberos authentication...

Can you post the contents of: usp_DBCC_CHECKDB (sanitized, of course)?

In SQL Server 2000, you can use the sp_addrole system stored procedure or the GUI via Enterprise Manager. Once you create this new user role, it can be made a...

If connecting to SQL Server, SQL Server can be set up to use an SSL certificate and create encrypted connections. Encryption can be forced on for all connectins using Server...

What I typically do is what Steve selected. I Ctrl+click on the thread and the Post Reply links to spawn them in new windows.

Yup, and it's a nice feature. This article is back from the SQL Server 2000 days. It is another one I need to update.

Security vs. functionality is always a trade-off. Ultimately it boils down to business decision on risk. The bottom line is at some point you must trust administrator level personnel. While...

While I don't disagree with you, because I have that t-shirt, too, sometimes we don't get much of a choice.

The tray app is called Service Manager and its sole purpose is to tell you the status of various SQL Server services (such as the main engine and the SQL...

You can also disable the sa login altogether in SQL Server 2005 (like you can disable the Administrator account on Windows Server 2003).

Are you using REPAIR_FAST?