Interview Questions

1. What are the Type of SQL instances and maximum no. of instances that can be installed on a server?

There are two types of Instances.

  1. Default instance
  2. Named Instance


Each computer can run a maximum of 50 instances of the Database Engine. One instance can be the default instance.

The default instance has no name. If a connection request specifies only the name of the computer, the connection is made to the default instance.

A named instance is one where you specify an instance name when installing the instance.

A connection request must specify both the computer name and instance name in order to connect to the instance.

By Expert User 2 0
Is this helpful? Yes No

Submit an interview question

Submitted questions and answers are subject to review and editing, and may or may not be selected for posting, at the sole discretion of w3Sniff.

Get Started

Comments

Leave a Comment


Check out more interview questions

Based on your skills

MS SQL Server

97974 1720 4 860

Angular

2778 92 0 46

Wordpress

2156 72 0 36
AD Ad-Free