SQL Server Troubleshooting

Security

How-To's, guidelines, recommendations

• Security Considerations for SQL 2008 and SQL 2005
• 980671 - Correcting the lack of cryptographic salt variation on SQL Server sa login hash
• Auditing in SQL Server 2008
• 2000274 - How to fix permission issues when moving MSDB database between different instances
• 910401 - How to use Microsoft System Center Data Protection Manager 2006 to help protect a SQL Server database
• 325877 - How to control access to a database on a Web server in Windows Server 2003



• 319723 - How to use Kerberos authentication in SQL Server
• How to: Enable Kerberos Authentication on a SQL Server Failover Cluster

Known issues

• 811889 - How to troubleshoot the "Cannot generate SSPI context" error message
• 2003047 - Database mirroring wizard could fail on servers where FIPS is enabled

Further reading / links

• SQLSecurity.com