I am not able to connect to the WFGEN database even when the user is defined in WFGEN database as a valid user.
The user account may be missing certain permissions. Please make sure the following conditions are fulfilled.
In SQL Server Management Studio
- Under the "Security" --> "Logins" node, make sure the user account for the database connection is defined
- Right click on the user account and view Properties, look under "User Mapping". Make sure the WFGEN database is checked (i.e. user is mapped to the login for WFGEN database). If you are not able to map the selected user for the WFGEN database, try to delete this user from the WFGEN database --> "Security" --> "Users" list first. Once the user account is mapped, it should automatically appear under the database "WFGEN" --> "Security" --> "Users".
- Right click on the user from the WFGEN database user list and view properties, look under "General" and make sure the "Database role membership" has the proper role member(s) selected. To use the account for the WFGEN database connection string, it must have read and write permission. Preferably "db_owner" should be selected.