Login Failed

Find SQL Server Authentication Mode Configuration

Quick Method to find Configured???????????????????????? Authentication Mode

Automate collection and saving of failed logins for SQL Server

I re-cycle my SQL Server log every night using sp_cycle_errorlog. However, before I do, I would like to capture all of the failed logins recorded. I have auditing turned on for failed logins, but I want to make sure that I capture those events into a table so I can report on. How can I do this?

MD2

Cryptography

Grant Mass permissions

Create A role and grant it a permission on a DB Schemas.

Blocking Users by IP

SQL Server MVP Brian Kelley brings us a great new article that solves a problem that might help your security. In this short piece, we learn how we can use logon triggers to block users based on their IP address.

List all permissions in all databases

This script will allow you get all the users and roles with permission on objects on all databases.

SQL Server Encryption Key Management between Development, Test and Production Environments

The company I work for has decided to use the encryption technology available in SQL Server 2005. We have almost everything ironed out except for which keys to use in the development, testing, and production environments. Should we use one key for all three environments or different keys for each?

Determine Users with Permission on an Object

This script will walk the hierarchical chain of users and roles to find users with permissions on an object.