CODEWITHSUNDEEP
sql-server
JD.
JD.

Reputation: 15531

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

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

Upvotes: 2

Views: 171

Answers (1)

Joe Stefanelli
Joe Stefanelli

Reputation: 135729

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.

Upvotes: 2

Related Questions