Can't make connection 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 !
remote connections are disabled by default.. RIGHT?
<jan.mazing@.gmail.com> wrote in message
news:1176735701.954587.264080@.p77g2000hsh.googlegr oups.com...
> 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 !
>
|||Did you ever resolve this issue? It sounds very similar to mine - see post in
SQL Server Connectivity on 17 May - except I'm on XP Home.
"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 !
>