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 |
cyrus_thevirus
Starting Member
5 Posts |
Posted - 2006-08-22 : 01:16:37
|
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)
17689 Posts |
Posted - 2006-08-22 : 01:32:55
|
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 |
|
|
cyrus_thevirus
Starting Member
5 Posts |
Posted - 2006-08-22 : 01:45:29
|
yes I can connect on the localmachine. I'musing the enterprise manager from a remote machine |
|
|
khtan
In (Som, Ni, Yak)
17689 Posts |
Posted - 2006-08-22 : 01:48:22
|
Have you tried connect to SQL Server from other PC using Query Analyser ?Also try connect using <server ip addr,1433> KH |
|
|
cyrus_thevirus
Starting Member
5 Posts |
Posted - 2006-08-22 : 02:04:42
|
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. |
|
|
|
|
|