Opening SQL Server Configuration Manager failed with: MMC could not create the snap-in. A reader on Facebook asked, and here is how to fix it.
SQL SERVER – FIX: Error 1807 Could not obtain exclusive lock on database ‘model’. Retry the operation later – Part 2
Msg 1807, could not obtain exclusive lock on database ‘model’, still shows up in SQL Server 2016. Here is another cause of Error 1807 and how to fix it.
SQL SERVER – FIX: SQL Profiler Error – Cannot Retrieve Trace Definition for SQL Server Version
Profiler on SQL Server 2016 showed an empty message box, then ‘Cannot retrieve trace definition for SQL Server version’. How I fixed this SQL Profiler Error.
SQL SERVER – Unable to Start SQL Server – TDSSNIClient Initialization Failed with error 0xd
SQL Server would not start, and ERRORLOG showed TDSSNIClient initialization failed with error 0xd, status code 0x10. Here is what I found.
SQL SERVER – Error Msg 5042, Level 16 – The File ‘tempdev02’ Cannot be Removed Because it is Not Empty
Removing an extra TempDB file gave me Error Msg 5042: the file ‘tempdev02’ cannot be removed because it is not empty. Here is how I got rid of it.
SQL SERVER – FIX: Setup Was Not Able to Access Domain
A DBA installing SQL Server 2012 on a virtual machine got ‘Setup was not able to access domain’. Here is what the message means and how to get past it.
SQL SERVER – Unable to Open Maintenance Plan in Management Studio
SSMS refused to open a maintenance plan and showed an error instead. Here is what I did when I was unable to open Maintenance Plan in Management Studio.