How To Create New Instance In Sql Server 2016

How-to: Installing SQL Server 2016 Standard Edition

Introduction

This document describes the installation of SQL Server 2016 Standard Edition. The installation procedure for the Enterprise Edition is similar, but some screens may differ.

Before installing, you should have, at the very least Exact Globe Next product update 409 and Exact Synergy Enterprise product update 254 to work with SQL Server 2016.

In these following steps, it is assumed that you are installing the SQL Server as a new installation or as a new instance:

For a new installation, there is no MS SQL Server software present in your system. After the installation, you will have one MS SQL Server.
When installing a new instance, install MS SQL Server next to your current MS SQL Server version. After the installation, you will have multiple MS SQL Servers; the one you have just installed, and the existing one(s) present in your system.

Keep in mind: It is not possible to install SQL Server 2016 as a second instance next to SQL Server 2005.

The steps for installing a new instance are almost the same as the steps for installing the SQL Server in a system where no other versions of SQL Server are present. Where applicable, the difference(s) will be highlighted in this document.

Installing SQL Server 2016

The next step is installing SQL Server 2016. In a standalone environment, you have to perform these steps on the workstation where you work with Exact Globe Next. In all other cases, you have to perform these steps on the server.

When working in a standalone environment, you will have one computer on which you are working with Exact Globe Next. On this computer, both Exact Globe Next and the SQL Server are installed. This is seen as a standalone even when your computer is part of a network, as all software needed to work with Exact Globe Next are installed on this one computer.

Before installing the SQL Server, check the system requirements for the specific SQL Server edition at https://msdn.microsoft.com/en-us/library/ms143506(v=sql.130).aspx.

When these requirements are met, you can start installing SQL Server 2016.

To install SQL Server 2016:

Log in as an administrator on the server (of a workstation in case of a standalone installation).
Insert the SQL Server installation DVD into your DVD drive. When the autorun is not performed, open the DVD drive in Windows Explorer and start the installation by clicking Setup.exe.
The SQL Server Installation Center screen will be displayed. In this screen, you can view and execute several installation tasks.
Click Installation on the left panel. Next, click New SQL Server Stand-alone installation or add features to an existing installation.
In the Product Key screen, type the product key at Enter the product key if the product key is not filled automatically. Click Next to continue. The screen with the license terms will be displayed.
To continue, select I accept the license terms and click Next.
Checks will be performed to identify possible problems when installing the SQL Server Setup support files. The SQL Server Setup support files are needed for the installation of MS SQL Server 2016 and are automatically installed via this installation wizard. Click Show details >> to view the details of these checks. When all checks are passed, the results are displayed in this screen. When a check has failed, a red icon will be displayed. You can click the link in the Status column for more information about the check and the error. After solving the issue, click Re-run to perform the checks again.
Note: It is possible that some warnings are displayed regarding the firewall. In spite of the warnings, it is still possible to continue with the installation. Depending on the situation, it is not necessary to close the installation wizard and restart. When all checks are passed, this screen will close automatically and the next screen will be displayed.
The Product Updates screen allows you to check for new update files online. However, you can click Skip scan to skip this step. Click Next to continue.
The installation wizard will check for updates and install the available update files. As soon as this is done, the screen will close automatically and the next screen will be displayed:
Checks will be performed to identify potential problems that might occur during the installation. Click Show details >> to view the details of these checks. When a check has failed, a red icon will be displayed. You can click the link in the Status column for more information about the check and the error. After solving the issue, click Re-run to perform the checks again.
Note: Depending on the situation, it is not necessary to close the installation wizard and restart.
Click Next to continue. However, the Next button is available only when no checks have failed.
Select the features to install. When you select a feature, the corresponding information about this feature will be displayed on the right. Select the following features:
- Database Engine Services
- Reporting Services - Native (applicable only when you are using SQL Server Reporting services and/or Exact Globe Next with extended functionality)
- Client Tools Connectivity
- Integration Services
- Documentation Components
- Full-Text and semantic extractions for Search: If you want to use the SQL full text search for searching feeds in the timeline of Exact Synergy Enterprise, this component should be selected. If you have not selected this component during the installation of the SQL Server, you can install it at a later time. For more information, see Defining social collaboration settings.
Besides selecting the features, you do not have to change anything else. Click Next to continue.
Checks will be performed to identify issues that might block the installation. Click Show details >> to view the details of these checks. When a check has failed, a red icon will be displayed. You can click the link in the Status column for more information about the check and the error. After solving the issue, click Re-run to perform the checks again.
Note: Depending on the situation, it is not necessary to close the installation wizard and restart.
Click Next to continue. However, the Next button is available only when no checks have failed.
When the actions in the previous screen are completed, the screen will close automatically and the next screen will be displayed. In the Instance Configuration screen, define a name for the instance. This is the name for your SQL Server. Click Next to continue.

