Creating a linked server failed its connection test: No connection could be made because the target machine actively refused it. Here is what to check.
SQL SERVER – The SaveToSQLServer Method Has Encountered OLE DB Error Code 0x80004005
While saving maintenance plan on my lab server, I encountered below error in SQL Server Management Studio. Let us see how to solve the error related to OLE DB Error.
Restoring a Database That Has a Memory-Optimized Filegroup
The container behind a memory-optimized filegroup is a folder, and a restore must place it. Here is the error you get when you forget, and the fix.
SQL SERVER – Error: 17300 – SQL Server Was Unable to Run a New System Task
They noticed that application jobs are failing with the below error message about running a new system task. Let us learn more about this.
SQL SERVER – Msg 32055 – sp_refresh_log_shipping_monitor – There Was an Error Configuring the Remote Monitor Server
Msg 32055, error configuring the remote monitor server, hides the real error. Read from the procedure on SQL Server 2025, with a safer fix than sa.
Moving From Express to Standard Without Reinstalling
Plan how to upgrade SQL Server edition from Express to Standard, preserve the instance, and verify databases and applications after setup.
SQL SERVER – Fix: Error – VS Shell Installation Has Failed with Exit Code 1638
A customer’s SQL Server 2017 install kept failing with “VS Shell installation has failed with exit code 1638”. Here is what caused it and how we fixed it.