Re: [Emerald] can't re-port or create the ServerAccess table
Dale E. Reed Jr. ( (no email) )
Fri, 09 Jul 1999 00:20:45 -0700
Josh Hillman wrote:
>
> I tried to re-port my Maxes in Emerald Admin under the Servers tab and I got
> the following message:
> Invalid object name: ServerAccess
>
> So, I then realized that our database is missing that table. I then tried
> to run the following to create it:
>
> /****** Object: Table dbo.ServerAccess Script Date: 11/22/95 9:30:47 PM
> ******/
> CREATE TABLE ServerAccess (
> ServerID int NOT NULL ,
> Port int NULL DEFAULT NULL ,
> AccountType varchar (15) NOT NULL ,
> StartTime int NULL DEFAULT (0),
> StopTime int NULL DEFAULT (0),
> MaxSessionLength int NULL DEFAULT (0),
> FOREIGN KEY (AccountType) REFERENCES AccountTypes (AccountType),
> FOREIGN KEY (ServerID) REFERENCES ServerPorts (ServerID)
This should be Servers not ServerPorts
> )
> GO
>
> I got the following error message:
> Msg 1776, Level 16, State 0
> There are no primary or candidate keys in the referenced table 'ServerPorts'
> that match the referencing column list in the foreign key
> 'FK__ServerAcc__Serve__3E723F9C'.
> Msg 1750, Level 16, State 0
> Unable to create constraint. See previous errors.
>
> What do I do?
>
> Emerald 2.5.278, Emerald Admin 2.5.288, SQL 6.5 SP5a
--
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