3.3 Named Instance

  • Article

The Named Instance connection string is expressed as follows.

 Data Source=  ServerName\InstanceName;Initial Catalog=DatabaseName; Authentication=Active Directory Integrated

"Data Source=ServerName\InstanceName" specifies that the connection is being established to the named instance InstanceName on the server whose name is ServerName.

The LocalDB Named Instance connection string is expressed as follows.

 Data Source=  (localdb)\InstanceName;Initial Catalog=DatabaseName; Authentication=Active Directory Integrated

"Data Source=(localdb)\InstanceName" specifies that the connection is being established to the named instance InstanceName on the LocalDB server.