SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
 Password:
Save Password
Forgot your Password?

 All Forums
 SQL Server 2000 Forums
 SQL Server Administration (2000)
 Cannot Connect Remotely thru port 1433		  New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

cyrus_thevirus
Starting Member

5 Posts
Posted - 08/22/2006 :  01:16:37  Show Profile  Reply with Quote
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)

khtan
In (Som, Ni, Yak)

Singapore
16746 Posts
Posted - 08/22/2006 :  01:32:55  Show Profile  Reply with Quote
can you connect to the SQL Server from the Windows 2003 server itself ?

What is the client you used to connect to the SQL Server ? Have you tried using Query Analyser ?

KH
Go to Top of Page

cyrus_thevirus
Starting Member

5 Posts
Posted - 08/22/2006 :  01:45:29  Show Profile  Reply with Quote
yes I can connect on the localmachine. I'musing the enterprise manager from a remote machine
Go to Top of Page

khtan
In (Som, Ni, Yak)

Singapore
16746 Posts
Posted - 08/22/2006 :  01:48:22  Show Profile  Reply with Quote
Have you tried connect to SQL Server from other PC using Query Analyser ?

Also try connect using <server ip addr,1433>

KH
Go to Top of Page

cyrus_thevirus
Starting Member

5 Posts
Posted - 08/22/2006 :  02:04:42  Show Profile  Reply with Quote
Thanks 4 ur help. I figured out the problem and boy do I feel stupid. The client I was trying to connect from was behind a corporate firewall that restricted the use of port 1433.
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.05 seconds. Powered By: Snitz Forums 2000