Workflow Service (.XAMLX) activation failed : Login to PersistenceStore failed Login failed for user 'DOMAIN\MACHINE$'.
-
Wednesday, June 22, 2011 1:36 PM
Hi,
I am trying to configure a Workflow Service (.XAMLX) that will simply receive Activities and run them through WorkflowApplication . This service is hosted through IIS 7 in Windows Server Enterprise without Hyper-V on AppFabric. This setup is in Webfarm scenario and best practices regarding security and domain user creation is adhered to.
The WorkflowService is hosted as Application in IIS 7 and runs under NetworkService account. In SQL Server PersistenceStore I've provided NetworkService the System.Activities.DurableInstancing.InstanceStoreUsers role membership. The service activation fails with following Error Log in Event Log:
WebHost failed to process a request. Sender Information: System.ServiceModel.Activation.HostedHttpRequestAsyncResult/53452236 Exception: System.ServiceModel.ServiceActivationException: The service '/PrecachingServices/PrecachingService.xamlx' cannot be activated due to an exception during compilation. The exception message is: The InstanceStore could not be initialized.. ---> System.ServiceModel.CommunicationException: The InstanceStore could not be initialized. ---> System.Runtime.DurableInstancing.InstancePersistenceCommandException: The execution of the InstancePersistenceCommand named {urn:schemas-microsoft-com:System.Activities.Persistence/command}CreateWorkflowOwner was interrupted by an error. ---> System.Data.SqlClient.SqlException: Cannot open database "FabricPersistenceStore" requested by the login. The login failed. Login failed for user 'OMAIN\MACHINE$'.This error baffles me, as why would a WorkflowService need access the persistence store, should not AppFabric configured accounts with appropriate services handle this.
Pleas help.
-Samir
