Re: SQL Server through VPN

From: Arvind Shyamsundar (arvindsh@online.microsoft.com)
Date: 01/17/03 

From: "Arvind Shyamsundar" <arvindsh@online.microsoft.com>
Date: Fri, 17 Jan 2003 15:45:47 +0530

Hi Sergio,
Assuming you are using SQL Server 2000, the issue you describe is a known
one. Please refer the Knowledge Base article Q306199 - FIX: Dynamic IP
Addresses Cannot Connect to SQL Server 2000 which talks it. The issue is
fixed in SQL Server Service Pack 2. URL for this article is
http://support.microsoft.com/default.aspx?scid=kb;en-us;306199

HTH,

Arvind S. 

--
This posting is provided "AS IS" with no warranties, and confers no rights.
"Sergio Pozzetti" <spozzetti@usa.net> wrote in message
news:3e26eee5$0$1497$a729d347@news.telepac.pt...
> Hi all,
>
> Our problem is the following: we are attempting to configure
synchronization
> between two SQL servers connected through VPN. We'll call SQL1 the client
> (i.e. calling) machine and SQL2 the VPN server.
>
> SQL1 is on a 192.168.0.x network.
>
> When SQL1 connects through VPN to SQL2, a static 10.0.0.x IP is assigned
to
> SQL1.
>
> From any computer on the remote network (i.e. the network to which SQL2
> belongs) we are able to map SQL1 drives, telnet to open ports (i.e. SSH
and
> VNC) BUT we are not able to telnet to the SQL server port.
>
> In short: telnetting SQL1 locally to the SQL server port works fine.
> Telnetting SQL1 from a remote network to which it is connected through VPN
> does not work.
>
> WHY? Any clues? Does SQL Server have IP/username pairs ACLs?
>
> Bye,
>
>
>
> Sergio Pozzetti <sergio@tektix.com>
>
> TEKTIX - Consultoria em Sistemas de Informação, L.da http://www.tektix.com
>
>
>

Relevant Pages

  • SQL Server through VPN
    ... between two SQL servers connected through VPN. ... SQL1 is on a 192.168.0.x network. ... telnetting SQL1 locally to the SQL server port works fine. ... Telnetting SQL1 from a remote network to which it is connected through VPN ...
    (microsoft.public.sqlserver.security)
  • SMS_MP_CONTROL_MANAGER Error
    ... SMS Management Point encountered an error when connecting to its ... Database SMS_CLBC on SQL Server SQL1. ... SMS Management Point does not have sufficient access ...
    (microsoft.public.sms.admin)
  • Copy the Logins
    ... I have SQL Server 2000 in Machine 'Machine1'. ... In SQL1, some miscellaneous databases ... I have taken the backup of miscellaneous databases from ... how to copy the user logins from ...
    (microsoft.public.sqlserver.security)
  • RE: Error for a job that uses a MSDASQL linked server
    ... 2.As documented in SQL Server Books Online, ... "Manpreet Singh" wrote: ... that calls a remote stored procedure saved on SQL1. ... The remote stored procedure use a OPENQUERY that uses a MSDASQL ...
    (microsoft.public.sqlserver.server)
  • RE: Error for a job that uses a MSDASQL linked server
    ... But this refers to SQL Server 2000 not 2005. ... "Manpreet Singh" wrote: ... that calls a remote stored procedure saved on SQL1. ... The remote stored procedure use a OPENQUERY that uses a MSDASQL ...
    (microsoft.public.sqlserver.server)
Quantcast