Discussion:
Can IAS do SQL authentication?
(too old to reply)
jayv
2009-05-27 00:45:01 UTC
Permalink
Can IAS radius be configured to do a SQL query to look up the account name
and password in a SQL database? I found an artible that seems to suggest
this is possible (http://support.microsoft.com/kb/193127). However, when i
installed IAS on my 2003 server, i don't see any tab (as mentioned in the
article). The IAS window has a File Action View Help menu across the top,
and tree menu on the left (similar to IIS mgr). Can anyone confirm that IAS
can do SQL authentication? If so, does anyone have any experience
configuring it? Do i need a particular version of IIS or IAS to do this?
To reiterate... I want the IAS radius server to do SQL
query to a database table of my choice to verify the user name and password
and send a radius accept request back if the query returns a match.
jayv
2009-05-27 20:49:01 UTC
Permalink
the post titled "VPN Authentication (separate db?)" actually answers my
question. Not the way i was hoping but definately an answer.

In short, that article referring to ODBC authentication is referencing an
old version of IAS - the feature does not exist anymore. To do what i need
to do, you must write an extension dll (which can not be written in C# either
- C or C++ only).
It also says that it would be better to manage your users/pwds inside AD. I
only post this so some other poor sucker doesnt waste their time with this
question. p.s. - if anyone has written a dll for IAS that does sql
authentication - i would still love to see it.
Post by jayv
Can IAS radius be configured to do a SQL query to look up the account name
and password in a SQL database? I found an artible that seems to suggest
this is possible (http://support.microsoft.com/kb/193127). However, when i
installed IAS on my 2003 server, i don't see any tab (as mentioned in the
article). The IAS window has a File Action View Help menu across the top,
and tree menu on the left (similar to IIS mgr). Can anyone confirm that IAS
can do SQL authentication? If so, does anyone have any experience
configuring it? Do i need a particular version of IIS or IAS to do this?
To reiterate... I want the IAS radius server to do SQL
query to a database table of my choice to verify the user name and password
and send a radius accept request back if the query returns a match.
Loading...