Error on installation of DMX pro - Bring2mind

Site
Web

Bring2mind Forums

Forums
Search Forum
Advanced SearchTopicsPosts

Prev Go to previous topic

Go to next topic

Forums Document Exchange Lite Installation and Activation Issues

Last Post 01/01/1900 12:00 AM by Anonymous

Error on installation of DMX pro

1 Replies

Sort:


You are not authorized to post a reply.

Author

Messages

Pedro Rivera

New Member
Posts:1

11/02/2005 2:38 AM
Hi everyone i install the DMX module i everything seems ok and on the installation log appears this error.... Im using the module and everything seems ok,,,, Did i miss something or is this ok?? Thanks...for the help Info Executing 03.01.05.SqlDataProvider StartJob Start Sql execution: 03.01.05.SqlDataProvider file Failure SQL Execution resulted in following Exceptions: System.Data.SqlClient.SqlException: EXECUTE permission denied on object 'sp_settriggerorder', database 'master', owner 'dbo'. at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteNonQuery(SqlConnection connection, CommandType commandType, String commandText, SqlParameter[] commandParameters) at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteNonQuery(String connectionString, CommandType commandType, String commandText, SqlParameter[] commandParameters) at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteNonQuery(String connectionString, CommandType commandType, String commandText) at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions) sp_settriggerorder 'dbo.DMX_Init', 'First', 'INSERT' EndJob End Sql execution: 03.01.05.SqlDataProvider file Info Executing 03.01.06.SqlDataProvider StartJob Start Sql eecution: 03.01.06.SqlDataProvider file EndJob End Sql execution: 03.01.06.SqlDataProvider file EndJob Finished Sql execution

Peter Donker

Veteran Member
Posts:4536

11/02/2005 7:41 AM
It appears your DNN SQL account does not have sufficient permissions to add triggers. I'm not aware that you could differentiate between being able to add tables and being able to add triggers, but this is what the error tells us. Not having the trigger (on the Portals table) in place means that newly created portals will not have a correctly functioning DMX. Peter

You are not authorized to post a reply.

Forums Document Exchange Lite Installation and Activation Issues

About Bring2mind

Bring2mind is the company of Peter Donker, a DotNetNuke enthusiast who has been involved with the platform from the very beginning. At the same time as the market for modules emerged, he realized there was no good document management solution for the platform yet and he set about creating this. In part he based the module on his experience with other document management systems he used while working as a researcher. His module, Document Exchange, was an instant success and has since become the premier document management solution for DotNetNuke. In 2004 he created Bring2mind as a vehicle for the module and is one of the few successful businesses solely based on a DotNetNuke product.

Contact Info

Please note we are located in Europe. Business hours are weekdays between 9 AM and 6 PM local time (Central European Time) which corresponds to 3 AM and noon EST.