Solved

What Is The Port Number Used By SQL SERVER 2005?

Posted on 2008-06-22
7
2,195 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 18

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
Microsoft Certification Exam 74-409

Veeam® is happy to provide the Microsoft community with a study guide prepared by MVP and MCT, Orin Thomas. This guide will take you through each of the exam objectives, helping you to prepare for and pass the examination.

 
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

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Question has a verified solution.

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

Suggested Solutions

So every once in a while at work I am asked to export data from one table and insert it into another on a different server.  I hate doing this.  There's so many different tables and data types.  Some column data needs quoted and some doesn't.  What …
Data architecture is an important aspect in Software as a Service (SaaS) delivery model. This article is a study on the database of a single-tenant application that could be extended to support multiple tenants. The application is web-based develope…
Two types of users will appreciate AOMEI Backupper Pro: 1 - Those with PCIe drives (and haven't found cloning software that works on them). 2 - Those who want a fast clone of their boot drive (no re-boots needed) and it can clone your drive wh…

828 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