sql server 2014
-
SQL
SQL Server 2016 Upgrade Error Valid Database compatibility level
In updating a few SQL Server 2014 servers recently, I ran into an error with a new SQL Server 2014 Server running the upgrade to SQL Server 2016. ย It was a SQL Server 2016 upgrade error valid database compatibility level.…
-
SQL
How to Upgrade SQL Server 2014 to SQL Server 2016
With SQL Server 2016 currently at SP1 as well as a CU1 under its belt, many may be thinking of upgrading existing SQL Server 2014 installations to SQL Server 2016. ย The upgrade process is painless as you will see below.…
-
SQL
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 transactions were not working from this particular VM and other…