If you're using paramerized stored procedures, this probably goes without saying, but just to be safe... ensure the permissions are issued only against the stored procedures and take advantage of...

There isn't a Sarbanes-Oxley for Idiots book, unfortunately, since a lot of S-Ox is still like HIPAA... open for legal interpretation.

Sarbanes-Oxley, in a nutshell, is designed to ensure non-fraudulent financial...

You want to take a look at the system stored procedure sp_helprotect.

Does the MSSQLSERVER service start and stay running? What are the contents of the ERRORLOG file indicating? Any errors in the Application or System event log for the system?

SQL Server has no documented internal mechanism for encrypting/decrypting data in this manner. Microsoft will point you to the use of third parties. Protegrity is one such vendor.

Can you give a bit more specs about your configured environment?

Can you access the SQL Server from the console (at the server itself) using Enterprise Manager or Query Analyzer?

As another said, ApexSQL log can do this for the most part. Might be better to have a sql trace, though, using Profiler or the trace stored procedures if it's...

You can basically follow Brian Knight's instructions to get the initial SQL Server instance online with two main exceptions:

1) DTC needs its own physical drive, name, and IP address (and...

User login is handled at the beginning of the connection. From that point forward it basically maintains the session, so the user login won't get passed a second time. You'll...

For clusters, no, you don't want to use local group. The groups, while named the same to you and me, will have different SIDs on each node of the cluster....

They haven't backed off on the OS side... however, from a SQL Server perspective I lean towards global groups when I'm considering a rapid recovery situation... here's why. A Windows...

The cluster account should be made a member of the sysadmin role.

http://support.microsoft.com/default.aspx?scid=kb;EN-US;263712

Run a Profiler trace to see the connection being created and the stored procedure being executed. Add Exceptions & Warnings to see if the stored procedure is throwing an exception when...

The .ActiveConnection needs to be an open ADODB.Connection object. You have to explicitly open a connection and that seems to be what's missing. Something akin to...

    .

    .

    .

    Dim oConn

   ...