different Types of SQL Server

Thread #250 | 2019-03-22 12:33 UTC | Guest | replies: 3

Post #1 | 2019-03-22 12:33 UTC | Guest

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

Post #2 | 2019-03-22 12:33 UTC | Guest

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

Post #3 | 2019-04-16 20:05 UTC | Guest

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?

Post #4 | 2019-04-18 08:39 UTC | ME_Rotronic

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

No matching posts in this thread.