Home
Microsoft 365
Linux
Windows
Powershell
Cloud Computing
    Citrix Xendesktop
    Citrix XenApp
Useful links
About
  • Home
  • Microsoft 365
  • Linux
  • Windows
  • Powershell
  • Cloud Computing
    • Citrix Xendesktop
    • Citrix XenApp
  • Useful links
  • About
ajni.IT -
Virtualization•Windows•Windows Server

Microsoft SQL Server 2019 Installation and Configuration Step by Step

October 26, 2022 by AJNI No Comments

Microsoft SQL Server administration is a big topic, but this short installation and configuration guide might help you get started with that.

First of all, download Microsoft SQL Server 2019 Express. You might get other versions (like MS SQL Standard) from your organization’s Licensing Portal (VLSC). The installation and configuration steps are the same. SQL Express can only have a maximum database size of 10GB and some other limitations.

https://www.microsoft.com/en-us/download/confirmation.aspx?id=101064

Run the setup and download media:

Run the downloaded installer and export it somewhere. The setup will launch. We need a new SQL Server instance:

We are performing a brand new installation (I already had installed an instance on this server)

We need the database engine services:

Give the instance a name. You might name the instance after your application.

Leave all this to default

The User Database and log directory should be changed. Normally you have one disk for the database and another disk for the log database, like this:

In some cases, you might limit the amount of RAM the instance can use:

Hit next and let the installation finalize.

Open SQL Server Configuration Manager. Here you should activate the TCP/IP protocol, so that your instance is reachable from a server in the network.

The service has to be restarted:

By default, the instance will have a high port assigned. This can be changed to a lower port like 1433,1434, etc.

Do not forget to restart the instance service after the changes.

Next, configure Windows Firewall. You will need these ports: UDP 1434 for SQL Server Browser and the instance port (the high port TCP 64891 or the manually configured port TCP 1434).

To verify the connection, install Microsoft SQL Server Management Studio on another server in the same domain.

https://learn.microsoft.com/en-us/sql/ssms/download-sql-server-management-studio-ssms?redirectedfrom=MSDN&view=sql-server-ver16

Verify login:

On the left side, you should see something if the login was successful:

In some cases you might need to enable mixed mode authentication, which allows you to authenticate with SQL users (for example the SA user) while also maintaining Windows Authentication.

After this change, the instance service has to be restarted.

Reading time: 1 min

Tip Of the Day

  • Citrix Virtual Apps and Desktops 2203+ grey screen/ConnectionFailure in Eventviewer

    3 days ago

Keep in touch

Oh hi there!
It’s nice to meet you.

Sign up to receive awesome content in your inbox, every month.

Check your inbox or spam folder to confirm your subscription.

Categories

  • AI & Deep Learning (1)
  • Azure (14)
  • Citrix XenApp (15)
  • Citrix Xendesktop (8)
  • Cloud Computing (32)
  • Coding (1)
  • Hyper-V (9)
  • Linux (8)
  • Microsoft 365 (15)
  • Powershell (14)
  • Security (6)
  • VDI (10)
  • Virtualization (18)
  • VMware (9)
  • Windows (21)
  • Windows Client OS (24)
  • Windows Server (61)

Archives

  • March 2023
  • January 2023
  • December 2022
  • November 2022
  • October 2022
  • September 2022
  • August 2022
  • July 2022
  • June 2022
  • May 2022
  • February 2022
  • January 2022
  • December 2021
  • November 2021
  • October 2021
  • September 2021
  • August 2021
  • June 2021
  • May 2021
  • April 2021
  • March 2021
  • February 2021
  • December 2020
  • November 2020
  • September 2020
  • August 2020
  • July 2020
  • June 2020
  • May 2020
  • April 2020
  • March 2020
  • February 2020
  • November 2019
  • October 2019
  • September 2019
  • August 2019
  • July 2019
  • June 2019
  • May 2019
  • April 2019
  • March 2019

ajni IT © 2019