Aruba Intelligent Management Center SQL Server 2014 Installation guide

HPE Intelligent Management Center

SQL Server 2014

Installation and Configuration Guide

Abstract

This document describes configuration during and after database installation when IMC is used with Microsoft SQL Server.

This document is applicable to the SQL Server 2014 Evaluation edition and can be slightly different from other editions of

SQL Server 2014. This document is intended for use by network engineers or system administrators responsible for

installing network software and components.

Part number: 5200-6829

Software version: IMC PLAT 7.3 (E0705)

Document version: 1

The information contained herein is subject to change without notice. The only warranties for Hewlett Packard

Enterprise products and services are set forth in the express warranty statements accompanying such

products and services. Nothing herein should be construed as constituting an additional warranty. Hewlett

Packard Enterprise shall not be liable for technical or editorial errors or omissions contained herein.

Confidential computer software. Valid license from Hewlett Packard Enterprise required for possession, use, or

copying. Consistent with FAR 12.211 and 12.212, Commercial Computer Software, Computer Software

Documentation, and Technical Data for Commercial Items are licensed to the U.S. Government under vendor’s

standard commercial license.

Links to third-party websites take you outside the Hewlett Packard Enterprise website. Hewlett Packard

Enterprise has no control over and is not responsible for information outside the Hewlett Packard Enterprise

website.

Acknowledgments

Intel®, Itanium®, Pentium®, Intel Inside®, and the Intel Inside logo are trademarks of Intel Corporation in the

United States and other countries.

Microsoft® and Windows® are trademarks of the Microsoft group of companies.

Adobe® and Acrobat® are trademarks of Adobe Systems Incorporated.

Java and Oracle are registered trademarks of Oracle and/or its affiliates.

UNIX® is a registered trademark of The Open Group.

i

Contents

SQL Server 2014 in IMC ······································································1

Preparing for installation ······································································2

Installing SQL Server 2014 ··································································5

Registering the SQL Server license ····················································· 24

Installing the SQL Server client ··························································· 26

Installation procedure·················································································································· 26

Testing connectivity ···················································································································· 31

Configuring SQL Server 2014 ····························································· 33

Configuring TCP/IP properties ······································································································ 33

Modifying the maximum server memory for the SQL Server ······························································· 35

Starting the SQL Server Browser service ························································································ 38

Changing the SQL Server service startup account ············································································ 40

Restarting the SQL Server service ································································································ 41

Creating a superuser ·················································································································· 42

Uninstalling SQL Server 2014 ····························································· 47

FAQ ······························································································· 48

About HPE IMC documents ································································ 58

Document conventions ······································································ 59

Support and other resources ······························································ 60

Accessing Hewlett Packard Enterprise Support ··············································································· 60

Accessing updates ····················································································································· 60

Websites ··························································································································· 61

Customer self repair············································································································· 61

Remote support ·················································································································· 61

Documentation feedback ······································································································ 61

1

SQL Server 2014 in IMC

Before installing IMC, install the SQL Server on a database server used for storing IMC data, or

install it on the server on which you plan to install IMC.

This document provides installation and configuration procedures for Microsoft SQL Server 2014.

For more information about using the database for IMC, see the HPE IMC deployment guides.

If you plan to install the database on a separate database server, follow these guidelines:

 Before installing IMC, install a SQL Server client on the same server as IMC. The client version

must match the version of the SQL Server the database.

 Before installing IMC, create a data file folder for storing IMC data on the database server. You

must specify the local path to the folder during the deployment of IMC components, as shown in

Figure 1.

Figure 1 Database Configuration dialog box during IMC installation

NOTE:

Use Microsoft SQL Server licensed installation software. Localized software or other unauthorized

editions might cause a failure in database installation and operation.

2

Preparing for installation

Before installing SQL Server 2014 and the SQL Server client, turn off the Windows firewall on the

SQL Server host to open TCP port 1443.

To turn off the Windows firewall:

1. Select Start > Control Panel > System and Security > Windows Firewall.

The Windows Firewall page opens, as shown in Figure 2.

Figure 2 Windows Firewall page

2. Select Turn Windows Firewall on or off.

