Configuring Data Warehouse to not use trusted connection when running task via auto upload
Jump to navigation
Jump to search
Overview
With SQL Server, using Use Trusted Connection can be problematic when running the auto upload via the scheduled task as the user may be impersonated.
An impersonated user will not be the actual windows user account as specified in the scheduled task. Instead, it will appear as NT AUTHORITY\ANONYMOUS LOGON.
To resolve this issue, you will need to have a dedicated user added to SQL Server with a specific username and password and updated ODBClink's data warehouse to use this dedicated user.
To update the data warehouse, see Editing a data warehouse.