A Jr. DBA’s SQL Server service would not start: Error 14001, the application’s side-by-side configuration is not correct. Here is how we found the cause.
SQL SERVER – Unable to Connect to SQL Server in Azure Virtual Machine from SSMS on On-Premise Machine
Can’t connect from SSMS on your own machine to SQL Server in an Azure Virtual Machine? Here is the network-related error users see and what to check to fix it.
SQL SERVER – Linked Server Error: TCP Provider: No Connection Could be Made Because the Target Machine Actively Refused It
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.
SQL SERVER – Always On Availability Group Error 35250: The Connection to the Primary Replica is Not Active
Joining a database to an availability group can fail with Availability Group Error 35250. Here is why it shows up in the wizard and how I fix it.
SQL SERVER – RDP Error to Azure Virtual Machines – The remote computer that you are trying to connect to requires Network Level Authentication (NLA)
After restarting my Azure VMs, one would not connect, with an RDP Error about Network Level Authentication (NLA). Here is what causes it and how I fixed it.
SQL SERVER – TCP Provider – An Operation On a Socket Could Not be Performed Because the System Lacked Sufficient Buffer Space or Because a Queue was Full
Sometimes, I am contacted by blog readers via email and trust me, I get to learn something new. One of my blog reader contacted me for below error about buffer space.