2. Computers & electronics
  3. Software
  4. Computer utilities
  5. Database software
  6. Aruba
  7. Intelligent Management Center SQL Server 2014
Intelligent Management Center SQL Server 2014

Aruba Intelligent Management Center SQL Server 2014, JG546AAE, JG747AAE, JG748AAE Installation guide

  • Hello! I am an AI chatbot trained to assist you with the Aruba Intelligent Management Center SQL Server 2014 Installation guide. I’ve already reviewed the document and can help you find the information you need or explain it in simple terms. Just ask your questions, and providing more details will help me assist you more effectively!
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.
/