Skip to main content

You are not logged in. Your edit will be placed in a queue until it is peer reviewed.

We welcome edits that make the post easier to understand and more valuable for readers. Because community members review edits, please try to make the post substantially better than how you found it, for example, by fixing grammar or adding additional resources and hyperlinks.

10
  • 10
    Each instance must be on a separate port, so port=instance in Sql server. I never knew this ",port" until now, though - thank you. Commented Mar 14, 2011 at 4:35
  • 2
    @Daniel: yep, you need to specify either port or instance. Commented Mar 14, 2011 at 4:37
  • 12
    Note: instance name is ignored when port is specified. So "mycomputer.test.xxx.com\AnyOldRubbish,1234" still works. Commented Mar 14, 2011 at 5:32
  • 1
    How does this work if the default (MSSQLSERVER) instance isn't running on 1433? Commented Mar 16, 2017 at 15:58
  • "not necessary to specify an instance name " That was key for me. FreeTDS on Raspi will crash if you put in the instance name and a port. Never knew you could skip the instance name, and that's the only way to get it working in FreeTDS. Commented Oct 20, 2017 at 17:31