Prior to installing SQL Server, you must previously have installed:
-
Microsoft .NET Framework.
-
Windows Installer.
-
Insert your Microsoft SQL Server DVD, and start the setup program.
-
From the Planning page, select System Configuration Checker to check for pre-requisite applications, and identify potential installation problems. You might have to restart your computer if any pre-requisite applications were installed.
-
Select Installation, and then select the New SQL Server stand-alone installation or add features to an existing installation option.
-
Enter your SQL Server 2016 product key provided by Microsoft, and then select Next.
-
Accept the license terms, and then select Next.
-
On the Microsoft Update page, check Use Microsoft Update to check for updates based on your company's policy. Select Next.
Wait while the SQL Server Setup files are installed on the computer.
-
After the setup files are installed, review the results for any failures that must be fixed before you continue. Select Next.
-
On the Feature Selection page, select the features below.
-
Database Engine Services
-
SQL Server Replication (required if the SQL server instance is set up for the Global Workshare configuration)
-
Client Tools Connectivity
-
-
Set the instance root directory and shared feature directories as you need. Select Next.
-
Define your instance name and the instance root directory. Select Next.
-
On the Server Configuration page, specify a domain account name with administrative privileges on the database server. Then, set the Startup Type to Automatic and continue.
-
If you are not sure, use NT AUTHORITY\NETWORK SERVICE or NT AUTHORITY\SYSTEM, and change the server login later.
-
A domain user account offers more flexibility. This type of account is typically used because many server-to-server activities can be performed only with a domain user account, including remote procedure calls, replication, and backing up network drives.
-
-
Select the Collation tab. Use locale-specific collation. These collation settings include the character set, sort order, and other locale-specific settings.
-
Select Next.
-
On the Server Configuration tab of the Database Engine Configuration page:
-
Select Windows authentication mode if you plan to use Windows user names and passwords to access the databases.
-
Select Mixed Mode if you plan to use database user names and passwords to access the databases.
See Understanding Database Authentication to learn about the differences between the two choices.
-
-
Specify at least one SQL Server Administrator. You will need this administrator login later to open SQL Server Management Studio.
-
On the Data Directories tab, verify the directories are set as you need.
-
Select Next, and complete the installation as prompted.
-
Select Close.
-
On the Installation page, select Install SQL Server Management Tools.
-
Download and install SQL Server Management Studio from the MSDN web site.
If any errors occur during installation, refer to the Summary Log for more information and contact support for further assistance.