When i try to run a workflow where data source is connected to a database locally, it is running good, when i publish it to the gallery it is giving error Error: Input Data (1): Error opening connect string: Microsoft OLE DB Provider for SQL Server: Login failed for user 'ABCD'.\42000 = 18456 ' .While publishing i did not change any Set Workflow credentials option .
How is your SQL server configured for authentication? Is it SSO? In that case the service account that runs the Alteryx service will need at least Select access in SQL server? Check with your Alteryx Admin to find out the service account
Dan