Thursday, August 1, 2013

How many SQLserver instance can own on a single machine?

you have one default instance and 49 named instances. So totally a machine contains 50 instances.
when you loging into default instance you can provide machine name. For named instances you have to provide machine name and instance name

Ex:

default instance:  <Computer name>
named instance: <Computer name>/named instance or <computer name>,portnumber

No comments:

Post a Comment