Default port number

  • Comments posted to this topic are about the item Default port number

  • The context of this question was unclear. This is a DBA forum and per Microsoft, the default dedicated Administrative port for SQL Server is 1434, which is always available if the main SQL Server service is running. Port 1433 is the default port for user connection and it is possible for the service to be running but port 1433 to be unavailable. It seems to me that both 1433 and 1434 should be deemed correct answers to this question.

  • As a followup, the MS reference for Port 1434 assignment is in Books Online

  • Irish Flyer, 1434 is not a default for SQL 2000.



    Alvin Ramard
    Memphis PASS Chapter[/url]

    All my SSC forum answers come with a money back guarantee. If you didn't like the answer then I'll gladly refund what you paid for it.

    For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]

  • Alvin,

    You are correct about SS2000, but most shops have moved on to SS2005 and many are either using or planning migration to SS2008. The use of a Dedicated Administrative Connection, which became available with SS2005, is very useful for DBAs in large shops because it gives a method of access that is not restricted by client traffic, or other port clogging that can happen on the main client connection port.

    It would be interesting to see what proportion of shops are still working on SS2000 or earlier. We recently converted the last of our SS2000 servers to SS2005. It is not a difficult migration except for all the DTS pkgs and Jobs. Even using a powerful tool like DTSxChange, that is not trivial if you have a lot of pkgs and jobs.

    I work in a health informatics shop supporting medical research on around 40TB of clinical data. The users are statisticians and epidemiologists who build massive complicated analysis queries.

    Prior to the migration, we had been allowing the DB users to build their own DTS pkgs, but found they were abusing it. Many were using DTS to do what should have been simple cross-platform SQL references (we have many linked servers to split loads and control security) and in the process they were propagating copies of data tables to platforms where they were not supposed to reside. We solved a major data management issue by stopping that practice when we migrated. Now SSIS pkgs are built to specs by dedicated ETL analysts or the DBAs, and we provided an advanced SQL class for the DB users. It was an eye opener for them and their management.

  • One of the easiest question I saw in QotD.

    🙂

  • It was so easy that I went to the trouble of looking it up to be sure it wasn't a trick.



    Alvin Ramard
    Memphis PASS Chapter[/url]

    All my SSC forum answers come with a money back guarantee. If you didn't like the answer then I'll gladly refund what you paid for it.

    For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]

Viewing 7 posts - 1 through 6 (of 6 total)

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