The Customize Settings page opens, as shown in Figure 3.

3

Figure 3 Customize Settings page

3. Select Turn off Windows Firewall (not recommended) for both Private network settings

and Public network settings, and then click OK.

The Windows Firewall page displays the firewall status.

4

Figure 4 Disabling Windows firewall

5

Installing SQL Server 2014

1. Run the installation program.

The SQL Server Installation Center wizard opens, as shown in Figure 5.

Figure 5 SQL Server Installation Center wizard

2. Select Installation in the navigation tree, and then select New SQL Server stand-alone

installation or add features to an existing installation.

The Product Key page opens, as shown in Figure 6.

6

Figure 6 Product Key page

3. Enter the product key and then click Next.

The License Terms page opens, as shown in Figure 7.

7

Figure 7 License Terms page

4. Select I accept the license terms and click Next.

The Global Rules page opens, as shown in Figure 8.

8

Figure 8 Global Rules page

When the check has been passed, the Microsoft Update page opens, as shown in Figure 9.

Figure 9 Microsoft Update page

9

5. Click Next.

The Product Updates page opens.

6. Click Next if no update is required.

The Install Setup Files page opens, as shown in Figure 10.

Figure 10 Install Setup Files page

When system preparations are complete, the Install Rules page opens, as shown in Figure 11.

10

Figure 11 Install Rules page

When the rules check is complete, the Setup Role page opens, as shown in Figure 12.

Figure 12 Setup Role page

11

7. Select SQL Server Feature Installation and click Next.

The Feature Selection page opens, as shown in Figure 13.

Figure 13 Feature Selection page

8. Select the features to install, and then specify directories in the Instance root directory,

Shared feature directory, and Shared feature directory (x86) fields.

The default directory settings are C:\Program Files\Microsoft SQL Server, C:\Program

Files\Microsoft SQL Server, and C:\Program Files(x86)\Microsoft SQL Server. Only the

drive letter can be modified. You can specify another drive with sufficient space for the

directories. This example uses disk drive D.

9. Click Next.

The Feature Rules page opens, as shown in Figure 14.

12

Figure 14 Feature Rules page

When the feature rules check is complete, the Instance Configuration page opens, as shown

in Figure 15.

13

Figure 15 Instance Configuration page

10. Install a default instance or a named instance of the SQL Server.

 To install the default instance, select Default instance and specify an instance ID. The

default instance ID is MSSQLSERVER.

 To install a name instance, select Named Instance and specify an instance ID. You are

required to provide the instance name during IMC installation.

In this example, select Default instance and use the default instance ID MSSQLSERVER.

11. Click Next.

The Server Configuration page opens, as shown in Figure 16.

14

Figure 16 Server Configuration page

12. Use the default settings on the Service Accounts tab.

If you selected Named instance for the SQL Server in Figure 15, set Startup Type for the SQL

Server Browser service to Automatic.

13. Click the Collation tab, as shown in Figure 17.

15

Figure 17 Collation tab

14. Use the default collation settings or modify the settings to meet specific language requirements,

and then click Next.

The Database Engine Configuration page opens, as shown in Figure 18.

16

Figure 18 Database Engine Configuration page

15. Under Authentication Mode, select Mixed Mode, enter the password for user sa, and add a

SQL Server administrator, as shown in Figure 19.

 SQL Server 2014 has password complexity requirements. For more information, see the

SQL Server 2014 online help.

 For IMC to identify the sa logon password during installation, make sure the password

does not contain any of the following characters:

 Left angle bracket (<)

 Right angle bracket (>)

 Vertical bar (|)

 Tab (\t)

 If the password of user sa must contain any of the previous characters, create a superuser

with sa user privileges before the IMC installation. Make sure the password of the

superuser does not contain any of the previous characters. For information about creating

a database superuser, see "Creating a superuser."

17

Figure 19 Specifying SQL Server administrators

16. Use the default settings on the Data Directories tab, as shown in Figure 20.

Page is loading ...

Aruba Intelligent Management Center SQL Server 2014 Installation guide

This manual is also suitable for

Aruba Intelligent Management Center SQL Server 2014 Installation guide

Related papers

Other documents