Workflow Soluiton

I have copied some Workflows to a newly created SMP/Workflow server.   This is a new instance of the SMP which is separated from my existing instance. 

After making the configuration changes to point to the appropriate servers and databases, I am able to run the workflows in Debug mode.  When I publish them to IIS and try to run them through Internet Explorer I get an error on the database access.  The error message is shown below:

The error message is : Cannot open database "Symantec_CMDB" requested by the login. The login failed. Login failed for user 'IIS APPPOOL\Classic .NET AppPool'.

Can anyone suggest a resolution for this issue?

When workflows run in debug, they run in the context of the logged-in user. This logged-in user has an associated login with SQL it appears.

When workflows run deployed, they run in the context of the user associated with the app pool it is published under. In your case, it's Classic .NET AppPool. I'd verify there's a login associated with this user on SQL Server, or change the user identity of the app pool.

I found an article that included instructions for updating settings in IIS.  The Default Web Site --> Authentication --> Windows Authentication was Enabled.  After that, the Identity parameter associated with the Classic .Net AppPool Application Pool was changed to specify the local account used by the SMP.

With these two changes in place I can now access the CMDB.