Workflow and ServiceDesk Community

Hi,

I have created a workflow project which goes threw debugging ok but when I publish and try to run it, it displays the application error page.  I can publish and run web form projects fine.  I have had a look at the logs and it looks like its something to do with the a username the project is using for an sql server.  But I don't really understand what sql server and thus don't know what credentuals to use or where to enter them.  The project log is below.

Thanks in advance for any help.

Warn,30 May 2013 15:56:46,No reporting message queue has been set for this project, so an error is forcing workflow to default to the LBME.ReportingQueue for process data.

Warn,30 May 2013 15:59:26,No reporting message queue has been set for this project, so an error is forcing workflow to default to the LBME.ReportingQueue for process data.

Error,04 June 2013 13:46:29,Error starting/continuing dialog model execution System.Data.SqlClient.SqlException: Login failed for user 'SQA\SQA-ALTIRIS-G$'.

   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.SqlInternalConnectionTds.CompleteLogin(Boolean enlistOK)

   at System.Data.SqlClient.SqlInternalConnectionTds.AttemptOneLogin(ServerInfo serverInfo, String newPassword, Boolean ignoreSniOpenTimeout, Int64 timerExpire, SqlConnection owningObject)

   at System.Data.SqlClient.SqlInternalConnectionTds.LoginNoFailover(String host, String newPassword, Boolean redirectedUserInstance, SqlConnection owningObject, SqlConnectionString connectionOptions, Int64 timerStart)

   at System.Data.SqlClient.SqlInternalConnectionTds.OpenLoginEnlist(SqlConnection owningObject, SqlConnectionString connectionOptions, String newPassword, Boolean redirectedUserInstance)

   at System.Data.SqlClient.SqlInternalConnectionTds..ctor(DbConnectionPoolIdentity identity, SqlConnectionString connectionOptions, Object providerInfo, String newPassword, SqlConnection owningObject, Boolean redirectedUserInstance)

   at System.Data.SqlClient.SqlConnectionFactory.CreateConnection(DbConnectionOptions options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningConnection)

   at System.Data.ProviderBase.DbConnectionFactory.CreatePooledConnection(DbConnection owningConnection, DbConnectionPool pool, DbConnectionOptions options)

   at System.Data.ProviderBase.DbConnectionPool.CreateObject(DbConnection owningObject)

   at System.Data.ProviderBase.DbConnectionPool.UserCreateRequest(DbConnection owningObject)

   at System.Data.ProviderBase.DbConnectionPool.GetConnection(DbConnection owningObject)

   at System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection)

   at System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory)

   at System.Data.SqlClient.SqlConnection.Open()

   at LogicBase.Core.Messaging.SqlExchange.CreateTables(String[] createDDL)

   at LogicBase.Core.Messaging.SqlExchange..ctor(SqlExchangeConfiguration config, String name)

   at LogicBase.Core.Messaging.SqlExchangeConfiguration.Create(String name)

   at LogicBase.Core.Messaging.MessageExchangeFactory.GetExchangeTarget(String name, Boolean internalRequest, NetworkCredential credential)

   at LogicBase.Core.Messaging.AliasConfiguration.Create(String name)

   at LogicBase.Core.Messaging.MessageExchangeFactory.GetExchangeTarget(String name, Boolean internalRequest, NetworkCredential credential)

   at LogicBase.Core.Messaging.MessageExchangeFactory.GetExchange(String name, Boolean internalRequest, NetworkCredential credential)

   at LogicBase.Core.Messaging.MessageExchangeFactory.GetExchange(String name)

   at LogicBase.Components.Default.ExchangeAdapters.LogicBaseExchangeStatusService.SetProperties(IData properties)

   at LogicBase.Core.Models.Workflow.WorkStatusServiceFactory.Setup(String typeName)

   at LogicBase.Core.Models.Workflow.WorkflowRuntimeSetup.Execute(AbstractOrchestrationProject project)

   at LogicBase.Core.ProjectRuntime.LoadProject()

   at LogicBase.Core.ProjectRuntime.get_Project()

   at LogicBase.Core.Models.Workflow.EmbeddedDialogModel.WorkflowDialogHTTPHandler.StartDialog(HttpContext context, DialogSession session)

   at LogicBase.Core.Models.Dialog.DialogHttpHandlerBase.System.Web.IHttpHandler.ProcessRequest(HttpContext context)

