With SQL Server on a UNC share, the Configure Distribution wizard refuses network paths for the distribution database. Here is how to create it anyway.
What are Ports Needed to Configure Log Shipping? – Interview Question of the Week #169
What are ports needed to configure log shipping? A client in a locked-down network asked me, and here is the list of ports to open on the firewall.
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.
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 – 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.