Can't connect to SQL Server 2005 over VPN

Hi - if anyone can point me the the right direction it would be very
much appreciated. I have searched the groups but haven't sorted this
out yet.
I am trying to connect to a SQL Server 2005 database over a VPN and am
not having any success. Perhaps there are some other tests that can be
recommended to me to narrow down the problem.
The Server (at the office): Windows 2003 R2 with SQL Server 2005 (this
server is not a domain controller)
The Client (at home): Windows XP Pro
VPN: I can connect via the VPN just fine it would seem (for example, I
can browse shared folders on the server)
My Test: As my ultimate goal is to make a ODBC connection to the
server DB, I have been attempting to make an ODBC DSN with the ODBC
Data Source Administrator - it always fails (error is: SQL Server does
not exist of access denied).
Other notes:
- I can successfully connect to the SQL Server database from another
computer that is at the office
- At home, if I ping the server by name, the proper 'remote' IP
address gets returned, however I get 'request timed out' instead of
the 'reply from...'
- At home, In the ODBC Administrator setup, it automatically picks up
the remote server (by IP and by name) in the 'Server' drop down list.
- As far as I know, I have set SQL Server to accept remote connections
Suggestions very much appreciated !
I'm not an expert on how vpns are set up, but my guess is that there is a
firewall that is allowing traffic through the ports used by the vpn, but is
blocking your access to port 1433 which is what the database uses.
MG
"jan.mazing@.gmail.com" wrote:

> Hi - if anyone can point me the the right direction it would be very
> much appreciated. I have searched the groups but haven't sorted this
> out yet.
> I am trying to connect to a SQL Server 2005 database over a VPN and am
> not having any success. Perhaps there are some other tests that can be
> recommended to me to narrow down the problem.
> The Server (at the office): Windows 2003 R2 with SQL Server 2005 (this
> server is not a domain controller)
> The Client (at home): Windows XP Pro
> VPN: I can connect via the VPN just fine it would seem (for example, I
> can browse shared folders on the server)
> My Test: As my ultimate goal is to make a ODBC connection to the
> server DB, I have been attempting to make an ODBC DSN with the ODBC
> Data Source Administrator - it always fails (error is: SQL Server does
> not exist of access denied).
> Other notes:
> - I can successfully connect to the SQL Server database from another
> computer that is at the office
> - At home, if I ping the server by name, the proper 'remote' IP
> address gets returned, however I get 'request timed out' instead of
> the 'reply from...'
> - At home, In the ODBC Administrator setup, it automatically picks up
> the remote server (by IP and by name) in the 'Server' drop down list.
> - As far as I know, I have set SQL Server to accept remote connections
> Suggestions very much appreciated !
>
|||Can anyone help? Is there another group I should post this in?
Thanks