SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


Default port number


Default port number

Author
Message
arup chakraborty
arup chakraborty
SSCommitted
SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)

Group: General Forum Members
Points: 1594 Visits: 365
Comments posted to this topic are about the item Default port number
Irish Flyer
Irish Flyer
SSCommitted
SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)

Group: General Forum Members
Points: 1597 Visits: 240
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.
Irish Flyer
Irish Flyer
SSCommitted
SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)

Group: General Forum Members
Points: 1597 Visits: 240
As a followup, the MS reference for Port 1434 assignment is [url=ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/udb9/html/993e0820-17f2-4c43-880c-d38290bf7abc.htm] in Books Online
Alvin Ramard
Alvin Ramard
SSCoach
SSCoach (15K reputation)SSCoach (15K reputation)SSCoach (15K reputation)SSCoach (15K reputation)SSCoach (15K reputation)SSCoach (15K reputation)SSCoach (15K reputation)SSCoach (15K reputation)

Group: General Forum Members
Points: 15796 Visits: 11725
Irish Flyer, 1434 is not a default for SQL 2000.



Alvin Ramard
Memphis PASS Chapter

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
Irish Flyer
Irish Flyer
SSCommitted
SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)

Group: General Forum Members
Points: 1597 Visits: 240
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.
Anipaul
Anipaul
SSChampion
SSChampion (12K reputation)SSChampion (12K reputation)SSChampion (12K reputation)SSChampion (12K reputation)SSChampion (12K reputation)SSChampion (12K reputation)SSChampion (12K reputation)SSChampion (12K reputation)

Group: General Forum Members
Points: 12609 Visits: 1407
One of the easiest question I saw in QotD.

Smile



Alvin Ramard
Alvin Ramard
SSCoach
SSCoach (15K reputation)SSCoach (15K reputation)SSCoach (15K reputation)SSCoach (15K reputation)SSCoach (15K reputation)SSCoach (15K reputation)SSCoach (15K reputation)SSCoach (15K reputation)

Group: General Forum Members
Points: 15796 Visits: 11725
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

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
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum







































































































































































SQLServerCentral


Search