Hi team
we configured a new central database (MSSQL) on our DMA, we used an UDL tool to check connections and it succeded, we checked ports and all seems to respond but we are getting the next error on SLDatabase[SLDataGateway], permition were given on database server , is there any configuration we still need to do on DMA server?
2021-11-16 08:01:38.269|86|NonQuery 'BULK INSERT dataavg FROM '\\DMA-VM-LAB\Offload\dataavg\2021_10_28_21_10_38_4432.csv' WITH (DATAFILETYPE='widechar', FIELDTERMINATOR = ' ')' failed. (code = 4861, message = Cannot bulk load because the file "\\DMA-VM-LAB\Offload\dataavg\2021_10_28_21_10_38_4432.csv" could not be opened. Operating system error code 53(The network path was not found.).)
Hi Edgar,
The MSSQL database server will need read (possibly even write) permission on the \\DMA-VM-LAB\Offload folder. It's also required that this folder is shared. See this help page for more information.