A vendor’s installer failed because SQL Express would not install: Wait on the Database Engine recovery handle failed. Here is what the setup logs showed.
SQL SERVER – Error Due to Database Context – Error 208 – Invalid Object Name
Stuck on Error 208, Invalid Object Name, in SSMS? Often the object is fine and you are simply in the wrong database. Here is how database context causes it.
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 – Msg 1038 – An Object or Column Name is Missing or Empty. For SELECT INTO Statements, Verify Each Column Has a Name
Creating a login in SSMS failed with Msg 1038: an object or column name is missing or empty. Profiler showed the real cause. Here is what went wrong.
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.
Error 0x80040E4D: SaveToSQLServer Fails With Login Failed for sa
Error 0x80040E4D stopped a client from saving a maintenance plan, with Login failed for user sa at the end of the message. The sa login was locked out by another maintenance plan that still used an old password. Windows authentication worked in the meantime.
SQL SERVER – The Operating System Returned the Error 21(The Device is Not Ready.) While Attempting ‘GetDiskFreeSpace’ on ‘A:\’
While testing SQL Server 2017, I found Error 21 (the device is not ready) in the ERRORLOG for GetDiskFreeSpace on drive A. Here is why it shows up.