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

Hi,

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

Show quoteHide quote

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.

Show quoteHide quote

How do I measure the cost of compiling an execution plan?
select string rows
DBCC CHECKDB Error
Transaction Log Backup complete yet shows as failed?
stored procedure return table
check job status
hot spots
Newbie: Index Tuning Wizard
Performance Tuning
Enterprise vs. Standard