dcsimg
Database Journal
MS SQL Oracle DB2 Access MySQL PostgreSQL Sybase PHP SQL Etc SQL Scripts & Samples Tips Database Forum

» Database Journal Home
» Database Articles
» Database Tutorials
MS SQL
Oracle
DB2
MS Access
MySQL
» RESOURCES
SQL Scripts & Samples
Tips
» Database Forum
» Slideshows
Free Newsletters:



News Via RSS Feed


Database Journal |DBA Support |SQLCourse |SQLCourse2
 

Featured Database Articles

MS SQL

Posted October 8, 2018

Installing SQL Server 2019 CTP 2.0 - Page 5

By Greg Larsen

In order to manange and test out my new SQL Server 2019 CTP 2.0 instance I will also need to install SQL Server Management Studio (SSMS).  I decided I’m going to install the latest and greatest version of SSMS on my machine.  To get the latest version of SSMS I use the “Install SQL Server Management Tools” link on the “SQL Server Installation Center” dialog as shown below:

Install SQL Server Management Tools
Install SQL Server Management Tools

When I click on this link the follwong webpage is displayed: https://docs.microsoft.com/en-us/sql/ssms/download-sql-server-management-studio-ssms?view=sql-server-2017.

Download SQL Server Management Studio
Download SQL Server Management Studio

As you can see the link only brought up a Books Online documenation page.  If you look closesly at this page you can see there is a link to download the preview 4 version for “SQL Server Managmenet Studio 18.0. https://go.microsoft.com/fwlink/?linkid=2014662).  I will be using this preview version of SSMS for my SQL Server 2019 CTP 2.0 testing.   By using this link I download the SSMS setup exe (SSMS-Setup-ENU.exe) and saved it to my VM machine.   When I execute this SSMS exe the following dialog is displayed:  

SQL Server Managmenet Studio 18.0
SQL Server Managmenet Studio 18.0

To start the install of SSMS 18.0 I click on the “Install” button.  When I do this, I am shown the following progress dialog while the installation process of SSMS is running:

Microsoft SQL Server Management Studio Progress Bar
Microsoft SQL Server Management Studio Progress Bar

Once the install is complete the following screen is displayed:

Microsoft SQL Server Management Studio Restart
Microsoft SQL Server Management Studio Restart

As you can see a restart of my computer is required.  I click on the “Restart” button to complete the installation of version 18.0 of SSMS.

Step 3: Verify Installation

At this point I have installed SQL Server 2019 CTP 2.0 and SQL Server Management Studio (SSMS).  I start my verification process by using SSMS.  When SSMS first starts I see the following screen:

SQL Server Management Studio
SQL Server Management Studio

This window is displayed for a few seconds, but then eventually SSMS starts and the following window is displayed:

 SQL 2019_CTP2 [Running]
SQL 2019_CTP2 [Running]

I connect to the default instance by placing a period (“.”) in the “Server name” item and the click on the “Connect” button.  After SSMS connects this is what I see in the “Object Explorer” window:

Object Explorer Window
Object Explorer Window

As you can see I’m running SQL Server build version 15.0.1000.34, which is the build number for SQL Server 2019 CTP 2.0.

If I expand the Database item in Object Explorer I see the following:

Expand the Database
Expand the Database

As you can see I have the normal System Databases (master model, msdb, and tempdb), but I also have the three DW… databases (DWConfiguration, DWDiagnostics, DWQueue).  If you have not seen these databases before they are databases used to support PolyBase.

For my next test I issue the following query against my new SQL Server 2019 CTP 2.0 database:

SELECT  
  SERVERPROPERTY('Edition') AS Edition,
  SERVERPROPERTY('ProductVersion') AS ProductVersion,  
  SERVERPROPERTY('ProductLevel') AS ProductLevel;  
GO  

When I run this code the following is returned:

Query Results
Query Results

Here I can tell I’m running the “Enterprise Evaluation Edition (64-bit)” version of SQL server 2019 CTP2.0.

Are you ready to install SQL Server 2019 CTP 2.0?

You can see it is very easy to install SQL Server 2019 and all the features by just clicking through the different dialog boxes of the installation process. The only real gotcha I ran across was forgetting to install the Oracle JRE prior to installing Polybase.   I think all DBAs should start exploring SQL Server 2019 as a step to get them ready for SQL Server 2019.   I encourage all of you to consider testing out CTP 2.0 of SQL Server 2019.  Are you ready to install SQL server 2019 CTP 2.0 in your environment?

See all articles by Greg Larsen



MS SQL Archives

Comment and Contribute

 


(Maximum characters: 1200). You have characters left.

 

 




Latest Forum Threads
MS SQL Forum
Topic By Replies Updated
SQL 2005: SSIS: Error using SQL Server credentials poverty 3 August 17th, 07:43 AM
Need help changing table contents nkawtg 1 August 17th, 03:02 AM
SQL Server Memory confifuration bhosalenarayan 2 August 14th, 05:33 AM
SQL Server Primary Key and a Unique Key katty.jonh 2 July 25th, 10:36 AM