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 |
|
olivia919
Starting Member
11 Posts |
 Posted - 2005-05-25 : 14:40:00
|
| My company has firewall. One of my applications requires to go out of the firewall and grab some data from a outside sql serve(sql2.TEST.com). I get access deny error. I do have internet access to outside. is there a way that I can access the outside server from behind the firewall?Thanks for the help!!!!!!! |
|
|
AjarnMark
SQL Slashing Gunting Master
3246 Posts |
Posted - 2005-05-25 : 17:00:50
|
| It is likely that the other server is behind a firewall and it is their firewall that is blocking you, not your own. You will need to contact the admins of that other system to come up with a method of connecting to their server.---------------------------EmeraldCityDomains.com |
 |
|
|
donpolix
Yak Posting Veteran
97 Posts |
Posted - 2005-05-27 : 08:05:55
|
| "You have internet access outside"- did you mean here your application can access most service ports other than 80?Well, assuming you can access sql server ports (1433) outside, and you get access denied errors,. it's on the server's end that needs to allow your ip to be accepted.Donn Policarpio |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2005-05-27 : 18:13:08
|
quote:
Originally posted by olivia919
My company has firewall. One of my applications requires to go out of the firewall and grab some data from a outside sql serve(sql2.TEST.com). I get access deny error. I do have internet access to outside. is there a way that I can access the outside server from behind the firewall?Thanks for the help!!!!!!!
Did the firewall admin punch a hole for the port that SQL Server is listening on? Also, don't use 1433 for servers that need to be protected behind a firewall. Pick a port over 10000.Tara |
|
|
|
raclede
Posting Yak Master
180 Posts |
Posted - 2005-05-29 : 20:20:18
|
Yah, I agree with Tara since SQL Server are known to run under port 1433, when exposing it to NET it should be wise to change the port number.. since these known ports are first to be scanned."If the automobile had followed the same development cycle as the computer, a Rolls-Royce would today cost $100, get a million miles per gallon, and explode once a year, killing everyone inside. " raclede |
|
|
|
|
|
|
Access SQL server behind firewall