Re: Connecting to a MSDE server in Internet

Well, it seems I didn't unblock the port successfully. So, my work is to
find how this router works... where else I've to configure the ports... but
I like to know that's not an SQL Server problem :-)

Thank you Tony for explaining me this very fast way, and easy, to know if a
port is blocked or not :D

Josep.



"Tony Sebion" <tony@xxxxxxxxxx> escribió en el mensaje
news:3q2bkiFcpoaaU1@xxxxxxxxxxxxxxxxx
> 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: Connecting to an instance in a cluster
    ... "Geoff N. Hiten" wrote: ... you cannot reuse port numbers. ... Microsoft SQL Server MVP ... That is the port you have to open on the firewall. ...
    (microsoft.public.sqlserver.clustering)
  • Re: IIS, SQL 2000 & XPs Firewall
    ... Only one instance of SQL Server can use TCP port 1434. ... You may find it easier to use SQL Server Configuration Manager ... 2008 will be a named instance ... you will have to open those as exceptions in the firewall. ...
    (microsoft.public.sqlserver.connect)
  • Re: IIS, SQL 2000 & XPs Firewall
    ... You may find it easier to use SQL Server Configuration Manager ... 2008 will be a named instance ... Queries to the Data Engine must go to the port that SQL Server is ... you will have to open those as exceptions in the firewall. ...
    (microsoft.public.sqlserver.connect)
  • Re: SQL Server 2008 remote connection problem
    ... Hitchhiker’s Guide to Visual Studio and SQL Server ... default instance of the SQL Server Database Engine listens on TCP port 1433", ... > I was trying to establish a remote connection to SQL Server 2008 from ... The server is running the XP firewall. ...
    (microsoft.public.sqlserver.connect)
  • Re: SQL server connection problem
    ... no firewall is installed? ... Also i have check that port 1433 is not ... Will SQL server only connect to this ... > to configure the firewall to permit connections to SQL Server. ...
    (comp.databases.ms-sqlserver)