August 21, 2006 at 11:23 pm
I have agonized over this problem for a while. I'm running MS SQL Server 2000 SP 4 on Windows 2003 server SP1. On My windows firewall I have approved SQL server to connect to the Internet and also opened port 1433. My server is not behind any other firewall. I cannot remotely connect to this sql server. Whenever i try I get a 'SQL server does not exist or access denied' error message. I know my login credentials are correct. SQL server log shows server is listening on port 1433. I cannot telnet thru port 1433(nmapping this port shows it as closed although I opened it on firewall)
August 22, 2006 at 8:22 am
I'm slightly confused. Where are you connecting from? Are you on the same network as the SQL Server and trying to get out the firewall and back to the server? This doesn't usually work.
Or is it:
computer (network 1) -> firewall -> Internet -> firewall -> SQL Server (network 2)
August 22, 2006 at 9:27 am
Thanks 4 the reply. I finally figured what my problem was. The remote client I was connecting from is behind a corporate firewall that doesn't allow outbound traffic on port 1433.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply