How to Set Up Radius Server with ODBC Authentication

ID: Q193127

The information in this article applies to:

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

SUMMARY

This article describes how to set up Microsoft Internet Authentication Server (also known as Microsoft 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, choose 850multi-lingual.

For Sort-Order, choose Alternative Directory Order, Case-Insensitive.

For Network Options, choose 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_Users" (NOTE: 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, click the Authentication Providers tab.

Select ODBC Authentication and click Configure.

Enter a description of the authentication database in the Authentication database description box and click Configure Database.

Click the Machine Data Source tab and 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. Choose 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          : 
Version           : WINNT:1.0,2.0,4.0
Platform          : winnt 
Issue type        : kbhowto

Last Reviewed: April 29, 1999