Warn,04 June 2013 13:55:08,No reporting message queue has been set for this project, so an error is forcing workflow to default to the LBME.ReportingQueue for process data.

Warn,04 June 2013 14:00:29,No reporting message queue has been set for this project, so an error is forcing workflow to default to the LBME.ReportingQueue for process data.

Error,04 June 2013 14:37:41,Error starting/continuing dialog model execution System.Data.SqlClient.SqlException: Login failed for user 'SQA\SQA-ALTIRIS-G$'.

   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.SqlInternalConnectionTds.CompleteLogin(Boolean enlistOK)

   at System.Data.SqlClient.SqlInternalConnectionTds.AttemptOneLogin(ServerInfo serverInfo, String newPassword, Boolean ignoreSniOpenTimeout, Int64 timerExpire, SqlConnection owningObject)

   at System.Data.SqlClient.SqlInternalConnectionTds.LoginNoFailover(String host, String newPassword, Boolean redirectedUserInstance, SqlConnection owningObject, SqlConnectionString connectionOptions, Int64 timerStart)

   at System.Data.SqlClient.SqlInternalConnectionTds.OpenLoginEnlist(SqlConnection owningObject, SqlConnectionString connectionOptions, String newPassword, Boolean redirectedUserInstance)

   at System.Data.SqlClient.SqlInternalConnectionTds..ctor(DbConnectionPoolIdentity identity, SqlConnectionString connectionOptions, Object providerInfo, String newPassword, SqlConnection owningObject, Boolean redirectedUserInstance)

   at System.Data.SqlClient.SqlConnectionFactory.CreateConnection(DbConnectionOptions options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningConnection)

   at System.Data.ProviderBase.DbConnectionFactory.CreatePooledConnection(DbConnection owningConnection, DbConnectionPool pool, DbConnectionOptions options)

   at System.Data.ProviderBase.DbConnectionPool.CreateObject(DbConnection owningObject)

   at System.Data.ProviderBase.DbConnectionPool.UserCreateRequest(DbConnection owningObject)

   at System.Data.ProviderBase.DbConnectionPool.GetConnection(DbConnection owningObject)

   at System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection)

   at System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory)

   at System.Data.SqlClient.SqlConnection.Open()

   at LogicBase.Core.Messaging.SqlExchange.CreateTables(String[] createDDL)

   at LogicBase.Core.Messaging.SqlExchange..ctor(SqlExchangeConfiguration config, String name)

   at LogicBase.Core.Messaging.SqlExchangeConfiguration.Create(String name)

   at LogicBase.Core.Messaging.MessageExchangeFactory.GetExchangeTarget(String name, Boolean internalRequest, NetworkCredential credential)

   at LogicBase.Core.Messaging.AliasConfiguration.Create(String name)

   at LogicBase.Core.Messaging.MessageExchangeFactory.GetExchangeTarget(String name, Boolean internalRequest, NetworkCredential credential)

   at LogicBase.Core.Messaging.MessageExchangeFactory.GetExchange(String name, Boolean internalRequest, NetworkCredential credential)

   at LogicBase.Core.Messaging.MessageExchangeFactory.GetExchange(String name)

   at LogicBase.Components.Default.ExchangeAdapters.LogicBaseExchangeStatusService.SetProperties(IData properties)

   at LogicBase.Core.Models.Workflow.WorkStatusServiceFactory.Setup(String typeName)

   at LogicBase.Core.Models.Workflow.WorkflowRuntimeSetup.Execute(AbstractOrchestrationProject project)

   at LogicBase.Core.ProjectRuntime.LoadProject()

   at LogicBase.Core.ProjectRuntime.get_Project()

   at LogicBase.Core.Models.Workflow.EmbeddedDialogModel.WorkflowDialogHTTPHandler.StartDialog(HttpContext context, DialogSession session)

   at LogicBase.Core.Models.Dialog.DialogHttpHandlerBase.System.Web.IHttpHandler.ProcessRequest(HttpContext context)

