dataself corp. ms sql server 2014 installation guide ms ... · dataself corp. ms sql server 2014...

DataSelf Corp. MS SQL Server 2014 Installation Guide

DsBi_MsSqlServer2014Std_Installation605.doc www.dataself.com of 7

MS SQL Server 2014 Installation – rev605

This document provides the steps required to install MS SQL Server 2014 Standard Edition on a Windows Server 2012 for use with DataSelf Business Intelligence solutions.

MS SQL Server editions supported: Enterprise, Developer, Business Intelligence and Standard.

Minimum system requirements: at least 2 CPU cores, 4GB of RAM, 50GB of free disk space, Windows Server 2008 R2 with the latest service packs.

You should budget 30 to 60 minutes to perform this installation – assuming you have all installation files ready to go (DVD on hand or downloaded files on your local HD/network).

ATTENTION: Please be sure to log on to Windows with an administration user and run all applications described here with Right-click > Run as Administrator.

Summarized Instructions for MS SQL Experts (Please see next pages for detailed installation instructions)

Run the installation wizard and accept all default options except for the following steps:

Feature Selection - Choose:

Database Engine Services (no need for subcomponents)

Analysis services

Business Intelligence Dev Studio

Client tools connectivity

Integration services

Client tools backwards compatibility

Management tools – basic

Management tools – Complete

Instance Configuration – instance name: Set it to Default instance or name it (ex.: “DSBI”).

Server Configuration – Account Name: Use a domain user with local admin rights and click “Use the same account for all SQL Server services”.

Server Configuration – Startup type: set to automatic for all except Integration Services.

Database Engine Configuration: Set Authentication Mode to Mixed Mode and Add Current User.

Analysis Services Configuration: Add Current User.

Apply latest Windows updates and MS SQL Server service packs.

Download and install Business Intelligence for Visual Studio 2013.



Detailed Instructions

Installing MS SQL Server 2014

1. Run the installation application:

From a SQL Server DVD: Run setup.exe.

From files downloaded from DataSelf’s website:

Run the downloaded file to extract the SQL Server installation files. If an extract password is required: check your DataSelf download links documentation.

Run setup.exe from a folder similar to the one shown above.

2. SQL Server Installation Center: Click Installation (step 1) on the left pane, and then click New SQL Server stand-alone or add features to an existing installation… (step 2)

3. Setup Support rules: If all rules pass, click on OK. If not, investigate the details.



4. Product Key:

For DataSelf BI MS SQL licenses: The Product key will be already filled in.

For regular MS SQL Licenses: Type license key in (step 1) and click Next (step 2).

5. License Terms: Read license terms. If acceptable, check I accept the license terms (step 1) and click Next (step 2).

6. Product Updates: Click Next and wait until support files are installed.

7. Setup Support Rules: If all rules pass, click Next. Windows Firewall warnings may have to be addressed later on if/when users need remote access to SQL Server.



8. Setup Role: Select SQL Server Feature Installation (step 1) and click Next (step 2).

9. Feature Selection (step 1):

Select the following features:

Database Engine Services

Analysis services

Client tools connectivity

Client tools backwards compatibility

Management tools – basic Management tools – Complete

Check if the Shared feature directories (step 2) are set to hard drives with plenty of free space.

Click Next (step 3).

10. If the installer requires .NET 3.5 with SP1, open Server Manager, Add Roles and

Features, and add .NET Framework 3.5.

11. Instance Configuration:

Select Default instance (or choose Named instance and name it – step 1).

Check if the Instance root directory (step 2) is set to a hard drive with plenty of free space.

Click Next.



12. Sever Configuration

Set Startup Type (step 1) as shown below:

SQL Server Agent: Automatic

SQL Server Database Engine: Automatic

SQL Server Analysis Services: Automatic

SQL Server Integration Services: Manual

SQL Server Browser: Automatic

Set Account Name and Password with admin username and password with reading rights to the source database(s).

13. Database Engine Configuration:

Set Authentication Mode to Mixed Mode (SQL Server and Windows authentication – step 1)

Create and document a secured password for the Built-in SQL Server system admin account (step 2).

Click Add Current User (step 3). Select the Data Directories tab (step 4).

14. Database Engine Configuration – Data

Directories tab: Double check if all directories are set to paths to hard drives with plenty of free space. Click Next.

15. Analysis Services Configuration: Click Add Current User and select the Data Directories tab.



16. Analysis Services Configuration – Data Directories tab: Double check if all directories are set to the paths to hard drives with plenty of free space. Click Next (step 2).

17. Ready to Install: Click Install. The installation takes several minutes (10 to 30 minutes).

18. Complete: Click Close.

19. Apply important Windows Updates (click on Start > All programs > Windows Update).

20. Reboot the server, log on and then open MS SQL tools and verify that all services are running. 21. Optional: Granting access to remote users: You may have to configure Windows Firewall settings to

allow remote access to MS SQL Server and MS Analysis Services. For details, please visit http://msdn.microsoft.com/en-us/library/cc646023.aspx. Tip: here are common ports used by SQL services:

For the default instance or the only named instance on a server: TCP port 1433, TCP port 2383.

b. For named instances: UDP port 1434, TCP port 2382

http://msdn.microsoft.com/en-us/library/cc646023.aspx



Business Intelligence for Visual Studio 2013

22. For installations that require SQL Analysis Services management, please download the installer from

https://www.microsoft.com/en-us/download/details.aspx?id=42313 and follow the next steps.

23. Click I Agree and Next.

24. Select Perform a new installation of SQL 2012

and click Next.

25. Select SQL Server Data Tools – Business Intelligence

and click Next and wait until it completes.

26. Click Close.

Please contact [email protected] if you need further assistance.

https://www.microsoft.com/en-us/download/details.aspx?id=42313

mailto:[email protected]

dataself corp. ms sql server 2014 installation guide ms ... · dataself corp. ms sql server 2014...

Documents