Running a process (*.fmw) on windows scheduler. Getting the following error:
"Microsoft SQL Server Non-Spatial Reader: Trying to connect using SQL Server 2012 Native Client...
2017-10-13 11:51:03| 2.7| 0.1|ERROR |Microsoft SQL Server Non-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=RPT;User ID=;Password=********'
2017-10-13 11:51:03| 2.7| 0.0|INFORM|Microsoft SQL Server Non-Spatial Reader: Trying to connect using SQL Server 2008 Native Client...
2017-10-13 11:51:03| 2.7| 0.0|ERROR |Microsoft SQL Server Non-Spatial Reader: Failed to connect using SQL Server 2008 Native Client. Provider error '(-2146824582) Provider cannot be found. It may not be properly installed.'. Connection string 'Provider=SQLNCLI10;DataTypeCompatibility=80;Data Source=;Initial Catalog=RPT;User ID=;Password=********'
2017-10-13 11:51:03| 2.7| 0.0|ERROR |Failed to open reader".
I have changed the default path to a shared directory and made database connections (reader and writer) public. The process works successfully on workbench but not on scheduler. What are other options to resolve this?
I also scheduled using the following batch file but that too fails:
rem #runas ms/omp_queries or it will not connect. (uses windows auth to DB's)
>>logfile.log 2>&1 (
echo %date% %time% - running data last 7 days insert
"E:\\Program Files\\FME\\fme.exe" E:\\GP\\FME\\Workbench.fmw --SourceDataset_MSSQL_ADO "RPT" --DestDataset_MSSQL_ADO "RPT_Writer" --SourceDataset_MSSQL_ADO_3 "RPT_Reader")
>>logfile.log 2>&1 (
echo %date% %time% - Completed all items
)
