SQL Server :- Error – “Cannot open database version [version #]. Upgrade the database to the latest version.”

Background Upgrading our SQL Server Instances and noticed that our database backup job is failing. Error Message The error message read :- Cannot open database '' version [nnn]. Upgrade the database to the latest version. TroubleShooting When we upgrade our SQL Server Instance, each individual database is upgraded to the new version. Read-Only databases are skipped.  … Continue reading SQL Server :- Error – “Cannot open database version [version #]. Upgrade the database to the latest version.”

SQL Server – Installation/Upgrade – Extract package files

Background Here I am struggling to install Microsoft SQL Server. It just will not install. And, stubborness is not bailing me out. Take a look at the files Googled till I bled. One of things I was asked to do was to take a look at the installation package. Artifacts RTM For the RTM, which … Continue reading SQL Server – Installation/Upgrade – Extract package files

SQL Server – v2019 – OS Requirements

Background We are 3 months into 2019, and it is way past time to start evaluating SQL Server v2019. Product Development Cycle In terms of community participation, the product engagement cycle is :- Community Technology Preview ( CTP ) Release Candidate Release To Manufacturing Cumulative Updates Within each of this cycle, there will be tiered … Continue reading SQL Server – v2019 – OS Requirements

SQL Server – Installation on Linux/CentOS

Background Let us install SQL Server v2017 on our CentOS System. Installation Outline Repositories Review registered Repositories Add missing Repositories MS SQL Server Engine Install Configure Services Service Review Adjust Network Firewall Rules Validate Repositories Review Registered Repositories yum repolist Syntax Output Explanation We do not see the repositories that we need :- Repositories packages-microsoft-com-mssql-server-2017 … Continue reading SQL Server – Installation on Linux/CentOS

SQL Server – v2017 – Install – “Oracle JRE 7 Update 51 (64-bit) is required for Polybase”

Background Installing SQL Server v2017 and ran into an error that I have seen before. Error Error Image Error Textual Oracle JRE 7 Update 51 (64-bit) or higher is required for Polybase Tackled Before History Already tackled before here: SQL Server (v2016) – Installation – Blocked – "Oracle JRE 7 Update 51 (64-bit) or higher … Continue reading SQL Server – v2017 – Install – “Oracle JRE 7 Update 51 (64-bit) is required for Polybase”

SQL Server / Minimum OS Software Requirement

Background Wanted to tabulate the minimum MS Windows OS Requirement for the various versions of MS SQL Server.   Minimum OS Support Matrix SQL Server Version OS Version - Server OS Version - Desktop Bitness Link v2017  Windows Server 2012  Windows 8 Minimum: x64 Processor: 1.4 GHz Recommended: 2.0 GHz or fasterDoes not support 32 … Continue reading SQL Server / Minimum OS Software Requirement