About this question
I'm getting 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. What is sql server instance name?