Write, Bureaucrats, Administrators
1,349
edits
Difference between revisions of "Configuring Data Warehouse to not use trusted connection when running task via auto upload"
Configuring Data Warehouse to not use trusted connection when running task via auto upload (view source)
Revision as of 18:57, 28 June 2020
, 18:57, 28 June 2020no edit summary
(Created page with "== 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. A...") |
|||
| Line 7: | Line 7: | ||
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 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 | To update the [[Data Warehouse]], see [[Editing a data warehouse]]. | ||
== Related Topics == | == Related Topics == | ||
* [[Editing | * [[Editing a data warehouse]] | ||
* [[Troubleshooting Auto Upload]] | * [[Troubleshooting Auto Upload]] | ||