Microsoft SQL Server Installation Guide
Downloading SQL Server Installer:
Microsoft SQL Server Download site
You will find the Developer edition download from the Microsoft SQL Server
download site.
[Link]
Once the download is complete, go to the destination folder (i.e.
downloads folder on your computer). The installation file will look
something like this:
Click on the install file to begin the installation process.
1. Click the middle tile to select the Custom installation type.
2. Choose where to store the downloaded installation media files and
click Install to continue.
Once the download is complete, the setup window automatically closes
and is replaced by the SQL Server Installation Centre window. Here, start
the wizard to install SQL Server 2019.
3. Select the Installation category on the left-hand side of the SQL
Server Installation Centre window and click the New SQL Server link to
start the installation wizard.
4. The wizard automatically checks for available updates. If there are no
updates ready to install, click Next to proceed.
5. The install wizard checks for any errors that might cause problems
during the setup process. If it detects any failures, fix them before
clicking Next to continue.
6. Choose an installation type. If you are installing SQL Server for the first
time, select the Perform a new installation of SQL Server
2019 option and click Next to continue.
7. Choose the version of SQL Server you want to install and enter a
product key if you have one, then click Next to proceed. For this example,
we are installing the free Developer version.
8. Check the I accept the license terms and Privacy Statement box
and click Next to continue.
9. Select the features you want to install. For this example, we are using
the Database Engine Services option. Click Next to proceed.
10. Enter a name and instance ID for the new SQL server and
click Next to continue.
Note: Once you enter the server’s name using the Named
instance option, the wizard automatically fills in the instance ID field.
11. Set up the service accounts and collation configuration, then
click Next to continue. For this example, we are using the default
settings.
12. In the Server Configuration tab, select the Mixed Mode method of
authentication. Select a user for the role of SQL server administrator and
set up a password for their account. Click Next to proceed.
13. The final step offers a summary of the installation. Click Back to
return to any of the previous steps and change the installation settings or
click Install to start the setup process.
14. Once the setup is complete, the status of setup operations should
read Succeeded. Click Close to exit the install wizard.
Install Microsoft SQL Server
Management Studio
Microsoft SQL Management Studio (SSMS) allows you to design, query,
and manage databases using SQL Server. Follow the steps outlined below
to install it on your system:
1. Download the install file from the SQL Server Management Studio
download page. Scroll down and click the link to download SSMS 18.9.1.
Open the install file to start the setup.
2. Choose an install location and click Install to continue.
3. The packages will be loaded.
In the last step, you will be asked to restart your computer.
Go ahead and restart your PC. In the Start menu (assuming you’re using
Windows OS), you’ll see Microsoft SQL Server 2019, which
contains Microsoft SQL Server Management Studio. Click on it to
start using this application.
Now you will have to connect to SQL Server. Choose SQL Server
Authentication from the Authentication drop-down menu and make sure
the server type and name options are correct:
Write “sa” in the Login field and the server password that you used when
installing the database. You can check Remember password if you don’t
want to keep repeating this step each time you log in. Click Connect.
The editor is ready to manage the server and databases:
Now you are ready to write your first SQL scripts.