Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

What Is The Port Number Used By SQL SERVER 2005?

Posted on 2008-06-22
7
Medium Priority
?
2,225 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
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
10 Questions to Ask when Buying Backup Software

Choosing the right backup solution for your organization can be a daunting task. To make the selection process easier, ask solution providers these 10 key questions.

 
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

Migrating Your Company's PCs

To keep pace with competitors, businesses must keep employees productive, and that means providing them with the latest technology. This document provides the tips and tricks you need to help you migrate an outdated PC fleet to new desktops, laptops, and tablets.

Question has a verified solution.

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

Introduction This article will provide a solution for an error that might occur installing a new SQL 2005 64-bit cluster. This article will assume that you are fully prepared to complete the installation and describes the error as it occurred durin…
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…
Monitoring a network: how to monitor network services and why? Michael Kulchisky, MCSE, MCSA, MCP, VTSP, VSP, CCSP outlines the philosophy behind service monitoring and why a handshake validation is critical in network monitoring. Software utilized …
In this video, Percona Solution Engineer Dimitri Vanoverbeke discusses why you want to use at least three nodes in a database cluster. To discuss how Percona Consulting can help with your design and architecture needs for your database and infras…

721 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