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


Leave a Comment

Check out more interview questions

Based on your skills

MS SQL Server

1755996 1720 23 859


45516 92 0 46


36682 72 1 36