Error SQLDriverConnect: Login failed for use

Question

I have a couple of users that have read only permissions to access a SQL server, but have not been able to run a gallery workflow that accesses that data because of the following error:

Error SQLDriverConnect: [Microsoft][ODBC SQL Server Driver][SQL Server]Login Failed for user.  [Microsoft][ODBC Driver Manager] Driver's SQLSetConnectAttr failed

The user is able to log into the gallery using Windows Authentication.  I am double checking her permissions to access the data, but other than that I can't tell what is causing the error.

patrick_mcauliffe · Answer

@mmcgarry have you tried asking the SQL Server DBA for more detailed logs?

mmcgarry · Answer

No, all workflows on the gallery require credentials for the workflow to use instead of service credentials.  The user inputs those in at the time they run it.

patrick_mcauliffe · Answer

@mmcgarry does the Gallery’s service account have the same level of access?