Permission problem



Hi All,

One of my costumers have a program that connects to a servers MSDE
database.
The name of the program is Winfinance.

Trough DbaMGR2k i have granted a Windows 2003 security group full
permissions on the database.

When a client uses the program to connect to the MSDE database using
Windows authentication there is no problems at all.

However the company would like to make it possible for the staff to
dial in using PPTP VPN.
The PPTP VPN server is the router, so the users never authenticate
trough windows, and thereby can't connect to the MSDE database.

I've tried using the SA account, and by creating another account, with
no luck however.

I'm all out of ideas, if somebody have a shot in the dark i'd really
appreciate it.

Have a nice day.

.



Relevant Pages

  • Re: Data corruption with SQL server installed
    ... I noticed that the rogue Primary key that appeareed with the .AddNew method ... The installation of MSDE comes after the installation of MDAC 2.8, ... you could create an empty database and import everything into ...
    (microsoft.public.access.tablesdbdesign)
  • Re: Put database on Internet
    ... > Once you will be able to connect to MSDE or to SQL-Server, ... > and ADP in the same time as frontends to your database. ... >> will be able to serve as SQL server. ...
    (microsoft.public.access.dataaccess.pages)
  • Re: Connect to Access Data from various regional locations
    ... All users will be connecting via broadband. ... When using MSDE ... > Dim rf As DAO.Recordset ... > There is a wizard to split your database into a FE and a BE; ...
    (microsoft.public.access.dataaccess.pages)
  • Re: Using vfoledb with webservices?
    ... MSDE database can handle at full speed. ... capabilities of Microsoft Access or, in the reasonable opinion of Microsoft, ... and unless Licensee Software requires your customers ...
    (microsoft.public.fox.programmer.exchange)
  • Re: Prevent Viewing on worksheet
    ... and run MSDE as a server. ... been on the market for what.. ... MSDE changed the friggin database market... ... i really reccomend using sql authentication.. ...
    (microsoft.public.excel)

Loading