Workflow Soluiton

I have a project that validates just fine and publishes without incident. The problem that i am having is that afetr publishing the project to my NS 6.5 server, i get the following error...

Error Details

Error Message:
Login failed for user 'GPLADMIN\GPLWKFLW7$'.

Message Stack:
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) blah,blah, blah.........................

I would appreciate it if someone could give me guidance on getting this corrected.

P.S. I get errors also when i try to debug bfore publishing.

Something's having trouble connecting to a SQL database using integrated authentication. I can think of two things. 1st you have components that are connecting to a remote database or 2nd you have an SQL Exchange (not MS Exchange but the workflow persistence mechanism) . If the problem is with the workflow persistence connection you'd get this error on every workflow.

I could be wrong but it seems to be an error connecting to a remote SQL db because of the username. That looks like a machine name. IIS runs things as Network Service user by default and usually when Network Service can't access a local DB is says that in the error, like: Login failed for user 'Network Service'.  If you wanted to grant the  workflow machine (Network Service) access to a remote database then you'd grant <machinename>$ whatever permissions it needs in the remote db. http://msdn.microsoft.com/en-us/library/ff647402.aspx#paght000015_sqlserver
 

I was able to modify the web.config for the project and impersonate a user with rights and that worked fine on the first workflow dialog. The second workflow dialog component stalls out because once again it is looking for gpladmin\gplwkflw7$ which is a machine name.

I have tried adding it as you recommended from the article URL above but i doesn't accept it becuase it is a machine name and its not in AD.

Since SQL doesn't let you create logins directly from machine accounts you should create an AD or local group and create the login from the group.

I got it to work.  thanks for the help.