Error,04 June 2013 14:53:53,Error starting/continuing dialog model execution System.Data.SqlClient.SqlException: Login failed for user 'SQA\SQA-ALTIRIS-G$'.

   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.SqlInternalConnectionTds.CompleteLogin(Boolean enlistOK)

   at System.Data.SqlClient.SqlInternalConnectionTds.AttemptOneLogin(ServerInfo serverInfo, String newPassword, Boolean ignoreSniOpenTimeout, Int64 timerExpire, SqlConnection owningObject)

   at System.Data.SqlClient.SqlInternalConnectionTds.LoginNoFailover(String host, String newPassword, Boolean redirectedUserInstance, SqlConnection owningObject, SqlConnectionString connectionOptions, Int64 timerStart)

   at System.Data.SqlClient.SqlInternalConnectionTds.OpenLoginEnlist(SqlConnection owningObject, SqlConnectionString connectionOptions, String newPassword, Boolean redirectedUserInstance)

   at System.Data.SqlClient.SqlInternalConnectionTds..ctor(DbConnectionPoolIdentity identity, SqlConnectionString connectionOptions, Object providerInfo, String newPassword, SqlConnection owningObject, Boolean redirectedUserInstance)

   at System.Data.SqlClient.SqlConnectionFactory.CreateConnection(DbConnectionOptions options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningConnection)

   at System.Data.ProviderBase.DbConnectionFactory.CreatePooledConnection(DbConnection owningConnection, DbConnectionPool pool, DbConnectionOptions options)

   at System.Data.ProviderBase.DbConnectionPool.CreateObject(DbConnection owningObject)

   at System.Data.ProviderBase.DbConnectionPool.UserCreateRequest(DbConnection owningObject)

   at System.Data.ProviderBase.DbConnectionPool.GetConnection(DbConnection owningObject)

   at System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection)

   at System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory)

   at System.Data.SqlClient.SqlConnection.Open()

   at LogicBase.Core.Messaging.SqlExchange.CreateTables(String[] createDDL)

   at LogicBase.Core.Messaging.SqlExchange..ctor(SqlExchangeConfiguration config, String name)

   at LogicBase.Core.Messaging.SqlExchangeConfiguration.Create(String name)

   at LogicBase.Core.Messaging.MessageExchangeFactory.GetExchangeTarget(String name, Boolean internalRequest, NetworkCredential credential)

   at LogicBase.Core.Messaging.AliasConfiguration.Create(String name)

   at LogicBase.Core.Messaging.MessageExchangeFactory.GetExchangeTarget(String name, Boolean internalRequest, NetworkCredential credential)

   at LogicBase.Core.Messaging.MessageExchangeFactory.GetExchange(String name, Boolean internalRequest, NetworkCredential credential)

   at LogicBase.Core.Messaging.MessageExchangeFactory.GetExchange(String name)

   at LogicBase.Components.Default.ExchangeAdapters.LogicBaseExchangeStatusService.SetProperties(IData properties)

   at LogicBase.Core.Models.Workflow.WorkStatusServiceFactory.Setup(String typeName)

   at LogicBase.Core.Models.Workflow.WorkflowRuntimeSetup.Execute(AbstractOrchestrationProject project)

   at LogicBase.Core.ProjectRuntime.LoadProject()

   at LogicBase.Core.ProjectRuntime.get_Project()

   at LogicBase.Core.Models.Workflow.EmbeddedDialogModel.WorkflowDialogHTTPHandler.StartDialog(HttpContext context, DialogSession session)

   at LogicBase.Core.Models.Dialog.DialogHttpHandlerBase.System.Web.IHttpHandler.ProcessRequest(HttpContext context)

