Re: [RadiusNT] Installing the SQL script for RadiusNT 2.5 or 3.0 fails
Dale E. Reed Jr. ( (no email) )
Thu, 30 Mar 2000 10:15:58 -0800
john wrote:
>
> 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?
The errors should not prevent anything from working. I'll looking at
getting a fixed script to support and the website.
--
Dale E. Reed Jr. Emerald and RadiusNT__________________________________________IEA Software, Inc. www.iea-software.com
For more information about this list (including removal) go to:http://www.iea-software.com/support/maillists/liststart