Solved

What Is The Port Number Used By SQL SERVER 2005?

Posted on 2008-06-22
7
2,183 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 17

Expert Comment

by:Malmensa
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
Control application downtime with dependency maps

Visualize the interdependencies between application components better with Applications Manager's automated application discovery and dependency mapping feature. Resolve performance issues faster by quickly isolating problematic components.

 
LVL 39

Accepted Solution

by:
Pratima Pharande earned 250 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 250 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

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

Suggested Solutions

Recently, when I was asked to create a new SQL 2005 cluster, Microsoft released a new service pack for MS SQL 2005 what is Service Pack 3. When I finished the installation of MS SQL 2005 I found myself troubled why the installation of SP3 failed …
In this article I will describe the Copy Database Wizard method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
When you create an app prototype with Adobe XD, you can insert system screens -- sharing or Control Center, for example -- with just a few clicks. This video shows you how. You can take the full course on Experts Exchange at http://bit.ly/XDcourse.
A company’s greatest vulnerability is their email. CEO fraud, ransomware and spear phishing attacks are the no1 threat to a company’s security. Cybercrime is responsible for the largest loss of money to companies today with losses projected to r…

919 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

Need Help in Real-Time?

Connect with top rated Experts

18 Experts available now in Live!

Get 1:1 Help Now