Connecting to SQL Server across VPN

I have a PPTP VPN tunnel created with two Netopia routers. SQL Server is on
192.168.10.0. The database is on a folder that is shared and 'Everybody'
has full control.
The POS is on 192.168.11.0 and has drive X mapped to the share on the server
with the database. The POS software gets a SQL access denied error
connecting to the database on the server. POS terminal on the same network
connect without any trouble.
How can I work around this? We are using Microsoft Retail Management POS
system.
ThanksHi,
Create a Server Alias using Client network utility, specifying TCP IP as
protocol. After that use the new Alias server name to connect to sql server.
Thanks
Hari
SQL Server MVP
"Rob_Wal" <r042wal@.dontspammeatgmail.com> wrote in message
news:evofEf1WFHA.1404@.TK2MSFTNGP09.phx.gbl...
>I have a PPTP VPN tunnel created with two Netopia routers. SQL Server is
>on 192.168.10.0. The database is on a folder that is shared and
>'Everybody' has full control.
> The POS is on 192.168.11.0 and has drive X mapped to the share on the
> server with the database. The POS software gets a SQL access denied error
> connecting to the database on the server. POS terminal on the same
> network connect without any trouble.
> How can I work around this? We are using Microsoft Retail Management POS
> system.
> Thanks
>|||I successfully connected across a PPTP VPN and then to SQL server, but it
was a very round-about way. It was necessary that I have a permanent VPN
tunnel up and performance was an issue. This made it necessary to have two
routers create the tunnnel instead of SBS, however, getting there was a
chore and I thought I would share this.
I first established a PPTP tunnel between the two Netopia R910 routers.
Then on the remote POS terminal (192.168.11.2), I created an entry in LMHOST
pointing the server (tpsrvr01) to 192.168.10.2. Then I changed the DNS on
the the POS to point to the SBS server, 192.168.10.2.
I then tried to manually join the domain, but an error was thrown up that no
domain controller could be contacted when I changed from workgroup to
thepatch.loca
I stopped the router from answering PPTP requests and forwarded PPTP
requests to RRAS on the SBS server. I created a PPTP VPN connection on the
POS, made a connection to the SBS server, then joined the domain. When the
workstaion rebooted, I check off the dialup box on the login screen, made a
VPN connection first, and logged on to the domain.
After all this was successful, I got the VPN tunnel going again between the
two routers and the POS terminal logged on fine to the SBS server. I was
also able to connect to the SQL server database for the POS too.
"Rob_Wal" <r042wal@.dontspammeatgmail.com> wrote in message
news:evofEf1WFHA.1404@.TK2MSFTNGP09.phx.gbl...
>I have a PPTP VPN tunnel created with two Netopia routers. SQL Server is
>on 192.168.10.0. The database is on a folder that is shared and
>'Everybody' has full control.
> The POS is on 192.168.11.0 and has drive X mapped to the share on the
> server with the database. The POS software gets a SQL access denied error
> connecting to the database on the server. POS terminal on the same
> network connect without any trouble.
> How can I work around this? We are using Microsoft Retail Management POS
> system.
> Thanks
>