Windows Authentication or the SA account? A client asked me in a Health Check, and here is why my advice is Windows Authentication wherever you can.
SQL SERVER – Cannot Drop the Assembly ‘ISSERVER’, Because it Does not Exist or You do not Have Permission
An upgrade could not start SQL Server: Cannot drop the assembly ‘ISSERVER’, because it does not exist or you do not have permission. Here is another way to fix it.
SQL SERVER – SQL Clustered Resource in Online Pending State for Long Time Before Coming Online
Why does a SQL clustered resource sit in Online Pending state for a long time before coming online? A client asked me this, and here is how I found the cause.
SQL SERVER – Fix: 400 – Bad Request Authentication Failed for Account and the Provided Key. Please Provide a Valid Key and Try Again
Connecting SSMS to Azure storage failed with 400 Bad Request: authentication failed for account and the provided key. Here is the cause and the fix.
SQL SERVER – FIX: Cannot Connect to SQL in Azure Virtual Machine From Laptop
SSMS on my laptop could not connect to SQL in Azure Virtual Machine, even though it worked fine on the VM itself. Here is how I fixed the connection.
SQL SERVER – FIX: Msg 15190 – There are still remote logins or linked logins for the server
Dropping a linked server with sp_dropserver failed with Msg 15190: There are still remote logins or linked logins for the server. Here is how to clear them.
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.