Error,04 June 2013 14:54:54,Error starting/continuing dialog model execution System.Data.SqlClient.SqlException: Login failed for user 'SQA\SQA-ALTIRIS-G$'.

   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.SqlInternalConnectionTds.CompleteLogin(Boolean enlistOK)

   at System.Data.SqlClient.SqlInternalConnectionTds.AttemptOneLogin(ServerInfo serverInfo, String newPassword, Boolean ignoreSniOpenTimeout, Int64 timerExpire, SqlConnection owningObject)

   at System.Data.SqlClient.SqlInternalConnectionTds.LoginNoFailover(String host, String newPassword, Boolean redirectedUserInstance, SqlConnection owningObject, SqlConnectionString connectionOptions, Int64 timerStart)

   at System.Data.SqlClient.SqlInternalConnectionTds.OpenLoginEnlist(SqlConnection owningObject, SqlConnectionString connectionOptions, String newPassword, Boolean redirectedUserInstance)

   at System.Data.SqlClient.SqlInternalConnectionTds..ctor(DbConnectionPoolIdentity identity, SqlConnectionString connectionOptions, Object providerInfo, String newPassword, SqlConnection owningObject, Boolean redirectedUserInstance)

   at System.Data.SqlClient.SqlConnectionFactory.CreateConnection(DbConnectionOptions options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningConnection)

   at System.Data.ProviderBase.DbConnectionFactory.CreatePooledConnection(DbConnection owningConnection, DbConnectionPool pool, DbConnectionOptions options)

   at System.Data.ProviderBase.DbConnectionPool.CreateObject(DbConnection owningObject)

   at System.Data.ProviderBase.DbConnectionPool.UserCreateRequest(DbConnection owningObject)

   at System.Data.ProviderBase.DbConnectionPool.GetConnection(DbConnection owningObject)

   at System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection)

   at System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory)

   at System.Data.SqlClient.SqlConnection.Open()

   at LogicBase.Core.Messaging.SqlExchange.CreateTables(String[] createDDL)

   at LogicBase.Core.Messaging.SqlExchange..ctor(SqlExchangeConfiguration config, String name)

   at LogicBase.Core.Messaging.SqlExchangeConfiguration.Create(String name)

   at LogicBase.Core.Messaging.MessageExchangeFactory.GetExchangeTarget(String name, Boolean internalRequest, NetworkCredential credential)

   at LogicBase.Core.Messaging.AliasConfiguration.Create(String name)

   at LogicBase.Core.Messaging.MessageExchangeFactory.GetExchangeTarget(String name, Boolean internalRequest, NetworkCredential credential)

   at LogicBase.Core.Messaging.MessageExchangeFactory.GetExchange(String name, Boolean internalRequest, NetworkCredential credential)

   at LogicBase.Core.Messaging.MessageExchangeFactory.GetExchange(String name)

   at LogicBase.Components.Default.ExchangeAdapters.LogicBaseExchangeStatusService.SetProperties(IData properties)

   at LogicBase.Core.Models.Workflow.WorkStatusServiceFactory.Setup(String typeName)

   at LogicBase.Core.Models.Workflow.WorkflowRuntimeSetup.Execute(AbstractOrchestrationProject project)

   at LogicBase.Core.ProjectRuntime.LoadProject()

   at LogicBase.Core.ProjectRuntime.get_Project()

   at LogicBase.Core.Models.Workflow.EmbeddedDialogModel.WorkflowDialogHTTPHandler.StartDialog(HttpContext context, DialogSession session)

   at LogicBase.Core.Models.Dialog.DialogHttpHandlerBase.System.Web.IHttpHandler.ProcessRequest(HttpContext context)

