Hello all,
This is SQL script running on Windows server 2012 so we would need to enable xp_cmdshell (net use can’t be used in SQL scripts AFAIK). I would first map a network drive in windows to the Nethserver share , then in the SQL script connect to that mapped drive letter using xp_cmdshell. Then we would need another startup script in SQL to reconnect to the mapped drive (because xp_cmdshell is not persistent across restart). This is all doable but I thought if Nethserver could allow free access to anyone for this one particular share without credentials then I wouldn’t need to jump through these scripting hoops.
So what does Nethserver Guest access access and Everyone access mean on shared drives?
I’ll try and get a copy of the script from our DBA.
Thank you.