Installing Microsoft Sql Server including the Management Studio

Installing Microsoft Sql Server including the Management Studio

What is Sql Server?

SQL Server is a relational database management system, or RDBMS, developed, maintained and marketed by Microsoft.

It is used to store and retrieve data as requested by the user in a tabular form. The storing and retrieval and be done same system or over a computer network.

Downloading the system

Type Microsoft Sql Server download in url bar and select SQL Server Downloads | Microsoft

From the search results, or click here

Select either Developer or Express version and click download as shown below

In this case, we are selecting Developer Edition for this tutorial, therefore click on Download now for Developer as shown below

Select the installation type you want, in our case, we are selecting Basic, so click on Basic and accept the License Terms by clicking on Accept to continue

Specify the location you want to install the application and click on install button

Wait for the Application to download the time taken depends on your network speed

The installer will install planning section. Click on the Installation tab as shown below

Select New SQL Server stand-alone installation or add features to an existing installation

In product key, you can specify a license or select a free edition. In this tutorial, we will install the developer edition.

Click on Next for License Terms to show the terms to install it. Accept the license terms:

In Microsoft updates, you can verify if there are updates in the installer before proceeding

The Install Rules will verify the Active Template Library, the registry keys and if the computer is not a domain controller, or any feature that will prevent the installation

In the context of the Feature Selection, Select Data Engine Services, which is the database itself. You can also selection other features based on what u want to do. In this case, we are Ok with Data Engine and click on Next.

You can have multiple SQL Server instances in SQL Server in the same server. This can be useful to simulate and practice replications, mirroring or to have separate instances for different purposes. By default, you can install the default instance that is usually the Server computer name, we are choosing default instance for this tutorial

Set how the services start. It is a good practice to keep them. Do not grant administrative privileges to these accounts unless there is no other choice:

There are two options in SQL Server to authenticate. Windows authentication will use the Windows Account to authenticate in SQL. Mixed Mode allows creating internal logins and passwords inside SQL Server. You can Add accounts here using the Add Current User or by pressing the Add button as shown below

Once that you have installed everything, you can verify the configurations. If everything is OK, press Install as shown below

After some minutes depending on your system speed, you will have your database installed

You have successfully installed Sql Server to your Computer System

Thank you