[RadiusNT] Installing the SQL script for RadiusNT 2.5 or 3.0 fails with erro

john ( john@voiceworks.com )
Thu, 30 Mar 2000 09:43:48 -0800

Good Morning,

Machine configuration:

Windows NT 4.0 Enterprise SP5
MS SQL 7.0 SP1 installed on drive "D"
The only databases on this machine are the defaults, with the exception of
the one I created specifically for this software package.

I have created a database called "RadiusNT" with initial size of 15MB for
data and 5MB for logs.

When I run the radiusnt.sql script, I receive the following error statements
for NT2.5:

Server: Msg 8140, Level 16, State 1, Line 1
More than one key specified in column level FOREIGN KEY constraint, table
'ServerAccess'.
Server: Msg 8111, Level 16, State 1, Line 1
Cannot define PRIMARY KEY constraint on nullable column in table
'ServerAccess'.
Server: Msg 1750, Level 16, State 1, Line 1
Could not create constraint. See previous errors.

Is there an updated script, or do I need to remove SP1 prior to attempting
to load the script?

Thanks
John Duffy

For more information about this list (including removal) go to:
http://www.iea-software.com/support/maillists/liststart