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.
@mmcgarry does the Gallery’s service account have the same level of access?
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.
@mmcgarry have you tried asking the SQL Server DBA for more detailed logs?