I have been pulling my hair out with this, and I may have found an answer in a previous conversation titled (sharing folders, NTFS+share permissions and the Everyone permission) But just looking for some alternative incase I am heading in the wrond direction. I have a Windows Server 2016, running Hyper V. I have Three servers, MySQL, MSSQL and Domain Controller with AD, they are setup like this.
Comain Controller= 192.168.0.3
Now in the MySQL server I have a folder C:\sigs and I can access this folder from the MSSQL using \\mysql\sigs and entering a username and password, but this is where I am failing. I need the MSSQL server to have complete access to the C:\sigs on the MySQL server, from even a restart without having anybody login, as the MSSQL server will be receiving csv files and then saving them in the MySQL, C:\sigs folder.
Once it have saved them, it will then run a VBS file form the C:\sigs folder to import the CSV file into the MySQL database.
Can anybody please help me or give me an example of how to setup this folder correctly.
At the present the servers are not in an operating environment, so I can delete and add whateve I need to get ti working.