I am trying to install the trial version of AnnounceIT 40.02.15 and 16 on a localhost version of DNN 4.9.0.In both cases I get the following errors:

 

StartJob Start Sql execution: 40.01.29.SqlDataProvider file
Failure SQL Execution resulted in following Exceptions: System.Data.SqlClient.SqlException: There are no primary or candidate keys in the referenced table 'dbo.Modules' that match the referencing column list in the foreign key 'FK_spascoe_AnnounceIT_Modules'. Could not create constraint. See previous errors. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL) at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions) /************************************************************/ /***** SqlDataProvider *****/ /***** *****/ /***** *****/ /***** Note: To manually execute this script you must *****/ /***** perform a search and replace operation *****/ /***** for dbo. and *****/ /***** *****/ /************************************************************/ /** Create Table **/ if not exists (select * from dbo.sysobjects where id = object_id(N'dbo.[spascoe_AnnounceIT]') and OBJECTPROPERTY(id, N'IsTable') = 1) BEGIN CREATE TABLE dbo.[spascoe_AnnounceIT] ( [ItemId] [int] IDENTITY(1,1) NOT NULL, [ModuleId] [int] NOT NULL DEFAULT (0), [Content] [ntext] NOT NULL DEFAULT (''), [CreatedByUser] [int] NOT NULL DEFAULT (0), [CreatedDate] [datetime] NOT NULL, [Title] [nvarchar](150) NOT NULL DEFAULT (''), [CatID] [int] NOT NULL DEFAULT (0), [Summary] [ntext] NOT NULL DEFAULT (''), [isDeleted] [int] NOT NULL DEFAULT (0), [RemoveDate] [datetime] NULL, [UpdatedByUser] [int] NOT NULL DEFAULT (0), [UpdatedDate] [datetime] NULL, [ActiveFrom] [datetime] NULL, [ArchiveDate] [datetime] NULL ) ALTER TABLE dbo.[spascoe_AnnounceIT] ADD CONSTRAINT [PK_spascoe_AnnounceIT] PRIMARY KEY CLUSTERED ([ItemID]) CREATE NONCLUSTERED INDEX [IX_spascoe_AnnounceIT] ON dbo.[spascoe_AnnounceIT] ([ModuleID]) ALTER TABLE dbo.[spascoe_AnnounceIT] WITH NOCHECK ADD CONSTRAINT [FK_spascoe_AnnounceIT_Modules] FOREIGN KEY ([ModuleID]) REFERENCES dbo.[Modules] ([ModuleID]) ON DELETE CASCADE NOT FOR REPLICATION END System.Data.SqlClient.SqlException: There are no primary or candidate keys in the referenced table 'dbo.Modules' that match the referencing column list in the foreign key 'FK_spascoe_AnnounceITCategory_Modules'. Could not create constraint. See previous errors. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL) at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions) if not exists (select * from dbo.sysobjects where id = object_id(N'dbo.[spascoe_AnnounceITCategory]') and OBJECTPROPERTY(id, N'IsTable') = 1) BEGIN CREATE TABLE dbo.[spascoe_AnnounceITCategory] ( [CatID] [int] IDENTITY(1,1) NOT NULL, [CategoryTitle] [nvarchar](250) NOT NULL DEFAULT (''), [IconURL] [nvarchar](250) NOT NULL DEFAULT (''), [ModuleId] [int] NOT NULL DEFAULT (0), [CatOrder] [int] NOT NULL DEFAULT (0), [ParentId] [int] NOT NULL DEFAULT (0), [Level] [int] NOT NULL DEFAULT (0), [tbl] [nvarchar](350) NOT NULL DEFAULT (''), [tdHeader] [nvarchar](350) NOT NULL DEFAULT (''), [tdBody1] [nvarchar](350) NOT NULL DEFAULT (''), [tdBody2] [nvarchar](350) NOT NULL DEFAULT (''), [lnk1] [nvarchar](350) NOT NULL DEFAULT (''), [lnk2] [nvarchar](350) NOT NULL DEFAULT (''), [lnk3] [nvarchar](350) NOT NULL DEFAULT ('') ) ALTER TABLE dbo.[spascoe_AnnounceITCategory] ADD CONSTRAINT [PK_spascoe_AnnounceITCategory] PRIMARY KEY CLUSTERED ([CatID]) CREATE NONCLUSTERED INDEX [IX_spascoe_AnnounceITCategory] ON dbo.[spascoe_AnnounceITCategory] ([ModuleID]) ALTER TABLE dbo.[spascoe_AnnounceITCategory] WITH NOCHECK ADD CONSTRAINT [FK_spascoe_AnnounceITCategory_Modules] FOREIGN KEY ([ModuleID]) REFERENCES dbo.[Modules] ([ModuleID]) ON DELETE CASCADE NOT FOR REPLICATION END 
EndJob End Sql execution: 40.01.29.SqlDataProvider file

Thanks for any help.

John