Just follow these steps from our Tech Support Team
Open SQL Management Studio and “New Query”
You only need to do this bit once:
EXEC sp_configure ‘show advanced options’, 1;
GO
RECONFIGURE;
GO
EXEC sp_configure ‘xp_cmdshell’,1
GO
RECONFIGURE
GO
Now define that share drive for SQL with the xp_cmdshell command as follows:
Changing H to whatever drive you require
EXEC XP_CMDSHELL ‘net use H: \RemoteServerNameShareName /USER:domainusername Passw0rd1’
It should now be mapped. In order to verify the new drive, you can use the below command that will show you all files in that newly mapped drive:
EXEC XP_CMDSHELL ‘Dir H:’ Last updated on 3 Dec 2020
1010 readsTell us what you think?10