Re: Enabling Remote Access

If your local machine is not recognised as part of an authenticated domain
by Windows when connected through the VPN, that's pretty much say it:
SQL-Server won't recognise it either.

In your case, you must create a sql-server login and use it when connecting
through the VPN and the authentification mode of SQL-Server must be set to
the mixed mode (Windows + SQL-Server). When connecting using the connection
dialog window of ADP, you must use the option "Use a specific user name and
password" and not the "Use Windows NT Integrated security".

--
Sylvain Lafontaine, ing.
MVP - Technologies Virtual-PC
E-mail: sylvain aei ca (fill the blanks, no spam please)


"ExcelMan" <sfarkas@xxxxxxxxx> wrote in message
news:bb1c7ed9-34e4-47ac-89d4-275ad3082c25@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
I have built and Access Data Project with a SQL Server back end and
deployed in on a server in our office. Within our office a shortcut
to the ADP is provided to each user on their desktop. They are able
to properly launch the application and use it simulutaneously. There
is also a shortcut placed on the server's desktop which also works
fine.

Now my manager wants to allow users to access the application from
home or on the road. I am able to VPN into the server using Remote
Desktop Connection (RDC), click on the shortcut on the server and
launch and use the application.

However I am not able to set up an icon on my laptop desktop and
launch the application. We are using Windows Integrated
Authentication and it appears that the SQL Server backend does not
recognize my login credentials when I come in via the VPN. The login
name in SQL Server is MachineName\username and generally we have
entered the machine name of the server on which the SQL Server
resides. I have tried to create a login on SQL Server that uses the
machine name of my laptop, but that is not accepted either by SQL
Server or Windows on the server.

So my basic question is:

How can I put either a shortcut icon or an icon to a local instance of
my ADP on my laptop desktop and access a SQL Server backend via our
VPN?

Thanks.

Steven


.

Relevant Pages

  • RE: VPN Configuration error
    ... Remote Access wizard to configure VPN. ... How to move the client programs folder to another location in Windows Small ... or if the SBS SP1 did not finish the installation. ... On the SBS server, click Start, click Run, type "regedit" (without the ...
    (microsoft.public.windows.server.sbs)
  • Re: VPN with SBS Premuim
    ... Windows 2003 SP2 networking issues, and then re-ran the CEICW again this time ... I understand that after installing ISA 2004 on the SBS ... server, VPN does not work. ... if you installed SP2 on the SBS server without ...
    (microsoft.public.windows.server.sbs)
  • RE: VPN Problem, PC not Authenticating with Server
    ... is the VPN server, SBS or router? ... Regarding the configuration of L2TP VPN, please also refer to the following ... 818043 L2TP/IPsec NAT-T update for Windows XP and Windows 2000 ... Computer certificates for L2TP/IPSec VPN connections ...
    (microsoft.public.windows.server.sbs)
  • Re: VPN Problem, PC not Authenticating with Server
    ... do you mean you have configured L2TP/IPSec VPN ... is the VPN server, SBS or router? ... 818043 L2TP/IPsec NAT-T update for Windows XP and Windows 2000 ... Computer certificates for L2TP/IPSec VPN connections ...
    (microsoft.public.windows.server.sbs)
  • L2TP/IPSec Verbindung läuft mit XP SP2 nicht mehr
    ... workstation2 mit Windows.xp SP1a und IPSec NAT-T Traversal Update, ... Windows 2003 VPN RRAS Server, ...
    (microsoft.public.de.german.windowsxp.networking)