A SQL Server 2012 install failed with an error while enabling windows feature NetFx3. Here are the steps to turn on .NET Framework 3.5 in Server Manager.
SQL SERVER – Assembly ‘ISSERVER’ Was Not Found in the SQL Catalog of Database ‘SSISDB’
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.
SQL SERVER – How to Auto Start SQL Followed by a Crash?
A client’s SQL Server crashed at random and they asked if it could auto start afterwards. Here is my answer, covering the two kinds of crash on Windows.
SQL SERVER – Configure Stored Procedure to Run at Server Startup – Simple Tutorial
Want a stored procedure to run every time SQL Server starts? Enable scan for startup procs, then mark the procedure to run at server startup.
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.