Note:
- New installation — When it is a new installation, there is no SQL Server present in your system yet. In this case, select Default instance. There is no need to change anything else in the screen. At the bottom of the screen, you can see if there are already other SQL Server instances present. When this is a new installation in a system where no SQL Server is present yet, this part of the screen is empty.
- Installingnew instance — When there are existing SQL Server installations present, you have to select Named instance and define a name in the box next to it, for example "SQL2016". The name defined here has to be unique and cannot be the same as the name of the other instances that are already present on your system. The field Instance ID will be filled automatically and you do not have to change this manually. At the bottom of the screen, you can see if any other instances are present.
In this screen, under the Service Accounts tab, you can define which account you want to use for starting the MS SQL Server 2016 services. For a standard installation, accept the data as suggested in the screen. Keep in mind that when you select a user for which the password regularly changes, you will also have to change the password in the services every time. If you forget to change the password in the services, the services cannot be started and you will not be able to use the SQL Server until you have updated the password in the services, and have started the services. Depending on the account selected at Account Name, you have to enter the corresponding password at Password.
In the Startup Type column, you can define that the service has to start automatically when the system starts. The SQL Server Database Engine is the SQL Server itself. This service should always be started in order to use the SQL Server.
The SQL Server Browser service is a service that is used for identifying the ports that the installation of SQL Server listens to. This service needs to be started to enable network access. The Startup Type option of this service should be Automatic. The account name of this service cannot be changed.
Under the Collation tab, you can define the collation (character set) settings. For Western European countries, you can accept the collation as displayed in the screen. Click Next to continue. The following screen will be displayed:
Under the Server Configuration tab, define how you would like to log on to the SQL Server. When you are working with Exact Synergy Enterprise and/or Exact Globe Next with extended functionality, select Mixed Mode (SQL Server authentication and Windows authentication). Type your password at Enter password and Confirm password. This password is a password that will be used for the SA user; this default user is the System Administrator within the SQL Server. If you select Windows authentication mode, you do not have to type a password.
Note: Regardless of which Exact product you use, you will always have to define one user or more at the bottom of the screen. These users will be administrators on the SQL Server. You have to select at least one user. This user will be the administrator on the SQL Server and can also add other users later on.
Click Add Current User to add the users that are currently performing the installation as an administrator. Click Add to add other users or Remove to remove selected users.
Click Next to continue.
Note: The following screen will be displayed only if you have selected the Reporting Services – Native feature.
In this screen, define if you want to configure the reporting services feature now or if you want to configure it later. Select Install only to install the feature and configure it later. Click Next to continue.
In the Feature Configuration Rules screen, checks will be performed for problems that might occur during the installation. Click Show details >> to view the details of these checks. When a check has failed, a red icon will be displayed. You can click the link in the Status column for more information about the check and the error. After solving the issue, click Re-run to perform the checks again.
Note: Depending on the situation, it is not necessary to close the installation wizard and restart.
Click Next to continue. However, this button is available only when no checks have failed.
In the Ready to Install screen, a summary of the defined installation criteria will be displayed. Click Install to start the installation.
The screen displaying the progress of the installation will displayed. The installation might take some time.
As soon as the installation has completed successfully, the installed components are displayed with a green icon. Click Close to close the wizard.
To be able to access the SQL Server via a network, you have to activate some protocols. When working with a network environment, you have to check if the protocols are activated. If required, activate the protocols.
1. Start (on the server where MS SQL Server 2016 is installed) SQL Server Configuration Manager. In Windows, go to Start, select All Programs, followed by Microsoft SQL Server 2016. Click Configuration Tools, and then SQL Server 2016 Configuration Manager.
  In Windows 8, press the Windows key and the Q key on your keyboard. On the right at Search at the Apps field, type "SQL Server Configuration Manager". Next, click SQL Server 2016 Configuration Manager.
2. Click SQL Server Network Configuration.
3. Select Protocols for xxxx. ("xxxx" has to be replaced by the name you have defined for the SQL Server during installation).
4. Right-click the protocols Named Pipes and TCP/IP and click Enable to enable these protocols.
You might also need to start the SQL Server Browser service. This service is used for identifying the ports that the installation of SQL Server listens to. When this service is not started, you can use the SQL Server only locally. To check if this service is started, follow these steps:
1. Start (on the server where MS SQL Server 2016 is installed) SQL Server Configuration Manager. In Windows, go to Start, select All Programs, followed by SQL Server 2016. Click Configuration Tools, and then SQL 2016 Server Configuration Manager.
  In Windows 8, press the Windows key and the Q key on your keyboard. On the right at Search at the Apps field, type "SQL Server Configuration Manager". Next, click SQL Server 2016 Configuration Manager on the left side of the screen.
2. Click SQL Server Services.
3. On the right side, the SQL Server Browser service is displayed.
  Note: When it is not started, the icon is red. When it is started, the icon is green. Ensure that the service starts automatically so that every time the system is restarted, the service will also start.
4. Right-click SQL Server Browser and select Properties.
5. In the SQL Server Browser Properties screen, click the Service tab.
6. At Start Mode, select Automatic, as displayed in the following screen:
7. Click Apply to apply the changes. The SQL Server Browser service will now start automatically every time the system is started.
8. Next, start SQL Server Browser.
9. In the SQL Server Browser Properties screen, click the Log On tab.
10. Click Start to start the service. When the Start button is inactive, the SQL Server Browser service is already started and you do not have to start it.
  Note: When you have a firewall, you have to configure the firewall to allow connections with SQL Server 2016. The default port for SQL Server 2014 is 1433. The SQL browser used UDP port 1434.

Installing SQL Server Management Studio

The next step is to install SQL Server Management Studio. SQL Server Management Studio is an application for managing the SQL Server. With SQL Server Management Studio, you can create and restore backups, change database settings, and give users SQL Server rights.

Log in as an administrator on the system where you have installed SQL Server 2016.
The setup file for SQL Server Management Studio can be downloaded from the Microsoft website (https://msdn.microsoft.com/library/mt238290.aspx). Place this file on the system where MS SQL Server 2016 is installed.
Start the installation by double-clicking the downloaded file.

The following screen will be displayed:

Click Install to start the installation.

During the installation, you can follow the progress of the installation. The following screens will be displayed. The installation can take some time.