Hi!
I´m having problems getting a scheduled task to run with a service account. I get the following error:
2020-12-04 10:33:51| 0.7| 0.0|INFORM|Microsoft SQL Server Spatial Reader: Opening `omnia_' for read operation
2020-12-04 10:33:51| 0.7| 0.0|INFORM|Microsoft SQL Server Spatial Reader: Trying to connect using Microsoft OLE DB Driver for SQL Server...
2020-12-04 10:33:52| 1.0| 0.3|WARN |Microsoft SQL Server Spatial Reader: Failed to connect using Microsoft OLE DB Driver for SQL Server. Provider error '(-2146824582) Det gick inte att hitta den angivna providern. Den kanske inte är ordentligt installerad.'. Connection string 'Provider=MSOLEDBSQL;DataTypeCompatibility=80;Data Source=;Initial Catalog=omnia_;User ID=;Password=********'
2020-12-04 10:33:52| 1.0| 0.0|INFORM|Microsoft SQL Server Spatial Reader: Trying to connect using SQL Server 2012 Native Client...
2020-12-04 10:33:52| 1.0| 0.0|WARN |Microsoft SQL Server Spatial Reader: Failed to connect using SQL Server 2012 Native Client. Provider error '(-2147217843) Invalid authorization specification'. Connection string 'Provider=SQLNCLI11;DataTypeCompatibility=80;Data Source=;Initial Catalog=omnia_;User ID=;Password=********'
2020-12-04 10:33:52| 1.0| 0.0|ERROR |Failed to open reader
I have tried some measures such as making the connection public, logging in with the service account and starting FME. It works if i use a regular account (the account that created the workspace)
What seems to be the resolution to this issue?