Re: Connecting to a MSDE server in Internet

You can check to see if it's a firewall or port blocking issue or not by using TELNET and seeing if it can connect. Type this from a command prompt (replace INET_SERVER with your server name).

telnet INET_SERVER 1433

If the telnet session fails to connect, you have a firewall issue or are not using the correct port or host name - when I try to connect to something that is blocked by a firewall, the error reported for me was "could not open connection to the host on port xxxx: Connect failed".

If you get a screen that appears to be the start of the connected session, you can be sure you have actually opened a port to another machine. You won't be able to do anything meaningful from this telnet session, but it rules out firewall, port, or hostname issues. Close it and use the same settings to connect with Query Analyzer or Enterprise Manager.

Good luck,
Tony Sebion

"Josep" <hola@xxxxxxxxxxxxx> wrote in message news:#1fFelMxFHA.700@xxxxxxxxxxxxxxxxxxxx:

Hi !!

I would like to connect to a SQL Server (MSDE edition) that's in Internet,
using Enterprise Manager either Query Analizer. For these I've configured
the client tool as:

Server Alias:    INET_SERVER
Net:          TCP/IP
Connection parameters:
Server name: [DNS_NAME]\[REMOTE_SERVER_NAME]\[INSTANCE_NAME]
Port number: 1433

Althought I've tried to configure the server name in different ways, I
haven't found the successful way to do it.
I don't think it's a firewall problem. In theory I've successfull disabled.


Thanks !!

Josep. 

.

Relevant Pages

  • Re: keeping ports open
    ... If a port is open, it means that 1) a software or service is running on your ... and 2) you're not using a firewall or your firewall isn't ... Use firewall software and hardware and antivirus software that is ... Follow the instructions for hardening Windows and IIS at ...
    (microsoft.public.security)
  • Re: How to Maintain an IIS Server?
    ... > server running on a Windows 2000 server. ... before a firewall and antivirus have been installed]. ... open ports; however, this will not identify which program is using the port. ...
    (microsoft.public.inetserver.iis.security)
  • Re: CEICW fails at firewall config
    ... ISA Server prevents connection to a remote desktop when you connect through ... Remote Web Workplace on a Windows Small Business Server 2003-based computer ... Acceleration Server as a firewall. ... connection uses TCP port 4125. ...
    (microsoft.public.windows.server.sbs)
  • Re: How to Maintain an IIS Server?
    ... >> server running on a Windows 2000 server. ... > before a firewall and antivirus have been installed]. ... > program or executable using that port. ...
    (microsoft.public.inetserver.iis.security)
  • Re: Is secedit.exe left by a hacker?
    ... > tested on port 445. ... > I have a Linksys router that I use as a firewall to my ... Secedit.exe is the name of a legitimate Windows file, ... investigate the files on your computer - antivirus with the latest updates ...
    (microsoft.public.win2000.security)