Post reply

Connection string question

  • April 28, 2016 at 3:17 pm

    #318572

    What does fqdn and adding port number does when added to the connection string instead of just using Servername. Any best practices here.

    Servername.domain.com,sqlport

    Thanks..

  • April 28, 2016 at 4:31 pm

    #1875427

    If you're using the default port number then you don't need to include it in your connection string. If your DNS server resolves the server name without the fqdn then you can use only that and dont need the fqdn. The opposite of these statements is also true.

    I don't know if there's a documented best practice with respect to port numbers and fqdn's in conn strings.

    "I cant stress enough the importance of switching from a sequential files mindset to set-based thinking. After you make the switch, you can spend your time tuning and optimizing your queries instead of maintaining lengthy, poor-performing code."

    -- Itzik Ben-Gan 2001

  • April 28, 2016 at 5:31 pm

    #1875436

    Thanks, does using fqdn uses only tcp/ip protocol on sqlclient connectivity not named pipes?

  • April 28, 2016 at 5:36 pm

    #1875437

    SQL!$@w$0ME (4/28/2016)

    Thanks, does using fqdn uses only tcp/ip protocol on sqlclient connectivity not named pipes?

    I believe so.

    "I cant stress enough the importance of switching from a sequential files mindset to set-based thinking. After you make the switch, you can spend your time tuning and optimizing your queries instead of maintaining lengthy, poor-performing code."

    -- Itzik Ben-Gan 2001

Viewing 4 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply