1. Home
  2. Knowledge Base
  3. Application
  4. How to install and Configure MSSQL on Windows Server?

How to install and Configure MSSQL on Windows Server?

Microsoft SQL is an enterprise database server solution offered officially from the Microsoft side. It only supports Windows platforms and is often used with .net projects. In this article, we will learn about how to install and configure MSSQL.

Requirements

Memory – At least 1 GB – 4 GB.

Disk –  6 GB – 10 GB.

Processor Speed – 2.0 GHz or faster

Processor Type – x64 Processor.

.NET Framework – NET Framework 4.6 for the Database Engine, Master Data Services, or Replication. SQL Server setup automatically installs .NET Framework. You can follow this article to learn how to install the.NET framework on a windows server.

Download

You can download the SQL server from 2014 to 2019 using the following links.

Installation

Once you downloaded the EXE file, open the downloads directory and right-click on the installer → click on the Run as administrator.

open sql installer windows

Generally, the basic profile should serve all the purposes. Click on the Basics to go ahead with the installation.

sql server basic

Accept the terms by clicking on Accept.

accept sql install terms

Next step, select the installation directoryclick on Install.

install directory and install sql

Now the installer will download the SQL package from the Microsoft repository.

download package sql for installation

Post-download, the installer will start the installation of the SQL.

install the mssql post download package

Congratulations! You have successfully installed the SQL. Here you can find the log location, version details of the SQL, and the connection string which you can use for the configuration.

installation is done sql

Click on Connect Now → Welcome To SQL!

welcome to sql
Updated on November 11, 2022
Need Support?
Can't find the answer you're looking for? Don't worry we're here to help!
CONTACT SUPPORT