MSSQL Installation

This page gives you the steps you need to take to download, install and configure Microsoft SQL Server (Express edition). Microsoft SQL Server is a database server by Microsoft. It is a software product that primarily aims to store and retrieve data requested by other applications. Microsoft SQL Server and Microsoft SQL Express are basically the same products, so the steps to get them up and running are pretty much the same.

Content
1. Download MSSQL Express
2. Install MSSQL Express

Please jump to the video or if you scroll down you can find screenshots that describe the installation details of MSSQL from the downloading and installing the package, through instance creation until creating the administrator account's password.

The first step is to visit the SQL Server 2019 official download page. You can do this by following this link. Here, please click the download link. Your computer will start to download the required data. After you have all the necessary files, you can proceed to the next step. You can see the download page on Figure 1.

download sql express from microsofts webpage
Figure 1 - Download SQL Express from Microsoft's webpage

Now you have to find the downloaded SQLServer2019-SSEI-Expr.exe file. By default, this will be on your Downloads folder. Find it and run the .exe file to start the installation procedure.

start the installation
Figure 2 - Start the installation

The first step of the installation process is defining the type of installation you want to execute. You have 2 options. If you are installing the SQL Server 2019 to your computer the first time, please choose the first option which is the installation. The second option let’s you add featured to an existing copy of the software. You can see a more detailed explanation of both options on Figure 3.

select an installation type
Figure 3 - Select an installation type

To legally own a copy of the SQL Server 2019, you need to accept Microsoft’s Software License Terms. To proceed, please click the Accept button. You can find it on Figure 4.

accept license terms
Figure 4 - Accept license terms

Now you have the chance to define the installation location of the program. By clicking the browse button, You can navigate to the folder you want the program’s necessary files to be located in and click Ok. Make sure that there are enough free space on the drive you are choosing. You can see the minimum space the software required on the right side of the window, as you can see on Figure 5. Click “Install” if you have found a suitable install destination.

click the install button
Figure 5 - Click the 'Install' button

Now the installer will guide you through the process. First, it will download the install package to your computer. This should not take long but could depend on your internet speed. You don’t have anything to do on this window, just wait until it jumps to the next window. You can see the downloading process on “Figure 6”.

wait until the installation is finished
Figure 6 - Wait until the installation is finished

Now if the installation is finished, you will be presented with the summary panel. You can see that the setup was successfully done. You can see that under the details, it notifies you that the installation was successful. If you want to see the summary log file, you can see the location of it down in a form of an access path. To proceed, press the Close button. You can see the summary window on Figure 7.

installation has been completed
Figure 7 - Installation has been completed

If you close the installer, you will be presented with the SQL Server Installer. Press the customize button to proceed to the next step, where you can search for an update and set the installation preferences. You can see the button on Figure 8.

click the customize button
Figure 8 - Click the 'Customize' button

Now the program will guide you through a setup guide. The first step is to check for updates and install them. If your program is up to date, it should not take long before you can proceed to the next setup step. You can see the scan result on Figure 9.

install setup files
Figure 9 - Install setup files

You have the opportunity to choose which type of installation you wish to do here. The first one is the new installation which installs every necessary instance with the program. The other option is suitable if you already have a working SQL Server on your computer but wishes to add some other features to it. Please choose the first option. You can get more information about both of the options on Figure 10.

select an installation type
Figure 10 - Select an installation type

On the Feature Selection window, you can select which components should the program install. We advise you to install every possible feature, because that way your program will be more versatile. You can see all the options on Figure 11.

select instance features
Figure 11 - Select instance features

Here you can configure your Instance. You can name it and give it an ID. If you decided a good name for it, please click the Next button. You can see all the configuration possibility on Figure 12.

specify the name for the instance
Figure 12 - Specify the name for the instance

In this window, you could specify the service accounts for your SQL Server services. Service accounts are non-human accounts which has more access to server resources than a normal user account. We recommend selecting different service accounts for your different SQL services.

specify the service accounts
Figure 13 - Specify the service accounts

On Figure 14, you can see the Database Engine configuration panel. It provides the information for the server authentication. Please type in the Administrator account’s password for that computer. If you have it filled in, click the Next button.

specify the authentication mode and the password for the administration account
Figure 14 - Specify the authentication mode and the password for the administrator account

Now you have everything set up, you can start the installation procedure. The computer will do everything for you. You just need to wait out the installation. On Figure 15, you can see how the PC will inform you about the progress.

wait until the installation is completed
Figure 15 - Wait until the installation is completed

After the installation is finished, you will see the Complete window, as you can on Figure 16. As you can see, both the Database Engine Server and the SQL Server Replication is installed successfully. You are finished with the installation.

installation has been completed
Figure 16 - Installation has been completed

Now as the last step of the installation, Click the connect now button which will open you a command prompt,as you can see on Figure 17.

cliclk to connect
Figure 17 - Cliclk to Connect

Now you should type in the code seen on Figure 18, but make sure to modify it with you own computers credentials after the DESKTOP part. Pres enter and it will do everything for you. Now you are finished with the installation, and have a working MS SQL Server.

connect details
Figure 18 - Connect details

Create database layout

create database and user
Figure 19 - Create database and user


create database ozekidb
GO
 
use ozekidb
GO

sp_addLogin 'ozekiuser', 'ozekipass'
GO
 
sp_addsrvrolemember 'ozekiuser', 'sysadmin'
GO

login with the created user
Figure 20 - Login with the created user


sqlcmd -U ozekiuser -P ozekipass

create database tables
Figure 21 - Create database tables


use ozekidb
GO

CREATE TABLE ozekimessagein (
 id int IDENTITY (1,1),
 sender varchar(255),
 receiver varchar(255),
 msg nvarchar(160),
 senttime varchar(100),
 receivedtime varchar(100),
 operator varchar(30),
 msgtype varchar(30),
 reference varchar(30),
);
 
CREATE TABLE ozekimessageout (
 id int IDENTITY (1,1),
 sender varchar(255),
 receiver varchar(255),
 msg nvarchar(160),
 senttime varchar(100),
 receivedtime varchar(100),
 operator varchar(100),
 msgtype varchar(30),
 reference varchar(30),
 status varchar(30),
 errormsg varchar(250)
);
 
GO

More information