Environment Details
Workflow includes an OLEDB connection to Microsoft SQL Server. Windows authentication is used to login to the database and the workflow executes successfully when run in local Designer. However, when the workflow is published to the Alteryx Server, the following error occurs during validation:
Error opening connect string: Microsoft OLE DB Provider for SQL Server: Login failed. The login is from an untrusted domain and cannot be used with Windows authentication.\42000=18452
image.png
- Alteryx Designer and Server
- MS SQL Server
- Data Input Tool
- Microsoft OLE DB Provider for SQL Server
- Windows Authentication
Cause
Workflows are being run on the Alteryx Server as the server's Local System account, but the account does not have permissions to connect to the database.
Resolution
In order for the workflow to be run on the server, it's necessary for the windows account at runtime to have permissions to access the database. This can be achieved by:
- Give the Local System account access to database or
- Apply the required credentials when publishing (needs Workflow Credentials Setting option set on server. Please review Additional Resources below) or
- Implement a 'Run As User' on the server, and ensure that user has permissions to access the database (Please review Additional Resources below)
Additional Resources