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.
Hi Jens
the server is a windows server 2012 R2 we checked the part of network connections and adapter, we only have 1 ethernet connection active, we checked the sharing tab on properties and it was enabled , for the ping part by the moment is not allowed on the network firewall on either side is this necesary to fully complete connection? we also added the IP and hostname from database server on hosts file on dataminer server
I’d also verify port 1433 is open (MSSQL)
Yes all port are responding from telnet , 1433 , 445, 139
When you do NSLOOKUP DMA-VM-LABOffload on the MSSQL server, does that work?
Hi guys we managed to complete the communication between server through 445 and 139 enabling the next grthe guest user account and policy and Restrict NTLM: Outgoing NTLM traffic traffic to remote servers
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.).)
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
Hello, theres any other thing that we can review? the problem persist? Operating system error code 53(The network path was not found.)
Ping is no required, I only mentioned it to verify if there are no connectivity problems between the MSSQL server and the DataMiner server. Can you open the Shared folder (on the MSSQL machine) by using the File Explorer on this path \DMA-VM-LABOffload ? (Maybe also try by opening \Offload)
It’s also possible the file-sharing ports are blocked on the firewall between the two servers, can you verify port 445 and 139 are allowed?