KB193127 - How to Set Up IAS (RADIUS Server) with ODBC Authentication

Article ID: 193127

Article Last Modified on 6/23/2005

Microsoft Internet Authentication Services for Remote Access Service 1.0
Microsoft Commercial Internet System 2.0
Microsoft Internet Information Server 4.0

This article was previously published under Q193127

We strongly recommend that all users upgrade to Microsoft Internet Information Services (IIS) version 6.0 running on Microsoft Windows Server 2003. IIS 6.0 significantly increases Web infrastructure security. For more information about IIS security-related topics, visit the following Microsoft Web site:

http://www.microsoft.com/technet/security/prodtech/IIS.mspx

SUMMARY

This article describes how to set up Microsoft Internet Authentication Server (also known as Microsoft Remote Authentication Dial-In User Service (RADIUS Server) for authentication to a third-party ODBC data source. The purpose of this article is to walk you through the process of setting up a sample ODBC source (in this case SQL Server is used) and Microsoft RADIUS Server.

MORE INFORMATION

How to set up a SQL Server 6.5 database for RADIUS authentication:

Install SQL Server 6.5 with Service Pack 4.
For Language, select 850multi-lingual.
For Sort-Order, select Alternative Directory Order, Case-Insensitive.
For Network Options, select Named Pipes.
When SQL Server is installed, register the database and create two database devices and one database with a name of your choice.
Create a new table called Network_UsersNOTE: it must be called Network_Users.

The ODBC table should be in the following format.

   Table Name: Network_Users

   For an Access ODBC Source:

   Name          Type   Size

   UserName      Text    50
   Password      Text    64

For a SQL ODBC source:

   Name          Type     Size

   UserName      varchar   50
   Password      varchar   64

To register and configure an ODBC authentication server and Database, perform the following:

On the RADIUS Server, on the Authentication Providers tab, select ODBC Authentication, and then click Configure.
Enter a description of the authentication database in the Authentication database description box, and then click Configure Database.
On the Machine Data Source tab, verify that you have already configured a data source.

If you have already configured a data source, locate the data-source name and click OK.

-or-

If you are creating a new data source, click New and follow the Create New Data Source Wizard. Select the ODBC table Network_users_ that you set up in the previous steps.

The ODBC data source should be configured as a system Data Source Name (DSN). Users should now be able to log in through Radius via SQL Server.

NOTE: This article should be used as a guideline.

Keywords: kbhowto KB193127