Difference between default instances and named instances in MSSQL

MSSQLServer instances can be installed on a maximum of 16 instances in version 2000, just as if 16 SQLSERVER instances are installed on one server. Of course, there is no need to install 16 instances on one physical machine, however, during installation, we need to determine whether you are a default instance and a named instance. If you want to install multiple instances, your instance name cannot be duplicated. the following describes the differences between default and named instances:

1. Differences between service names:

(1) default instance: MSSQLSERVER;

(2) named instance: the real column name is benet, and the name in the service is MSSQL $ BENET;

Note: If you have multiple instances, multiple service names will appear in the service.

2. differences when connecting to the query analyzer or probe:

(1) The default instance can be used: "." (Point), "(local)", "computer name"

(2) Instance name: computer name: pcname, Instance name: benet,

The connection name is pcname \ benet.

There are some other differences, but it is enough for our normal operation.