Setting up an Always On listener with an Azure Load Balancer, I hit: Parameter ‘ProbePort’ does not exist on the cluster object. Here is what fixed it for me.
SQL SERVER – xp_create_subdir() Returned Error 183, ‘Cannot Create a File When that File Already Exists
A client’s maintenance plan kept failing with: xp_create_subdir() returned error 183, Cannot create a file when that file already exists. Here is the fix.
SQL SERVER – FIX: Msg 15281 – SQL Server Blocked Access to STATEMENT ‘OpenRowset/OpenDatasource’ of Component ‘Ad Hoc Distributed Queries’
Reading Excel, a reader got Msg 15281: SQL Server blocked access to STATEMENT ‘OpenRowset/OpenDatasource’. Enabling Ad Hoc Distributed Queries fixes it.
SQL SERVER – Installation Stuck at Offline Installation of Microsoft Machine Learning Server Components
My SQL Server 2017 install got stuck at Offline Installation of Microsoft Machine Learning Server Components. Here is why it happens and how to move forward.
SQL SERVER – SETUP Error: The Syntax of Argument “/ACTION” is Incorrect
Uninstalling SQL Server from the command line, I got: The syntax of argument “/ACTION” is incorrect. Here is what the error means and how to fix the command.
SQL SERVER – Unable to Uninstall – Index was Outside the Bounds of the Array
My machine crashed mid-install, and uninstalling SQL Server 2017 then failed with: Index was outside the bounds of the array. This is how I cleaned it up.
SQL SERVER – The OLE DB Provider “Microsoft.ACE.OLEDB.12.0” for Linked Server “(null)” Reported an Error. Access Denied
OPENROWSET on an Excel file gave: The OLE DB provider “Microsoft.ACE.OLEDB.12.0” for linked server “(null)” reported an error. Access denied. Here is the fix.