Default and Named Instances

Microsoft SQL Server supports multiple instances of SQL Server running concurrently on the same computer. Each instance of the SQL Server has its own set of system and user databases that are not shared between instances. Refer to your SQL Server documentation for additional details.

A computer can have one default instance and many named instances. The default instance can be a SQL Server server. DPX supports the following combinations:

  • Default instance alone on a single node

  • Named instances alone on a single node

  • Default and named instances on a single node

  • Named instances on a single node

  • Active-Passive SQL Server on a Windows Cluster

  • Active-Active SQL Server on a Windows Cluster

Related Topics:

Last updated