Troubleshooting general SQL connectivity issues
There are quite a few things that an administrator may need to check when it comes to making sure connectivity to SQL is happy and healthy in your respective environments.…
Tag: MSDTC
See what user you are connecting to linked SQL server
I wanted to share with you guys a really handy little SQL query that is extremely useful if you are troubleshooting SQL Server linked server connectivity. You may have setup…
OLE DB provider SQLNCLI11 for linked server unable to begin distributed transaction
Today in working with a new virtual machine that was spun up with Windows Server 2012 R2 and SQL Server 2014, I was asked to troubleshoot an issue where distributed…