Sunday, February 12, 2012

connecting to sql server through firewall

SQL server seems to be having problems writing to another
sql server database server behind a firewall. The ip
address is able to be pinged through the firewall but
trying to access sql server gives "server does not exist
or access is denied" message. The firewall has been
setup to allow for this particular ip address. Port 1433
is selected and TCP/IP is selected from Client Network
Utility and Server Network Utility.
Any ideas anyone? TIA!Hi Steve:
Suggest you try these steps:
1.Try to close firewell a moment, at that moment, test if the remote
connect work well.
2. If it does not work well, not the problem of firewall, but the
problem of network
If it work well, enable the firewall can try to ping 1433 port on the
remote machine
After these two steps, we can see what problem it is then we can do
more
Best Wishes
Wei Ci Zhou|||Dear Wei,
I did as you suggested and it was indeed the firewall. There was a rule
allowing port 1433 but another rule above that that barred all ports.
Thank you again for your response and your assistance!
Steve
*** Sent via Developersdex http://www.examnotes.net ***
Don't just participate in USENET...get rewarded for it!

No comments:

Post a Comment