Have you created the Server Audit HIPPA_Audit? Also, are you testing against either SQL Server 2008 Enterprise Edition or Developer Edition? If not, the Audit object is only for EE...

This is the application event log, but the error given is for invalid credentials. Do you see an error in the Security event log? If so, what does it say?

If SQL Server 2005 is installed on a Windows Server 2003/2008 system, it will, by default, use the account password settings of the domain (or the local computer, if not...

You're correct, the Audit object doesn't collect the hostname. The hostname, as it comes into SQL Server, can be forged. This is another case where like MySQL, I wish SQL...

I didn't see the forum, but if you're using SQL Server 2000 (not 2005 or 2008), then encryption HAS to occur at the web server level unless you use a...

When he attempts to login from the workstation where his account is failing, do you see a failed login attempt on the SQL Server corresponding to the attempt? If so,...

The SSL certificate allows you to have an encrypted connection for your web site. It doesn't encrypt the data to the back-end. So it doesn't enter into your decision.

The question...

All right, let's break this down to the basics...

EXECUTE rights against a stored procedure allows you to execute the stored procedure.

SELECT, INSERT, UPDATE, and DELETE rights allow you to...

Is there anything in the event logs for either set of servers when you've got it scheduled for 5 minutes or more? Specifically in the system event log about network...

Is the Windows firewall on from the other machine when he logs on?

Congratulations, SSC and community!

The EXECUTE AS is part of the stored procedure definition itself. If you look at the Books Online write-up for CREATE PROCEDURE, you'll see in the syntax specification and in...

Check to make sure the user is not a member of the db_datareader or db_datawriter roles. Those give implicit permissions and so you don't see it unless you check the...

I'm blind. You've got a syntax error in your insert statement. You've got the cast and convert and decrypt by key where you're supposed to be declaring the columns to...

You said the public role has permissions, right? Every database user is a member of the public role. There are no exceptions. Therefore, if the public role has permissions, every...