Error,04 June 2013 15:02:37,Error starting/continuing dialog model execution System.Data.SqlClient.SqlException: Login failed for user 'SQA\SQA-ALTIRIS-G$'.

   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.SqlInternalConnectionTds.CompleteLogin(Boolean enlistOK)

   at System.Data.SqlClient.SqlInternalConnectionTds.AttemptOneLogin(ServerInfo serverInfo, String newPassword, Boolean ignoreSniOpenTimeout, Int64 timerExpire, SqlConnection owningObject)

   at System.Data.SqlClient.SqlInternalConnectionTds.LoginNoFailover(String host, String newPassword, Boolean redirectedUserInstance, SqlConnection owningObject, SqlConnectionString connectionOptions, Int64 timerStart)

   at System.Data.SqlClient.SqlInternalConnectionTds.OpenLoginEnlist(SqlConnection owningObject, SqlConnectionString connectionOptions, String newPassword, Boolean redirectedUserInstance)

   at System.Data.SqlClient.SqlInternalConnectionTds..ctor(DbConnectionPoolIdentity identity, SqlConnectionString connectionOptions, Object providerInfo, String newPassword, SqlConnection owningObject, Boolean redirectedUserInstance)

   at System.Data.SqlClient.SqlConnectionFactory.CreateConnection(DbConnectionOptions options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningConnection)

   at System.Data.ProviderBase.DbConnectionFactory.CreatePooledConnection(DbConnection owningConnection, DbConnectionPool pool, DbConnectionOptions options)

   at System.Data.ProviderBase.DbConnectionPool.CreateObject(DbConnection owningObject)

   at System.Data.ProviderBase.DbConnectionPool.UserCreateRequest(DbConnection owningObject)

   at System.Data.ProviderBase.DbConnectionPool.GetConnection(DbConnection owningObject)

   at System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection)

   at System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory)

   at System.Data.SqlClient.SqlConnection.Open()

   at LogicBase.Core.Messaging.SqlExchange.CreateTables(String[] createDDL)

   at LogicBase.Core.Messaging.SqlExchange..ctor(SqlExchangeConfiguration config, String name)

   at LogicBase.Core.Messaging.SqlExchangeConfiguration.Create(String name)

   at LogicBase.Core.Messaging.MessageExchangeFactory.GetExchangeTarget(String name, Boolean internalRequest, NetworkCredential credential)

   at LogicBase.Core.Messaging.AliasConfiguration.Create(String name)

   at LogicBase.Core.Messaging.MessageExchangeFactory.GetExchangeTarget(String name, Boolean internalRequest, NetworkCredential credential)

   at LogicBase.Core.Messaging.MessageExchangeFactory.GetExchange(String name, Boolean internalRequest, NetworkCredential credential)

   at LogicBase.Core.Messaging.MessageExchangeFactory.GetExchange(String name)

   at LogicBase.Components.Default.ExchangeAdapters.LogicBaseExchangeStatusService.SetProperties(IData properties)

   at LogicBase.Core.Models.Workflow.WorkStatusServiceFactory.Setup(String typeName)

   at LogicBase.Core.Models.Workflow.WorkflowRuntimeSetup.Execute(AbstractOrchestrationProject project)

   at LogicBase.Core.ProjectRuntime.LoadProject()

   at LogicBase.Core.ProjectRuntime.get_Project()

   at LogicBase.Core.Models.Workflow.EmbeddedDialogModel.WorkflowDialogHTTPHandler.StartDialog(HttpContext context, DialogSession session)

   at LogicBase.Core.Models.Dialog.DialogHttpHandlerBase.System.Web.IHttpHandler.ProcessRequest(HttpContext context)

