Re: Permission problem
- From: "Norman Yuan" <NotReal@xxxxxxxxxxx>
- Date: Mon, 26 Mar 2007 13:14:46 -0700
SQL Server has two Authentication mode: Windows Authentication mode and
mixed mode (Windows and SQL Server). By default installation, it is most
likely, your MSDE is set "Windows Authentication" mode only. If your users
who access the SQL Server cannot be authenticated by its Windows user
account, then you need to enable the mixed authentication mode before you
can use a UserName/Password pair to access the database (never use SA for
the application access).
If you have Enterprise Manager, enable mixed authentication mode is an easy
task. I do not know the tool "DbaMGR2k" can do that or not. If not, search
the web/MS KB for article(s) on how to enable MSDE's mixed security mode.
"Tokatrash" <martin@xxxxxxxxx> wrote in message
news:1174934720.662175.286260@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
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.
.
- References:
- Permission problem
- From: Tokatrash
- Permission problem
- Prev by Date: Permission problem
- Next by Date: Re: MSDE 2000
- Previous by thread: Permission problem
- Next by thread: Re: MSDE 2000
- Index(es):
Relevant Pages
|
