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

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


For more information about this list (including removal) go to: