2

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

Improve this question
5
  • 1
    If it's the default instance then I didn't realise it could be referenced with a name. Was it installed as the default instance or was it installed as a named instance? Commented Aug 12, 2010 at 14:19
  • 1
    I'll turn the question around. What are your reasons for thinking it should be part of the connection string? Microsoft's own documentation omits the default instance name. Commented Aug 12, 2010 at 14:22
  • Hi Joe, Well I do not think it needs to be there, and clearly without it the connection is still made. We can change the documentation to reflect this, it was more a question of why it has caused a problem from a dba point of view? Commented Aug 12, 2010 at 14:48
  • Hi Martin, SQL server was installed as the default instance. So we do not need to have it in the connection string. Commented Aug 12, 2010 at 14:49
  • I'm confused by this question. You say "one of our customers does not want to put the default instance name ... in the connection string." You also comment that you "do not think it needs to be there", so aren't you and the customer in agreement? Commented Aug 12, 2010 at 15:10

1 Answer 1

Reset to default
2

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.

Improve this answer
Sign up to request clarification or add additional context in comments.

1 Comment

Hi Joe, thanks for the reply. I agree with others that it should not be there, I just wanted to know what the issues could be (i.e. whether it was a security problem or not).

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.