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.
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@.deamon.dk> wrote in message
news:1174934720.662175.286260@.n59g2000hsh.googlegr oups.com...
> 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.
>
|||hi,
Norman Yuan wrote:
> 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.
yes it can.. :D
access the server property (server node, rx click) and set the
authentication method accordingly to your needs (mixed mode)
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz http://italy.mvps.org
DbaMgr2k ver 0.21.0 - DbaMgr ver 0.65.0 and further SQL Tools
-- remove DMO to reply
|||On Mar 27, 12:06 pm, "Andrea Montanari" <andrea.sql...@.virgilio.it>
wrote:
> hi,
> Norman Yuan wrote:
>
> yes it can.. :D
> access the server property (server node, rx click) and set the
> authentication method accordingly to your needs (mixed mode)
> --
> Andrea Montanari (Microsoft MVP - SQL Server)http://www.asql.biz http://italy.mvps.org
> DbaMgr2k ver 0.21.0 - DbaMgr ver 0.65.0 and further SQL Tools
> -- remove DMO to reply
I will look into that, thank you both!
--Andrea is it you who have developed DbaMgr2k?
|||On Mar 27, 12:06 pm, "Andrea Montanari" <andrea.sql...@.virgilio.it>
wrote:
> hi,
> Norman Yuan wrote:
>
> yes it can.. :D
> access the server property (server node, rx click) and set the
> authentication method accordingly to your needs (mixed mode)
> --
> Andrea Montanari (Microsoft MVP - SQL Server)http://www.asql.biz http://italy.mvps.org
> DbaMgr2k ver 0.21.0 - DbaMgr ver 0.65.0 and further SQL Tools
> -- remove DMO to reply
I tried changing it to mixed mode (it WAS set to Windows
authentication) however now i get the following error:
Login failed for user 'USERNAME' . Reason:Not associated with a
trusted SQL Server connection.
Any ideas?
|||Show your ConnectionString. If you have "Trusted_Connection=True" in
ConnectionString, then the connection is using Windows Authentication, which
is not what you want.
"Tokatrash" <martin@.deamon.dk> wrote in message
news:1175025048.091479.34930@.n76g2000hsh.googlegro ups.com...
> On Mar 27, 12:06 pm, "Andrea Montanari" <andrea.sql...@.virgilio.it>
> wrote:
> I tried changing it to mixed mode (it WAS set to Windows
> authentication) however now i get the following error:
> Login failed for user 'USERNAME' . Reason:Not associated with a
> trusted SQL Server connection.
> Any ideas?
>
|||On Mar 27, 10:17 pm, "Norman Yuan" <NotR...@.NotReal.not> wrote:[vbcol=seagreen]
> Show your ConnectionString. If you have "Trusted_Connection=True" in
> ConnectionString, then the connection is using Windows Authentication, which
> is not what you want.
> "Tokatrash" <mar...@.deamon.dk> wrote in message
> news:1175025048.091479.34930@.n76g2000hsh.googlegro ups.com...
>
>
>
There is no connection string visible to me, i'm using a program
called Winfinance to connect to the MSDE database.
It is that program that gives me that error.
|||Either that program was hard coded to use Windows Authentication (if so, bad
design), or there is someway to configure how the program to connect to SQL
Server (very likely), you just need to find where and how to configure it.
"Tokatrash" <martin@.deamon.dk> wrote in message
news:1175031217.284824.59580@.p77g2000hsh.googlegro ups.com...
> On Mar 27, 10:17 pm, "Norman Yuan" <NotR...@.NotReal.not> wrote:
> There is no connection string visible to me, i'm using a program
> called Winfinance to connect to the MSDE database.
> It is that program that gives me that error.
>
|||hi,
Tokatrash wrote:

> --Andrea is it you who have developed DbaMgr2k?
yes, it's me.. please no insults :D
did you restart the MSDE service?
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz http://italy.mvps.org
DbaMgr2k ver 0.21.0 - DbaMgr ver 0.65.0 and further SQL Tools
-- remove DMO to reply
|||On Mar 28, 3:32 pm, "Andrea Montanari" <andrea.sql...@.virgilio.it>
wrote:
> hi,
> Tokatrash wrote:
> yes, it's me.. please no insults :D
> did you restart the MSDE service?
> --
> Andrea Montanari (Microsoft MVP - SQL Server)http://www.asql.biz http://italy.mvps.org
> DbaMgr2k ver 0.21.0 - DbaMgr ver 0.65.0 and further SQL Tools
> -- remove DMO to reply
Sorry... been away for a while...
No insults at all... just wanted to thank you for a great program...
I tried restarting the MSDE service... no changes... it's really
quite odd.. i really need to be able to connect without using windows
authentication...