Configure Distribution failed with SQL Server replication requires the actual server name to make a connection. Here is why and how to fix it.
SQL SERVER – ERROR: Autogrow of file ‘MyDB_log’ in database ‘MyDB’ was cancelled by user or timed out after 30121 milliseconds
Found Autogrow of file was cancelled by user or timed out in your ERRORLOG? Here is what this message means for performance and why a smaller FILEGROWTH helps.
SQL SERVER – FIX – Error: Alter failed for Server ‘Server Name’ in Check Integrity task
My CHECKDB maintenance plan failed with Alter failed for Server in the Check Integrity task. Profiler led me to sp_configure and a recovery interval problem.
SQL SERVER – Database Mirroring login attempt failed – Connection handshake failed
While building an AlwaysOn demo I hit the Database Mirroring login attempt failed error with a connection handshake failure. Here is how I fixed it.
SQL SERVER – Fix @@ServerName Property Value When Incorrect
A colleague’s @@ServerName returned NULL instead of the server name. Here is why the value can be wrong and how to fix the @@ServerName property.
SQL SERVER – DBCC CHECKDB errors – Msg 2520 during executions
Running DBCC CHECKDB on ResourceDB returns Msg 2520. I explain why CHECKDB cannot run on the hidden resource database and what you can do instead.
SQL SERVER – Login failed for user . Reason: Token-based server access validation failed
Login failed for user. Reason: Token-based server access validation failed. Here is how the state of error 18456 in the ERRORLOG shows the cause and fix.