• Home
  • Modeling for BI
  • DBA
  • Azure
  • SSIS
  • SSAS
  • SSRS - Reporting
  • PBI - Analytics
  • Consulting
  • About
Microsoft Data & AI

Database administration

Installing SQL Server 2016 CTP2.0

6/10/2015

1 Comment

 
I will be writing more about SQL Server 2016, so this post is just cover step #1: installation. After downloading from Microsoft (http://www.microsoft.com/en-us/server-cloud/products/sql-server-2016/default.aspx), installation was typical.  I only ran into one anomaly, the Oracle JRE.

1.       If you choose to install Polybase Query Service for External Data…

Picture
 … MS will be looking for the Java SE Runtime Environment v7 or higher.  You can download it from here --> http://www.oracle.com/technetwork/java/javase/downloads/jre8-downloads-2133155.html.  Without the Oracle JRE installed, you will receive this failure message:
Picture
2.       Take the defaults with these exceptions
            a.)  Specify a named instance
            b.)  Be sure to add yourself as a SQL Server Admin.  I also always add a local system account that I have created specifically for SQL Server.
            c.)  Explicitly choose your data directories
            d.)  If you are installing on a local PC, you may wish to decrease the number of Temp DB files.

Picture
  3.       Be prepared to restart your computer. 
Picture
4.       Install a 2nd and 3rd instance for Tabular and PowerPivot SSAS instances.  (You do not need additional database engines, DQS and SSRS for your additional SSAS instances -- you only want SSAS.) 

Note: PolyBase Query Service for External Data can only be installed on one SQL Server instance.

Picture
5.       When complete, open your new SQL Server 2016 CTP2.0 Configuration Manager.
Picture
            Your SQL 2016 installed instances should look something like this:
Picture
That's it!  Stay tuned for more to come of SQL Server 2016 new features.
1 Comment

    Categories

    All
    Columnstore
    Connecting
    Date & Time
    DBA
    Extended Events
    Indexing
    Installation
    Oracle
    Performance
    SQL 2016
    SQL Developer
    SSAS
    SSIS
    SSRS
    T-SQL

    RSS Feed

    Tweets by @SqlServerSME
Powered by Create your own unique website with customizable templates.
  • Home
  • Modeling for BI
  • DBA
  • Azure
  • SSIS
  • SSAS
  • SSRS - Reporting
  • PBI - Analytics
  • Consulting
  • About