Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Knowledge Base

Definitive answers from Designer Desktop experts.

Error "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..." when publishing to Alteryx Server.

Suskil
Alteryx
Alteryx
Created

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.pngimage.png 
  • Alteryx Designer and Server
    • 2022.1
  • 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