After a patch, SQL Server would not start: assembly ISSERVER was not found in the SQL Catalog of database SSISDB. Here is what the ERRORLOG showed and the fix.
SQL SERVER – Startup Error: 17190, Severity: 16 – Initializing the FallBack Certificate Failed with Error Code: 1, State: 20
A client’s SQL Server would not start with Error 17190: initializing the FallBack Certificate failed. Here is how we found the cause on a call and fixed it.
How to Auto Start SQL Server After a Crash
To auto start SQL Server after a crash, set the Windows service to restart itself on failure, and set its start mode to Automatic for a reboot. This post checks what a server has today with T-SQL and the sc command, sets the three places that matter, and shows how to find the cause of the crash. A restart gets the server running again, and it doesn’t find the cause.
Run a Stored Procedure at Startup in SQL Server
To run a stored procedure at startup, create it in the master database and mark it with sp_procoption. This post builds a demo that writes one row every time the instance starts. It also covers the rules, how to check the setting, and how to turn it off again.
SQL SERVER – Empty Startup Parameters in SQL Server Configuration Manager
Configuration Manager showed Empty Startup Parameters when I tried to change the ERRORLOG location in my lab. Here is where they are stored and how to fix it.
SQL SERVER – Unable to Start SQL Server – TDSSNIClient Initialization Failed with Error 0x2, Status Code 0x38
SQL Server would not start: TDSSNIClient initialization failed with error 0x2, status code 0x38. Process Monitor and the SuperSocketNetLib key helped.
Asking a SQL Question That Gets Answered: The Reproducible Script
Write a reproducible script with minimal tables, synthetic rows, the failing query, expected results, and the exact SQL Server version.