Error,04 June 2013 15:06:50,Error starting/continuing dialog model execution System.Data.SqlClient.SqlException: Login failed for user 'SQA\SQA-ALTIRIS-G$'.

   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.SqlInternalConnectionTds.CompleteLogin(Boolean enlistOK)

   at System.Data.SqlClient.SqlInternalConnectionTds.AttemptOneLogin(ServerInfo serverInfo, String newPassword, Boolean ignoreSniOpenTimeout, Int64 timerExpire, SqlConnection owningObject)

   at System.Data.SqlClient.SqlInternalConnectionTds.LoginNoFailover(String host, String newPassword, Boolean redirectedUserInstance, SqlConnection owningObject, SqlConnectionString connectionOptions, Int64 timerStart)

   at System.Data.SqlClient.SqlInternalConnectionTds.OpenLoginEnlist(SqlConnection owningObject, SqlConnectionString connectionOptions, String newPassword, Boolean redirectedUserInstance)

   at System.Data.SqlClient.SqlInternalConnectionTds..ctor(DbConnectionPoolIdentity identity, SqlConnectionString connectionOptions, Object providerInfo, String newPassword, SqlConnection owningObject, Boolean redirectedUserInstance)

   at System.Data.SqlClient.SqlConnectionFactory.CreateConnection(DbConnectionOptions options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningConnection)

   at System.Data.ProviderBase.DbConnectionFactory.CreatePooledConnection(DbConnection owningConnection, DbConnectionPool pool, DbConnectionOptions options)

   at System.Data.ProviderBase.DbConnectionPool.CreateObject(DbConnection owningObject)

   at System.Data.ProviderBase.DbConnectionPool.UserCreateRequest(DbConnection owningObject)

   at System.Data.ProviderBase.DbConnectionPool.GetConnection(DbConnection owningObject)

   at System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection)

   at System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory)

   at System.Data.SqlClient.SqlConnection.Open()

   at LogicBase.Core.Messaging.SqlExchange.CreateTables(String[] createDDL)

   at LogicBase.Core.Messaging.SqlExchange..ctor(SqlExchangeConfiguration config, String name)

   at LogicBase.Core.Messaging.SqlExchangeConfiguration.Create(String name)

   at LogicBase.Core.Messaging.MessageExchangeFactory.GetExchangeTarget(String name, Boolean internalRequest, NetworkCredential credential)

   at LogicBase.Core.Messaging.AliasConfiguration.Create(String name)

   at LogicBase.Core.Messaging.MessageExchangeFactory.GetExchangeTarget(String name, Boolean internalRequest, NetworkCredential credential)

   at LogicBase.Core.Messaging.MessageExchangeFactory.GetExchange(String name, Boolean internalRequest, NetworkCredential credential)

   at LogicBase.Core.Messaging.MessageExchangeFactory.GetExchange(String name)

   at LogicBase.Components.Default.ExchangeAdapters.LogicBaseExchangeStatusService.SetProperties(IData properties)

   at LogicBase.Core.Models.Workflow.WorkStatusServiceFactory.Setup(String typeName)

   at LogicBase.Core.Models.Workflow.WorkflowRuntimeSetup.Execute(AbstractOrchestrationProject project)

   at LogicBase.Core.ProjectRuntime.LoadProject()

   at LogicBase.Core.ProjectRuntime.get_Project()

   at LogicBase.Core.Models.Workflow.EmbeddedDialogModel.WorkflowDialogHTTPHandler.StartDialog(HttpContext context, DialogSession session)

   at LogicBase.Core.Models.Dialog.DialogHttpHandlerBase.System.Web.IHttpHandler.ProcessRequest(HttpContext context)

No immediate help here, but a suggestion or two. Drop some create log entry components before your first form builder component so that you can see what, if anything is succeeding before you get to an error. This will help find which component is actually generating that error. Could you post a screen shot of the beginning of the model that is causing the error? Also, check your projects properties (specifically the properties tab) and see if there are any sql connection strings there. Lastly, all workflow projects need connections to the workflow DB, so is it possible that your location for debugging is connecting to a different workflow DB than your server for publishing? If so, maybe the same username isn't authorized on the publishing server.

Take a look at what account your Application pool is running under in IIS. More then likely your app pools is using a system account and not you applicatoin id.  Once you've changed the Application pool to be running under the application id account the errors accessing SQL should go away.

Depending on how the workflow is configured this may work if you don't have or can't run your appPool as domain account directly. 

Go to settings from Task Tray Tool

Click on "..." next to Workflow Server Setup

Under Webservice Auto Invoke - check box by "HTTP Authentication"

Put in the user name and password of a service account that has rights to the database.

   - Sometimes it only works without DOMAIN\UserID and only as USERID

Restart Server Extensions

Please only do this in a development environment!

Hi,

Thanks TGiles I've looked into it and the workflow was running under the defaultAppPool I've tried it with the NewWorkflow pool and the classic .Net none of seem allow the workflow to work. :(

TGiles is correct.

You need to change the identity of your Classic .Net App Pool and DefaultAppPool to use a service account. I would also confirm that your Symantec Workflow Server Service (On your Workflow Server) is running as the Service account.

The service account should have local admin on your Workflow Server, as well as permissions to read/write to your database via security logins on your SQL server.

Thanks to TGilies and HarrisT, got this working after getting aa service account for it.

Thanks