Design a site like this with WordPress.com
Get started

Category: SQL

SQL DB Server Installation


What’s New in SQL Server Installation

Installation is supported on x64 processors only.

SysPrep is supported for all installations of SQL Server. SysPrep now supports failover cluster installations. For more information, see Considerations for Installing SQL Server Using SysPrep and Install SQL Server using SysPrep.

Hardware and Software Requirements for Installing SQL Server

The article lists the minimum hardware and software requirements to install and run SQL Server on the Windows operating system.

This article applies to SQL Server 2016 and later.

The following considerations apply to all editions:

We recommend that you run SQL Server on computers with the NTFS or ReFS file formats. Installing SQL Server on a computer with FAT32 file system is supported but not recommended as it is less secure than the NTFS or ReFS file systems.

SQL Server Setup will block installations on read-only, mapped, or compressed drives.

Installation fails if you launch setup through Remote Desktop Connection with the media on a local resource in the RDC client. To install remotely the media must be on a network share or local to the physical or virtual machine. SQL Server installation media may be either on a network share, a mapped drive, a local drive, or presented as an ISO to a virtual machine.

SQL Server Management Studio installation requires installing .NET 4.6.1 as a prerequisite. .NET 4.6.1 will be automatically installed by setup when SQL Server Management Studio is selected.

SQL Server Setup installs the following software components required by the product:

SQL Server Native Client

SQL Server Setup support files

Hardware and Software Requirements

The following requirements apply to all installations:

ComponentRequirement
.NET FrameworkSQL Server 2016 RC1 and later require .NET Framework 4.6 for the Database Engine, Master Data Services, or Replication. SQL Server 2016 setup automatically installs .NET Framework. You can also manually install .NET Framework from Microsoft .NET Framework 4.6 (Web Installer) for Windows.
For more information, recommendations, and guidance about .NET Framework 4.6 see .NET Framework Deployment Guide for Developers.
Windows 8.1, and Windows Server 2012 R2 require KB2919355 before installing .NET Framework 4.6.
Hard DiskSQL Server requires a minimum of 6 GB of available hard-disk space.
Disk space requirements will vary with the SQL Server components you install.   For more information, see Hard Disk Space Requirements later in this article. For information on supported storage types for data files, see Storage Types for Data Files.

Processor, Memory, and Operating System Requirements

The following memory and processor requirements apply to all editions of SQL Server:

ComponentRequirement
Memory *Minimum:
Express Editions: 512 MB
All other editions: 1 GB
Recommended:
Express Editions: 1 GB
All other editions: At least 4 GB and should be increased as database size increases to ensure optimal performance.

Hard Disk Space Requirements

During installation of SQL Server, Windows Installer creates temporary files on the system drive. Before you run Setup to install or upgrade SQL Server, verify that you have at least 6.0 GB of available disk space on the system drive for these files. This requirement applies even if you install SQL Server components to a non-default drive.

Security Considerations for a SQL Server Installation

Disable NetBIOS and Server Message Block

Servers in the perimeter network should have all unnecessary protocols disabled, including NetBIOS and server message block (SMB).

NetBIOS uses the following ports:

  • UDP/137 (NetBIOS name service)
  • UDP/138 (NetBIOS datagram service)
  • TCP/139 (NetBIOS session service)

SMB uses the following ports:

  • TCP/139
  • TCP/445

Web servers and Domain Name System (DNS) servers do not require NetBIOS or SMB. On these servers, disable both protocols to reduce the threat of user enumeration.

Install SQL Server on Windows

In this exercise, you will install the SQL Server database engine and client tools to access SQL Server.

The Azure VM should be stopped when you have completed a lab so that your subscription is not charged (for free trial subscriptions, this will ensure you will have sufficient credits left to complete the labs over the duration of the course).

Install the SQL Server Database Engine on Windows

In this task, you will install the SQL Server database engine in a Windows virtual machine.

  1. In the SQL Server Installation Center window, on the Installation page, click ew SQL Server stand-alone installation or add features to an existing installation and wait for SQL Server setup to start.
  2. On the Product Key page, in the Specify a free edition box, select Evaluation, and then click Next.
  3. On the License Terms page, note the Microsoft Software License Terms, select I accept the license terms, and then click Next.
  4. On the Microsoft Update page ensure that Use Microsoft Update to check for updates is cleared and click Next. Note that this is to save time in the lab and, in a normal installation, you should select the checkbox.
  5. On the Install Rules page note that there is a warning that you will need to configure your firewall and click Next.
  6. On the Feature Selection page, under Instance Features, select Database Engine Services, and then click Next.
  7. On the Instance Configuration page, ensure that Default instance is selected and click Next.
  8. On the Server Configuration page click Next.
  9. On the Database Engine Configuration page, on the Server Configuration tab, in the Authentication Mode section, select Mixed Mode (SQL Server authentication and Windows authentication). Then enter and confirm the password, Pa$$w0rd.
  10. Click Add Current User; this will add the user that you set up for the virtual machine.
  11. On the FILESTREAM tab, ensure that Enable FILESTREAM for Transact-SQL access is not selected, and then click Next.
  12. On the Ready to Install page, review the summary, then click Install and wait for the installation to complete.
  13. On the Complete page, click Close.

Install SQL Server Management Tools

In this task, you will install SQL Server management tools.

  1. In the SQL Server Installation Center window, on the Installation page, click Install SQL Server Management Tools.
  2. Click Download SQL Server Management Studio.
  3. Click Run.
  4. When setup is complete, click Close and close Internet Explorer.
  5. To add a shortcut to the taskbar, at the bottom-left corner, click the Windows icon, and then commence typing SQL Server.
  6. In the Apps section, when the search result appears, right-click Microsoft SQL Server Management Studio, and then select Pin to Taskbar.

Reference:

What’s New in SQL Server Installation

Hardware and Software Requirements for Installing SQL Server

Security Considerations for a SQL Server Installation

Microsoft: DAT219x Provisioning Databases in Azure and SQL Server

SQL Server 2016 Installation -By Daniel AG