SSISDB grew huge on a client’s server. Here is my cleanup script for the SSISDB catalog database, and why I avoid scripts that modify system objects.
SQL SERVER – Initializing the FallBack Certificate Failed With Error Code: 1, State: 20, Error Number: 0
After a service account password change, SQL Server would not start: Initializing the FallBack certificate failed, error code 1. Here is the fix.
SQL SERVER – Unable to Load User-Specified Certificate [Cert Hash(sha1) “Thumbprint.here”]. The Server Will Not Accept a Connection
While preparing a security demo, I broke my SQL Server and it would not start: Unable to load user-specified certificate. Here is how I fixed error 26014.
ENCRYPTBYPASSPHRASE: Simple Encryption and Its Weak Spot
One function in, one function out, and then the real question: where does the passphrase live? A short tour with demos you can run.
Domain Controller – Startup Issue – Unable to Use Domain Account as Service Account When Read Only Domain Controller (RODC) is Involved
SQL Server would not start under a domain account when a Read Only Domain Controller (RODC) was involved. Here is what fixed it.
SQL SERVER – System. Security. Cryptography. CryptographicException – There Was an Error Generating the XML Document
SQL Server setup failed with an error generating the XML document. The real cause was DPAPI and a read-only domain controller, found in Summary.txt.
SQL SERVER – AlwaysOn AG (Availability Group) and TDE Error – Please Create a Master Key
A TDE enabled database would not synchronize in an AlwaysOn availability group, and ERRORLOG said please create a master key. Here is what I found.