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 Jens
thanks for quick respond , ok we made the changes on the offload folder to share everyone and give the permissions of read/write after that restarted the DMA and server but error still persist
2021-11-16 12:57:11.507|72|NonQuery 'BULK INSERT dataavg FROM '\\DMA-VM-LAB\Offload\dataavg\2021_10_28_21_50_45.csv' WITH (DATAFILETYPE='widechar', FIELDTERMINATOR = ' ')' failed. (code = 4861, message = Cannot bulk load because the file "\\DMA-VM-LAB\Offload\dataavg\2021_10_28_21_50_45.csv" could not be opened. Operating system error code 53(The network path was not found.).)
Hello, theres any other thing that we can review? the problem persist? Operating system error code 53(The network path was not found.)
When you ping from the MSSQL server to “DMA-VM-LAB”, does it succeed? If it doesn’t, but pinging the IP does, the cause is likely DNS related. If pinging both IP and hostname succeed, it could indicate File & Printer sharing is disabled. Then you can try enabling it using this guide: https://docs.microsoft.com/en-us/troubleshoot/windows-server/networking/system-error-51-53-access-shared-resources#resolution