[Emerald] can't re-port or create the ServerAccess table

Josh Hillman ( (no email) )
Wed, 7 Jul 1999 08:29:42 -0400

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)
)
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

Josh

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