Hi Guys,

Going to paste this error, it's long so I apologise now already. I get these error message when I try uploading modules for DNN 5.02.02.

I've used these modules in the past, Survey, Orizonti and telelriks's RadMenu and they have always worked. The only thing that's different this time around is that I have installed the latest version of DNN. So I am assuming the modules have not been upgraded yet then?

SQL Execution resulted in following Exceptions: System.Data.SqlClient.SqlException: CREATE TABLE permission denied in database 'MedicalAidCoZa'. 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) CREATE TABLE dbo.Orizonti_Newsletter_Newsletter ( [ID] [bigint] IDENTITY (1, 1) NOT NULL , [Subject] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL , [Content] [ntext] COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL , [ModuleID] [bigint] NOT NULL ) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY] System.Data.SqlClient.SqlException: CREATE TABLE permission denied in database 'MedicalAidCoZa'. 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) CREATE TABLE dbo.Orizonti_Newsletter_User ( [ID] [bigint] IDENTITY (1, 1) NOT NULL , [Email] [varchar] (75) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL , [FirstName] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL , [LastName] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL , [Active] [bit] NOT NULL , [ModuleID] [bigint] NOT NULL ) ON [PRIMARY] System.Data.SqlClient.SqlException: CREATE PROCEDURE permission denied in database 'MedicalAidCoZa'. 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) CREATE PROCEDURE dbo.Orizonti_Newsletter_NewsletterAdd @Subject varchar(50), @Content ntext, @ModuleID bigint AS INSERT INTO dbo.Orizonti_Newsletter_Newsletter ( [Subject], [Content], [ModuleID] ) VALUES ( @Subject, @Content, @ModuleID ) select SCOPE_IDENTITY() System.Data.SqlClient.SqlException: CREATE PROCEDURE permission denied in database 'MedicalAidCoZa'. 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) CREATE PROCEDURE dbo.Orizonti_Newsletter_NewsletterDelete @ID bigint AS DELETE FROM dbo.Orizonti_Newsletter_Newsletter WHERE [ID] = @ID System.Data.SqlClient.SqlException: CREATE PROCEDURE permission denied in database 'MedicalAidCoZa'. 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) CREATE PROCEDURE dbo.Orizonti_Newsletter_NewsletterGet @ID bigint AS SELECT [ID], [Subject], [Content], [ModuleID] FROM dbo.Orizonti_Newsletter_Newsletter WHERE [ID] = @ID System.Data.SqlClient.SqlException: CREATE PROCEDURE permission denied in database 'MedicalAidCoZa'. 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) CREATE PROCEDURE dbo.Orizonti_Newsletter_NewsletterList @moduleId int AS SELECT [ID], [Subject], [Content], [ModuleID] FROM dbo.Orizonti_Newsletter_Newsletter WHERE ModuleID = @moduleId System.Data.SqlClient.SqlException: CREATE PROCEDURE permission denied in database 'MedicalAidCoZa'. 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) CREATE PROCEDURE dbo.Orizonti_Newsletter_NewsletterUpdate @ID bigint, @Subject varchar(50), @Content ntext, @ModuleID bigint AS UPDATE dbo.Orizonti_Newsletter_Newsletter SET [Subject] = @Subject, [Content] = @Content, [ModuleID] = @ModuleID WHERE [ID] = @ID System.Data.SqlClient.SqlException: CREATE PROCEDURE permission denied in database 'MedicalAidCoZa'. 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) CREATE PROCEDURE dbo.Orizonti_Newsletter_UserAdd @Email varchar(75), @FirstName varchar(50), @LastName varchar(50), @Active bit, @ModuleID bigint AS INSERT INTO dbo.Orizonti_Newsletter_User ( [Email], [FirstName], [LastName], [Active], [ModuleID] ) VALUES ( @Email, @FirstName, @LastName, @Active, @ModuleID ) select SCOPE_IDENTITY() System.Data.SqlClient.SqlException: CREATE PROCEDURE permission denied in database 'MedicalAidCoZa'. 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) CREATE PROCEDURE dbo.Orizonti_Newsletter_UserDelete @ID bigint AS DELETE FROM dbo.Orizonti_Newsletter_User WHERE [ID] = @ID System.Data.SqlClient.SqlException: CREATE PROCEDURE permission denied in database 'MedicalAidCoZa'. 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) CREATE PROCEDURE dbo.Orizonti_Newsletter_UserGet @ID bigint, @Email VARCHAR(75), @ModuleID bigint AS IF @Email = 'none' BEGIN SET @Email = NULL END ELSE BEGIN SET @ID = NULL END IF @ModuleID = -1 BEGIN SET @ModuleID = NULL END SELECT [ID], [Email], [FirstName], [LastName], [Active], [ModuleID] FROM dbo.Orizonti_Newsletter_User WHERE ([ID] = @ID OR @ID IS NULL) AND ([Email] = @Email OR @Email IS NULL) AND ([ModuleID] = @ModuleID OR @ModuleID IS NULL) System.Data.SqlClient.SqlException: CREATE PROCEDURE permission denied in database 'MedicalAidCoZa'. 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) CREATE PROCEDURE dbo.Orizonti_Newsletter_UserList @moduleId int AS SELECT [ID], [Email], [FirstName], [LastName], [Active], [ModuleID] FROM dbo.Orizonti_Newsletter_User WHERE ModuleID = @moduleId System.Data.SqlClient.SqlException: CREATE PROCEDURE permission denied in database 'MedicalAidCoZa'. 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) CREATE PROCEDURE dbo.Orizonti_Newsletter_UserUpdate @ID bigint, @Email varchar(75), @FirstName varchar(50), @LastName varchar(50), @Active bit, @ModuleID bigint AS UPDATE dbo.Orizonti_Newsletter_User SET [Email] = @Email, [FirstName] = @FirstName, [LastName] = @LastName, [Active] = @Active, [ModuleID] = @ModuleID WHERE [ID] = @ID

Thanks! James

These are all errors when the installers go to create Tables and Stored Procedures.  This implies that you somehow do not have permission to do these operations on the database.  You'll need to check that your database user has correct permissions.

Also ... are you aware that DotNetNuke 5.2.2 has new requirements:  ASP.NET 3.5 SP1 and Sql Server 2005 or higher?  If your site doesn't meet those requirements, that could be the problem.

Thanks Joseph for the very quick turn around time. I will try and check everything you have told me to do.

Cheers,
James

It was the permissions on that database....thanks again Joseph!