This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
Error "Error opening connect string: Microsoft OLE...
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.
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
Alteryx Designer and Server
MS SQL Server
Data Input Tool
Microsoft OLE DB Provider for SQL Server
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.
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)