Still on SQL Server 2000 SP 4? Apply these two security updates for SQL Server 2000 and plan your upgrade, since there is no direct path to SQL Server 2012.
SQL SERVER – Beginning of SQL Server Security
The beginning of SQL Server security: how authentication, logins, users and permissions work together to keep your data safe from misuse.
SQL SERVER – Solution – User Not Able to See Any User Created Object in Tables – Security and Permissions Issue
A friend could connect to SQL Server but could not see any user created object, while his colleague could. It was a security and permissions issue.
SQL SERVER – Introduction to SQL Server Security – A Primer
A primer on SQL Server Security terms with a simple story: Tom needs Read access to the Financial Folder. Learn what a securable, principal and permission are.
SQL SERVER – guest User and MSDB Database – Enable guest User on MSDB Database
I advise disabling the guest user in user databases, but it should stay enabled in the MSDB Database. Here is why, and how to enable it again if it was turned off.
SQL SERVER – Detecting guest User Permissions – guest User Access Status
Is the guest user enabled or disabled, and what is the default? I answer reader questions and show ways to detect guest user access status.
SQL SERVER – Force Removing User from Database – Fix: Error: Could not drop login ‘test’
Error 15434: could not drop login ‘test’ because the user is logged in. A reader ran my demo on production; here is my Force Removing User fix, no restart needed.