Multiple choice technology databases

How many default instances can you install on a single SQL Server server?

  1. 1

  2. 2

  3. 3

  4. 4
Reveal answer Fill a bubble to check yourself
A Correct answer
Explanation

SQL Server allows only ONE unnamed default instance per server. The default instance is identified by the computer name alone without any additional instance name. However, you can install multiple named instances on the same server (each with a unique instance name), but only one can be the default instance.

Keep practicing — related questions