Background Let us upgrade our Microsoft SQL Server v2017 running on Linux. We will be upgrading it to v2019/RC1. Outline Repositories Current Repository List Current Repository files Map Repository Files to Repositories Update Repository Add Repository File for MS SQL Server v2019 Upgrade SQL Server Upgrade SQL Server - Engine Restart SQL Server Service Validate … Continue reading SQL Server – Upgrade – v2017 to v2019/CTP – Linux
Installation ( SQL Server )
SQL Server – v 2019 – CTP ( CTP 3.2 )
Background Returned to playing around with SQL Server 2019 Community Technology Preview ( CTP ) this week. Issues Ran into issues such as :- Client SQL Server Management Studio ( SSMS ) Engine SQL Server Engine Error :- Msg 155, Level 15, State 1, Line 61 .... is not a recognized... option Client SSMS … Continue reading SQL Server – v 2019 – CTP ( CTP 3.2 )
SQL Server – Installation – v2019
Background Needing to install MS SQL Server v2019 so that I can start evaluating it. Artifacts Please go here to download SQL Server 2019 :- Community Technology Preview ( CTP ) SQL Server 2019 - CTP SQL Server 2019 CTP CTP Installation Outline Install Steps Product Key Choices are Specify a Free Edition Enter … Continue reading SQL Server – Installation – v2019
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 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”
