Forum Discussion

MCI-IT's avatar
MCI-IT
Copper Contributor
Jan 13, 2022
Solved

Running both SQL Server 2017 Standard and SQL Server 2019 Express under Server Managment Studio

Good Day,   I hope I am at the Correct Forum, If not can you Please Direct Me to the Correct Place to ask this Question. First, I don't know SQL at All, just a Few of the Basics so My Apologies if...
Management Studio 18.10
SQL Server 2019 Express
  • olafhelper's avatar
    olafhelper
    Jan 13, 2022

    MCI-IT , in the discovery report I see there are 4 instance of SQL Server installed

     

    (Standard) = 2017
    SQLEXPRESS = 2016
    SQLEXPRESS01 => 2019
    MSSQLSERVER2019 => 2019

     

    First ist default, the others are named instances. We can install 1 default and up to 50 named instance on one machine and they can have different versions and different editions; see Work with multiple versions and instances - SQL Server | Microsoft Docs

     

    To connect to a named instance you have to add the instance name with backslash to the server name. If you want to connect to SQL Express 2019, enter

    ServerName\SQLEXPRESS01

    in the server name field in SSMS login dialog.

olafhelper's avatar
olafhelper
Bronze Contributor
Jan 13, 2022

MCI-IT , in the discovery report I see there are 4 instance of SQL Server installed

 

(Standard) = 2017
SQLEXPRESS = 2016
SQLEXPRESS01 => 2019
MSSQLSERVER2019 => 2019

 

First ist default, the others are named instances. We can install 1 default and up to 50 named instance on one machine and they can have different versions and different editions; see Work with multiple versions and instances - SQL Server | Microsoft Docs

 

To connect to a named instance you have to add the instance name with backslash to the server name. If you want to connect to SQL Express 2019, enter

ServerName\SQLEXPRESS01

in the server name field in SSMS login dialog.

Resources