|
|
You're in the
sql server msde
group:Permission problem
sql server msde:
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. [quoted text, click to view] "Tokatrash" <martin@deamon.dk> wrote in message news:1174934720.662175.286260@n59g2000hsh.googlegroups.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,
[quoted text, click to view] 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>
[quoted text, click to view] wrote: > 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 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>
[quoted text, click to view] wrote: > 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 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. [quoted text, click to view] "Tokatrash" <martin@deamon.dk> wrote in message news:1175025048.091479.34930@n76g2000hsh.googlegroups.com... > On Mar 27, 12:06 pm, "Andrea Montanari" <andrea.sql...@virgilio.it> > wrote: >> 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 > > 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? >
[quoted text, click to view]
On Mar 27, 10:17 pm, "Norman Yuan" <NotR...@NotReal.not> wrote: > 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.googlegroups.com... > > > On Mar 27, 12:06 pm, "Andrea Montanari" <andrea.sql...@virgilio.it> > > wrote: > >> 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 > > > 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? 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. [quoted text, click to view] "Tokatrash" <martin@deamon.dk> wrote in message news:1175031217.284824.59580@p77g2000hsh.googlegroups.com... > On Mar 27, 10:17 pm, "Norman Yuan" <NotR...@NotReal.not> wrote: >> 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.googlegroups.com... >> >> > On Mar 27, 12:06 pm, "Andrea Montanari" <andrea.sql...@virgilio.it> >> > wrote: >> >> 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 >> >> > 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? > > 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,
[quoted text, click to view] 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>
[quoted text, click to view] wrote: > 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 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...
Don't see what you're looking for? Try a search.
|
June 2004
July 2004
August 2004
September 2004
October 2004
November 2004
December 2004
January 2005
February 2005
March 2005
April 2005
May 2005
June 2005
July 2005
August 2005
September 2005
October 2005
November 2005
December 2005
January 2006
February 2006
March 2006
April 2006
May 2006
June 2006
July 2006
August 2006
September 2006
October 2006
November 2006
December 2006
January 2007
February 2007
March 2007
April 2007
May 2007
June 2007
July 2007
August 2007
September 2007
October 2007
| home · blog · groups | Questions? Comments? Contact the dn |