Community Forums
Results 1 to 2 of 2

Thread: DB Driven data element

  1. #1
    Join Date
    May 2010
    Location
    Rochester, NY
    Posts
    51

    DB Driven data element

    I'm trying to create a DB Driven data element in WFM 2016. I set up the external data source using my login credentials. From the WFM server, I can open SQL Management Studio, connect to the external database and run queries. The data element in the workflow returns no records and the following error appears in the log file:

    Error: GetDynamicList applicationID:8088565c-4483-4b7d-852d-7ffdcb0b0d1f, dataMinorID:f162ec46-a014-4c95-bee9-104de69de6a4, err:Login failed for user 'E600016'.

    Since I can connect directly from this server, how do I determine what is causing the login to fail within WFM?

  2. #2
    Join Date
    Oct 2007
    Location
    Schaumburg, IL
    Posts
    318
    Hi Ken,

    Are you using a Sql server user or a windows user? The easiest way to identify this is by looking at the username format - if it is just username, then it is sql server. And if it is domain\username, it is a windows user. WFM only supports a sql server user for now.

    Hope this helps.

    Thanks!
    Alpesh
    Flexera Software Technical Support

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •