Seen hex error codes like 0x80070070 in the ERRORLOG? Here are the simple steps I use to convert hex Windows error codes into meaningful error messages.
Event ID 7034: MSSQLSERVER Service Terminated Unexpectedly
Event ID 7034 reports that the MSSQLSERVER service terminated unexpectedly. The Application log held an APPCRASH entry with exception code 0xC0000005, an access violation. A clean restart of the server cleared the problem.
SQL SERVER – Backup to URL – Script to Generate the Create Credential and Backup Command using Access Keys
Backup to URL can use a SAS token or access keys. Here is a script that builds the CREATE CREDENTIAL and BACKUP commands from your Azure storage access keys.
SQL SERVER Analysis Services – Unable to Start Service. Error: The Filename, Directory Name, or Volume Label Syntax is Incorrect
SQL Server Analysis Services would not start: the filename, directory name, or volume label syntax is incorrect. Here is what the event log showed and the fix.
SQL SERVER – Unable to See SQL Server Configuration Manager. How to Open it?
A reader had no Start menu shortcut for SQL Server Configuration Manager and could not find it. Here is how to open it anyway.
SQL SERVER – Database Mail Error: The SMTP Server Requires a Secure Connection or the Client Was Not Authenticated. The Server Response Was: 5.5.1 – Using Gmail
In my earlier blog, we saw one possible cause database mail error due to SSL settings. Today we will learn about another Database Mail Error.
SQL SERVER – gMSA: The Service Did Not Start Due to a Logon Failure
SQL Server running under a gMSA would not start: the service did not start due to a logon failure, yet no password had expired. Here is the real cause.