Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

What Is The Port Number Used By SQL SERVER 2005?

Posted on 2008-06-22
7
Medium Priority
?
2,237 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 19

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
NFR key for Veeam Backup for Microsoft Office 365

Veeam is happy to provide a free NFR license (for 1 year, up to 10 users). This license allows for the non‑production use of Veeam Backup for Microsoft Office 365 in your home lab without any feature limitations.

 
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

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.

Question has a verified solution.

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

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 …
INTRODUCTION: While tying your database objects into builds and your enterprise source control system takes a third-party product (like Visual Studio Database Edition or Red-Gate's SQL Source Control), you can achieve some protection using a sing…
This Micro Tutorial will teach you how to add a cinematic look to any film or video out there. There are very few simple steps that you will follow to do so. This will be demonstrated using Adobe Premiere Pro CS6.
Is your data getting by on basic protection measures? In today’s climate of debilitating malware and ransomware—like WannaCry—that may not be enough. You need to establish more than basics, like a recovery plan that protects both data and endpoints.…

885 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