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.”
Installation ( SQL Server )
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 Error – “The RPC server is unavailable”
Background Trying to install Microsoft SQL Server v2017, but no go. Error Message Here is the error message :- TITLE: Microsoft SQL Server 2017 Setup. The following error has occurred: The RPC server is unavailable. Click 'Retry' to retry the failed action, or click 'Cancel' to cancel this action and continue setup. Error Image … Continue reading SQL Server Installation Error – “The RPC server is unavailable”
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
