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.
Error 14001 in SQL Server: Side-by-Side Configuration Is Not Correct
Error 14001 reports a side-by-side configuration failure before a program starts, and the Application log event names the missing assembly. This post reads that event, matches the assembly to its architecture and checks WinSxS and the installed runtimes with tested PowerShell commands.
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.
SQL SERVER – Database Attach Failure – Msg 2571 – User ‘guest’ Does Not Have Permission to Run DBCC Checkprimaryfile.
Attaching MDF and LDF files after a disaster failed with Msg 2571: user guest does not have permission to run DBCC checkprimaryfile. Here is the fix.
SQL SERVER – Fix Error 3271: A nonrecoverable I/O error occurred on file. The remote server returned an error: (404) Not Found
Error 3271 during backup to URL has many causes. After the 403 and 400 versions, here is what causes the (404) Not Found error and how to fix it.