![MySQL - Connection Error - [MySQL][ODBC 5.3(w) Driver]Host 'IP' is Not Allowed to Connect to this MySQL Server](https://blog.sqlauthority.com/wp-content/uploads/2018/03/mysql-login-err-04.jpg)
Setting up a linked server to MySQL, the ODBC test failed: Host ‘IP’ is not allowed to connect to this MySQL server. Here is how I fixed it.
SQL SERVER – AlwaysOn Automatic Seeding – Database Stuck in Restoring State
A client used AlwaysOn automatic seeding for a huge database, but it stayed in Restoring state on the secondary. Here is the reason we found.
QL SERVER – Unable to Create Listener: Msg 41009 – The Windows Server Failover Clustering (WSFC) Resource Control API Returned Error Code 5057
Creating an AG listener failed with Msg 41009: the Windows Server Failover Clustering (WSFC) resource control API returned error 5057. Here is the fix.
SQL SERVER – The Report Server Cannot Open a Connection to the Report Server Database. (rsReportServerDatabaseLogonFailed)
A report viewer failed with rsReportServerDatabaseLogonFailed: the report server cannot open a connection to the report server database. Here is the fix.
SQL SERVER – FIX: Error 14001: The Application Has Failed to Start Because its Side-by-side Configuration is Not Correct
Error 14001 stopped a development SQL Server service. The SideBySide event identified an amd64 VC80 ATL assembly, guiding a more precise runtime investigation.
SQL SERVER – FIX: Msg 3231 – The Media Loaded on “Backup” is Formatted to Support 1 Media Families, but 2 Media Families are Expected According to the Backup Device Specification
Preparing a demo, I hit Msg 3231: media formatted for 1 media family, but 2 Media Families are expected. Here is what causes it and how to fix it.
Identify SQL Server Version From a Backup File
To identify SQL Server version from a backup file, run RESTORE HEADERONLY and read DatabaseVersion and SoftwareVersionMajor. This post makes a demo backup, reads its header, and maps the numbers to products. It also shows how to compare the backup with your server in T-SQL, and why a header sometimes fails to read on an older server.