?
Solved

What Is The Port Number Used By SQL SERVER 2005?

Posted on 2008-06-22
7
Medium Priority
?
2,243 Views
Last Modified: 2011-10-03
Greetings Experts!
I have a question, it may sound very premitive, but I still consider my self all new to SQL SERVER. My question is, What is the port number used by SQL SERVER 2005 to connect and accept connections from client machines, say that the sql server 2005 is install on a server machine, and it is suppose to accept connections from clients.

Thanks in advance.
Best Wishes,
~Salman~
0
Comment
Question by:salman_sulaiman_2008
7 Comments
 
LVL 20

Expert Comment

by:Mal Osborne
ID: 21844022
The default port for SQL is TCP 1433 in all versions.
0
 
LVL 39

Expert Comment

by:Pratima Pharande
ID: 21844038
0
 
LVL 3

Expert Comment

by:ofkr
ID: 21844040
You may check whether port 1433 is listening on server using netstat command prompt.

Run->cmd

C:\> netstat -an
0
Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

 
LVL 39

Accepted Solution

by:
Pratima Pharande earned 1000 total points
ID: 21844041
0
 

Author Comment

by:salman_sulaiman_2008
ID: 21844087
greetings everyone!
thanks for the replies mates!

Best Wishes,
~Salman~
0
 
LVL 14

Assisted Solution

by:Jagdish Devaku
Jagdish Devaku earned 1000 total points
ID: 21844571
Hi,

Ports Used by SQL Server

Port SQL Server Component Using the Port
Port 1433 (UDP/TCP) SQL Server Engine
Port 1434 (UDP/TCP) SQL Server Engine
Port 2382 (UDP/TCP) SQL Server OLAP
Port 2383 (UDP/TCP) SQL Server OLAP
Port 2393 (UDP/TCP) SQL Server OLAP
Port 2394 (UDP/TCP) SQL Server OLAP
Port 2725 (UDP/TCP) SQL Server OLAP
Port 3882 (UDP/TCP) SQL Server DTS (Integration Services)


for more info refer to following link:

http://searchsqlserver.techtarget.com/tip/0,289483,sid87_gci1219962,00.html#

All the best...

0
 

Author Comment

by:salman_sulaiman_2008
ID: 21852556
Greetings Jaqdishdevaku!
Thanks for the reply mate!
that's exactly what I needed to know.
thanks mate!
Best Wishes,
~salman~
0

Featured Post

Free Backup Tool for VMware and Hyper-V

Restore full virtual machine or individual guest files from 19 common file systems directly from the backup file. Schedule VM backups with PowerShell scripts. Set desired time, lean back and let the script to notify you via email upon completion.  

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

There are some very powerful Dynamic Management Views (DMV's) introduced with SQL 2005. The two in particular that we are going to discuss are sys.dm_db_index_usage_stats and sys.dm_db_index_operational_stats.   Recently, I was involved in a di…
When writing XML code a very difficult part is when we like to remove all the elements or attributes from the XML that have no data. I would like to share a set of recursive MSSQL stored procedures that I have made to remove those elements from …
this video summaries big data hadoop online training demo (http://onlineitguru.com/big-data-hadoop-online-training-placement.html) , and covers basics in big data hadoop .
Whether it be Exchange Server Crash Issues, Dirty Shutdown Errors or Failed to mount error, Stellar Phoenix Mailbox Exchange Recovery has always got your back. With the help of its easy to understand user interface and 3 simple steps recovery proced…

578 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question