After I changed the SQL Server service account in my lab, the Always On secondary replica went disconnected. Here is why the endpoint rejects the new account.
SQL SERVER – Unable to Bring SQL Cluster Online – Reason: The Account is Disabled
After security hardening, a client’s SQL cluster resource sat in Online Pending, then failed: the account is disabled. Here is how we found and fixed it.
SQL SERVER – Simple Script to Create a Login and User for a Specific Database with System Admin Rights
Do you know the difference between a SQL Server login and a user? Here is a simple script to create a login and user for a database with admin rights.
SQL SERVER – Be Careful with Logon Triggers – Don’t use Host_Name
A reader used HOST_NAME() in a logon trigger to limit access. Here is why that is risky, and why Logon Triggers can lock everyone out if you are not careful.
SQL SERVER – Database Attach Failure – Msg 2571 – User ‘guest’ Does Not Have Permission to Run DBCC Checkprimaryfile.
Attaching MDF and LDF files after a disaster failed with Msg 2571: user guest does not have permission to run DBCC checkprimaryfile. Here is the fix.
SQL SERVER – Create Catalog Error 911: Database ‘SSISDB’ Does Not Exist. Make Sure That he name is entered correctly
Doing create catalog in SSMS failed with Error 911: database SSISDB does not exist. Here is how SQL Server Profiler showed me the real cause.
SQL SERVER – Authentication in SQL Server (Windows and Mixed Mode) – GDPR Series
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.