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
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
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?