Why would you want to not have the default instance name in a SQL server connection string?

Question

Hi,

One of our customers does not want to put the default instance name "MSSQLSERVER" in the connection string. Unfortunately the dba has not replied to any of my emails inquiring what the problem is?

Any reasons why this would cause an issue?

JD

Answer 1

The only "problem" I would see is the confusion that would be caused when someone looks at the connection string and mistakenly thinks that they are using a named instance instead of the default.

This is one of the rare cases where I think you would actually make things clearer by omitting information.