SQL
-
Install SQL Server 2017 on Ubuntu Server
Microsoft has certainly been headed in a very cool direction in the past couple of years and have definitely embraced the Linux community and interoperability between Microsoft Windows and Linux. When we look at the strides that have been made…
-
Upgrade SQL Server 2016 to 2017
Recently, SQL Server 2017 was released as GA to the masses. This represents the latest and greatest SQL server technology available to consume. There are some really great new features that are contained in SQL Server 2017 to be aware…
-
Three lesser known ways to test SQL connectivity
In troubleshooting a SQL connectivity issue recently, I tried multiple tests in connecting to SQL to help troubleshoot the issue. In this post, let’s take a look at three lesser known ways to test SQL connectivity including ODBC, a UDL…
-
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.…
-
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 Cluster computer account could not be configured
In working on an older Microsoft SQL Cluster server configuration recently, I ran into an issue with a lab copy of the SQL Cluster not bringing the SQL resources online as expected. After rejoining the domain and sychronizing everything with…
-
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. As of late, I have put together a checklist of…
-
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 a local server login to remote server login mapping which…
-
SQL 2014 Setup Failed Analysis Services
Recently in building up a SQL 2014 Standard edition VM running on Windows Server 2012 R2, I ran into a peculiar issue with the SQL install with Analysis Services relating to permissions. The SQL installation went all the way through…
-
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…
- 1
- 2