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.

 All Forums
 SQL Server 2005 Forums
 SQL Server Administration (2005)
 sql server and firewall

Author  Topic 

sqlfreakishere
Starting Member

2 Posts

Posted - 2008-11-20 : 14:17:29
I have a SQL SERVER RUNNING ON HOST WITH SOME IP ADDRESS AND USES UDP PRT 1424 AND I WANT IT TO BE ACCESSIBLE BY COLLEAGUES RUNNING SQL CLIENTS IN ANOTHER NETWORK. The firewall configurations are such that they block all connections to UDP Port 1424. Besides the network administrator has refused to modify the firewall rules. The only option i now have is to modify the code in the sql clients which are open source and can be changed at will. The code in the SQL server source code is hardcoded using port 1424.

My company's internal network is 10.6.77/24 AND THE FIREWALL IS AT 10.6.77.1

The firewall is configured as:
Src Ip :Any
Dst Ip : 10.6.77/24
Src Port : Any
Dst Prt :1424
Protocol : UDP
Allow/Blck : Block


So What should i do in such a condition? I want to let other users / colleagues be able to use the SQL server and also want to keep the firewall rules intact. Is there any workaround for this issue?

Michael Valentine Jones
Yak DBA Kernel (pronounced Colonel)

7020 Posts

Posted - 2008-11-20 : 14:31:06
Don't cross post.

CODO ERGO SUM
Go to Top of Page
   

- Advertisement -