Hello,
we recently moved our databases to another server by using a nintex manual (http://nintexdownload.com/Nsupport/Moving_NW2010db.pdf).
We also set an alias via cliconfg.
Everything seems to work, but existing workflows don't start.
New workflows in the same website collection work properly.
I've installed the newest Version of Nintex Workflows 2010 (2.5.8.0), but the behavior didn't change.
The following errors pop up in the log:
- Error establishing database connection. SQL Error: 229.: System.Data.SqlClient.SqlException: The EXECUTE permission was denied on the object 'DirectInsertWorkflowInstance', database 'NW2010DB_qmportal_qm_gesamt', schema 'dbo'. at System.Data.SqlClient.SqlConnection.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.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString) at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at Nintex.Workflow.Administration.Database.ExecuteNonQuery(SqlCommand command, Boolean useTransaction) (Build:2580)
- Failed to create non existing workflow instance (Instance Id: c94f8c72-5c1e-4375-9ea7-8d28ff4b186f) from HistoryEventReceiver: System.Data.SqlClient.SqlException: The EXECUTE permission was denied on the object 'DirectInsertWorkflowInstance', database 'NW2010DB_qmportal_qm_gesamt', schema 'dbo'. at System.Data.SqlClient.SqlConnection.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.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString) at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at Nintex.Workflow.Administration.Database.ExecuteNonQuery(SqlCommand command, Boolean useTransaction) at Nintex.Workflow.Runtime.WorkflowInstance.DirectInsertWorkflowInstance(SPWorkflow workflow) at Nintex.Workflow.Features.WorkflowHistoryEventReciever.ItemAdded(SPItemEventProperties properties) (Build:2580)
Do you have any suggestions?
Thank you in advance!
