Aruba JG748AAE Installation guide

Category
Database software
Type
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
© Copyright 2015, 2019 Hewlett Packard Enterprise Development LP
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 1 1
  • Page 2 2
  • Page 3 3
  • Page 4 4
  • Page 5 5
  • Page 6 6
  • Page 7 7
  • Page 8 8
  • Page 9 9
  • Page 10 10
  • Page 11 11
  • Page 12 12
  • Page 13 13
  • Page 14 14
  • Page 15 15
  • Page 16 16
  • Page 17 17
  • Page 18 18
  • Page 19 19
  • Page 20 20
  • Page 21 21
  • Page 22 22
  • Page 23 23
  • Page 24 24
  • Page 25 25
  • Page 26 26
  • Page 27 27
  • Page 28 28
  • Page 29 29
  • Page 30 30
  • Page 31 31
  • Page 32 32
  • Page 33 33
  • Page 34 34
  • Page 35 35
  • Page 36 36
  • Page 37 37
  • Page 38 38
  • Page 39 39
  • Page 40 40
  • Page 41 41
  • Page 42 42
  • Page 43 43
  • Page 44 44
  • Page 45 45
  • Page 46 46
  • Page 47 47
  • Page 48 48
  • Page 49 49
  • Page 50 50
  • Page 51 51
  • Page 52 52
  • Page 53 53
  • Page 54 54
  • Page 55 55
  • Page 56 56
  • Page 57 57
  • Page 58 58
  • Page 59 59
  • Page 60 60
  • Page 61 61
  • Page 62 62
  • Page 63 63
  • Page 64 64
  • Page 65 65

Aruba JG748AAE Installation guide

Category
Database software
Type
Installation guide

Ask a question and I''ll find the answer in the document

Finding information in a document is now easier with AI