Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Default port number Expand / Collapse
Author
Message
Posted Tuesday, December 2, 2008 9:34 PM


SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: Tuesday, July 3, 2012 5:49 AM
Points: 418, Visits: 365
Comments posted to this topic are about the item Default port number
Post #612558
Posted Wednesday, December 3, 2008 7:10 AM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Friday, October 18, 2013 8:39 AM
Points: 1,219, Visits: 226
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.
Post #612813
Posted Wednesday, December 3, 2008 7:20 AM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Friday, October 18, 2013 8:39 AM
Points: 1,219, Visits: 226
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
Post #612827
Posted Wednesday, December 3, 2008 7:44 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: 2 days ago @ 3:41 PM
Points: 1,410, Visits: 8,095

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.
Post #612849
Posted Wednesday, December 3, 2008 8:43 AM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Friday, October 18, 2013 8:39 AM
Points: 1,219, Visits: 226
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.
Post #612912
Posted Thursday, December 4, 2008 9:12 AM
SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Wednesday, September 10, 2014 3:19 AM
Points: 5,371, Visits: 1,391
One of the easiest question I saw in QotD.

:)



Post #613807
Posted Thursday, December 4, 2008 9:19 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: 2 days ago @ 3:41 PM
Points: 1,410, Visits: 8,095

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.
Post #613825
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse