Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2006-03-17 : 08:20:27
|
| Jeff writes "Hello,I would like to request an open connection through our firewall (DMZ) to our SQL Server 2000 database. Our IT support is not familiar with SQL Server and I'm not IT person. I would like to know which TCP/UDP ports need to be open through the firewall. I've read the Microsoft document: http://support.microsoft.com/default.aspx?scid=kb;en-us;287932 and I'm still uncertain about the TCP ports needed. I have changed the default 1433 to another port number. Is this the only port that is considered? What about UDP 1434?Your help is greatly appreciated.Thanks,Jeff" |
|
|
khtan
In (Som, Ni, Yak)
17689 Posts |
Posted - 2006-03-17 : 08:48:34
|
The Default port used by SQL Server is 1433. You can and should change to a high value port no. Yes. SQLServer only uses TCP Port.
KHChoice is an illusion, created between those with power, and those without.Concordantly, while your first question may be the most pertinent, you may or may not realize it is also the most irrelevant |
 |
|
|
eyechart
Master Smack Fu Yak Hacker
3575 Posts |
Posted - 2006-03-17 : 10:08:14
|
| SQL 2000 also uses UDP port 1434.-ec |
|
|
|
khtan
In (Som, Ni, Yak)
17689 Posts |
Posted - 2006-03-17 : 20:12:55
|
quote:
Originally posted by eyechart
SQL 2000 also uses UDP port 1434.-ec
Is it ? Didn't know that.  I normally just enabled the TCP Port on the firewall for remote clients.
KHChoice is an illusion, created between those with power, and those without.Concordantly, while your first question may be the most pertinent, you may or may not realize it is also the most irrelevant |
|
|
|
jen
Master Smack Fu Yak Hacker
4110 Posts |
Posted - 2006-03-18 : 09:34:44
|
have your firewall team check which ports are being accessed to if you try to connect to the sql serverif they can't determine that, refer them to stevie's group  --------------------keeping it simple... |
|
|
|
|
|
|
|
|
SQL Server Firewall TCP/UDP Communication Ports