different Types of SQL Server

[Support]

what are the different Types of SQL Server when typing the connection strings?

[Support]

Local SQL Express	Data Source=.\SQLEXPRESS
Remote SQL Express	Data Source=SERVERNAME\SQLEXPRESS
Local SQL Server	Data Source=SQL_INSTANCE_NAME
Remote SQL Server	Data Source=SERVERNAME\SQL_INSTANCE_NAME

[Justin Bolduc]

Do we know what the default instance name would be for MSSQL Standard 2017? Does anyone know how to retrieve it after SQL instance has been created?

[ME_Rotronic]

The defined instance name is visible within the MSSMS (Microsoft SQL Server Management Studio).