Part of my GDPR series: Authentication in SQL Server, Windows and Mixed Mode, and how it helps with GDPR Article 25, data protection by design and default.
SQL SERVER – SQL Vulnerability Assessment – Security Analysis
SQL Vulnerability Assessment, free in SSMS 17.4 and later, scans SQL Server 2012 and up for security issues and also suggests fixes. Here is how it works.
SQL SERVER – Account Added Automatically in SQL Server Used by SharePoint
A departed user’s account kept being added automatically to SharePoint database roles. How to catch who adds it, and from where, on SQL Server 2025.
SQL SERVER – Msg 32055 – sp_refresh_log_shipping_monitor – There Was an Error Configuring the Remote Monitor Server
Msg 32055, error configuring the remote monitor server, hides the real error. Read from the procedure on SQL Server 2025, with a safer fix than sa.
SQL SERVER – List Users with System Admin (sysadmin) Rights – Part 2
After my post on listing users with System Admin (sysadmin) rights, Chris Mangrum shared a better script that also covers CONTROL SERVER. Here it is.
SQL SERVER – List Users with System Admin (sysadmin) Rights
My health check needs a DBA with sysadmin rights. Here is a simple script to list users with system admin rights on your SQL Server.
SQL SERVER – Login Failed. The Login is From an Untrusted Domain and Cannot be Used with Windows Authentication – SPN Issue
Login failed, untrusted domain, error 18452, and a cluster that would not fail over. The cause was an SPN. How to read the SPN messages.