Home

Share a folder between two Servers

%3CLINGO-SUB%20id%3D%22lingo-sub-753332%22%20slang%3D%22en-US%22%3EShare%20a%20folder%20between%20two%20Servers%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-753332%22%20slang%3D%22en-US%22%3E%3CH5%20id%3D%22toc-hId-1202896349%22%20id%3D%22toc-hId-1202896349%22%20id%3D%22toc-hId-1202896349%22%20id%3D%22toc-hId-1202896349%22%3EHello.%3C%2FH5%3E%3CH5%20id%3D%22toc-hId--1349260612%22%20id%3D%22toc-hId--1349260612%22%20id%3D%22toc-hId--1349260612%22%20id%3D%22toc-hId--1349260612%22%3EI%20have%20been%20pulling%20my%20hair%20out%20with%20this%2C%20and%20I%20may%20have%20found%20an%20answer%20in%20a%20previous%20conversation%20titled%20(sharing%20folders%2C%20NTFS%2Bshare%20permissions%20and%20the%20Everyone%20permission)%20But%20just%20looking%20for%20some%20alternative%20incase%20I%20am%20heading%20in%20the%20wrond%20direction.%20I%20have%20a%20Windows%20Server%202016%2C%20running%20Hyper%20V.%20I%20have%20Three%20servers%2C%20MySQL%2C%20MSSQL%20and%20Domain%20Controller%20with%20AD%2C%20they%20are%20setup%20like%20this.%3C%2FH5%3E%3CH5%20id%3D%22toc-hId-393549723%22%20id%3D%22toc-hId-393549723%22%20id%3D%22toc-hId-393549723%22%20id%3D%22toc-hId-393549723%22%3EComain%20Controller%3D%20192.168.0.3%3C%2FH5%3E%3CH5%20id%3D%22toc-hId-2136360058%22%20id%3D%22toc-hId-2136360058%22%20id%3D%22toc-hId-2136360058%22%20id%3D%22toc-hId-2136360058%22%3EMySQL%3D%20192.168.0.4%3C%2FH5%3E%3CH5%20id%3D%22toc-hId--415796903%22%20id%3D%22toc-hId--415796903%22%20id%3D%22toc-hId--415796903%22%20id%3D%22toc-hId--415796903%22%3EMSSQL%3D%20192.168.0.5%3C%2FH5%3E%3CH5%20id%3D%22toc-hId-1327013432%22%20id%3D%22toc-hId-1327013432%22%20id%3D%22toc-hId-1327013432%22%20id%3D%22toc-hId-1327013432%22%3ENow%20in%20the%20MySQL%20server%20I%20have%20a%20folder%20C%3A%5Csigs%20and%20I%20can%20access%20this%20folder%20from%20the%20MSSQL%20using%20%5C%5Cmysql%5Csigs%20and%20entering%20a%20username%20and%20password%2C%20but%20this%20is%20where%20I%20am%20failing.%20I%20need%20the%20MSSQL%20server%20to%20have%20complete%20access%20to%20the%20C%3A%5Csigs%20on%20the%20MySQL%20server%2C%20from%20even%20a%20restart%20without%20having%20anybody%20login%2C%20as%20the%20MSSQL%20server%20will%20be%20receiving%20csv%20files%20and%20then%20saving%20them%20in%20the%20MySQL%2C%20C%3A%5Csigs%20folder.%3C%2FH5%3E%3CH5%20id%3D%22toc-hId--1225143529%22%20id%3D%22toc-hId--1225143529%22%20id%3D%22toc-hId--1225143529%22%20id%3D%22toc-hId--1225143529%22%3EOnce%20it%20have%20saved%20them%2C%20it%20will%20then%20run%20a%20VBS%20file%20form%20the%20C%3A%5Csigs%20folder%20to%20import%20the%20CSV%20file%20into%20the%20MySQL%20database.%3C%2FH5%3E%3CH5%20id%3D%22toc-hId-517666806%22%20id%3D%22toc-hId-517666806%22%20id%3D%22toc-hId-517666806%22%20id%3D%22toc-hId-517666806%22%3ECan%20anybody%20please%20help%20me%20or%20give%20me%20an%20example%20of%20how%20to%20setup%20this%20folder%20correctly.%3C%2FH5%3E%3CH5%20id%3D%22toc-hId--2034490155%22%20id%3D%22toc-hId--2034490155%22%20id%3D%22toc-hId--2034490155%22%20id%3D%22toc-hId--2034490155%22%3EAt%20the%20present%20the%20servers%20are%20not%20in%20an%20operating%20environment%2C%20so%20I%20can%20delete%20and%20add%20whateve%20I%20need%20to%20get%20ti%20working.%3C%2FH5%3E%3CH5%20id%3D%22toc-hId--291679820%22%20id%3D%22toc-hId--291679820%22%20id%3D%22toc-hId--291679820%22%20id%3D%22toc-hId--291679820%22%3EMany%20Thanks%3C%2FH5%3E%3CH5%20id%3D%22toc-hId-1830060814%22%20id%3D%22toc-hId-1830060814%22%20id%3D%22toc-hId-1830060814%22%20id%3D%22toc-hId-1830060814%22%3EPaul.%3C%2FH5%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-753332%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EActive%20Directory%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EHyper-V%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ENetworking%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EWindows%20Server%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-753443%22%20slang%3D%22en-US%22%3ERe%3A%20Share%20a%20folder%20between%20two%20Servers%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-753443%22%20slang%3D%22en-US%22%3E%3CP%3E%3CEM%3E%3CFONT%20style%3D%22background-color%3A%20%23ffffff%3B%22%3EMySQL%3D%20192.168.0.4%3CBR%20%2F%3EMSSQL%3D%20192.168.0.5%3C%2FFONT%3E%3C%2FEM%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3CFONT%20style%3D%22background-color%3A%20%23ffffff%3B%22%3EAre%20these%20domain%20joined%3F%20May%20also%20want%20to%20verify%20active%20directory%20domain%20health%20and%20replication%20are%20100%25%3C%2FFONT%3E%3C%2FP%3E%0A%3CP%3E%3CFONT%20style%3D%22background-color%3A%20%23ffffff%3B%22%3E%26nbsp%3B%3C%2FFONT%3E%3C%2FP%3E%0A%3CP%3E%3CEM%3E%3CFONT%20style%3D%22background-color%3A%20%23ffffff%3B%22%3EI%20need%20the%20MSSQL%20server%20to%20have%20complete%20access%20to%20the%20C%3A%5Csigs%20on%20the%20MySQL%20server%3C%2FFONT%3E%3C%2FEM%3E%3C%2FP%3E%0A%3CP%3E%3CFONT%20style%3D%22background-color%3A%20%23ffffff%3B%22%3E%26nbsp%3B%3C%2FFONT%3E%3C%2FP%3E%0A%3CP%3E%3CFONT%20style%3D%22background-color%3A%20%23ffffff%3B%22%3EMore%20likely%20what%20you'll%20want%20is%20the%20service%20or%20job%20(SQL%20Agent%20job%3F%2C%20SSIS%20job%3F)%20to%20be%20configured%20using%20a%20domain%20account%20and%20give%20that%20domain%20account%20the%20required%20permissions%20to%20the%20network%20share.%3C%2FFONT%3E%3C%2FP%3E%0A%3CP%3E%3CFONT%20style%3D%22background-color%3A%20%23ffffff%3B%22%3E%26nbsp%3B%3C%2FFONT%3E%3C%2FP%3E%0A%3CP%3E%3CFONT%20style%3D%22background-color%3A%20%23ffffff%3B%22%3E%26nbsp%3B%3C%2FFONT%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E
PaulGrimes
Occasional Visitor
Hello.
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
MySQL= 192.168.0.4
MSSQL= 192.168.0.5
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.
Many Thanks
Paul.
1 Reply

MySQL= 192.168.0.4
MSSQL= 192.168.0.5

 

Are these domain joined? May also want to verify active directory domain health and replication are 100%

 

I need the MSSQL server to have complete access to the C:\sigs on the MySQL server

 

More likely what you'll want is the service or job (SQL Agent job?, SSIS job?) to be configured using a domain account and give that domain account the required permissions to the network share.

 

 

Related Conversations
Extentions Synchronization
Deleted in Discussions on
3 Replies
Tabs and Dark Mode
cjc2112 in Discussions on
36 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
29 Replies