ADP interface using a VPN to connect to SQL database

[Tim Span]

I have an MS Access Project using Windows NT Integrated
Security. This works fine for local users, however,
remote users who connect and authenticate through the VPN
at Windows login cannot use the application. They receive
error 18452: "Login failed for user '(null)'...." I would
like to avoid having to use Windows security for the local
users and SQL security for the remote users.

Thank you in advance,

Tim Span

 

[Vadim Rapp]

TS> I have an MS Access Project using Windows NT
TS> Integrated Security. This works fine for local
TS> users, however, remote users who connect and
TS> authenticate through the VPN at Windows login
TS> cannot use the application. They receive error
TS> 18452: "Login failed for user '(null)'...." I
TS> would like to avoid having to use Windows security
TS> for the local users and SQL security for the
TS> remote users.

Your remote users probably don't login into the domain. There are 2 logons,
first to the VPN server, then another logon into the domain. In Windows XP
it's in the Options of the VPN connection - "Include Windows logon domain" -
make sure it's checked.

Vadim