SQL Server - difference between instance name and instance id
I'm a bit confused with SQL Server instances. The Instance Name and Instance ID are different properties, yet Instance ID tends to be defaulted to a capitalized version of the Instance Name. The installation allows you to set a different value for the ID than the Name, although typically they're the same. Obviously, ID refers to internal reference and Name refers to user-friendly reference. But what are the fundamental differences between the two? When should one be used rather than the other? I need to understand this while deploying / installing SQL Server 2008 R2 Express on our clients' server machines from a custom installation process.
By default, the instance name is used as the Instance ID can be used to solve sql server instance name. Instance ID is used to identify installation directories and registry keys for your instance of SQL Server. This is the case for default instances and named instances.