How to allow sql server 2019 to access maped network drive ?

Question

I work on sql server 2019 i create maped drive with letter S and on same server 7.7 i make mapped network drive S
but can't access to this drive
so how to access it please

i try as following
EXEC xp_cmdshell
'S: \\192.168.7.7\ExportExcel SM@trkrish /USER:******@z2data.com /PERSISTENT:yes'

and give me result

output  
The system cannot find the drive specified.  
NULL  

why it show drive not found The system cannot find the drive specified

i can open maped network drive and write to it and read it manually
but from sql server it not working
so what i do please to solve issue

Answer 1

Hi @ahmed salah ,

There is some mistakes in your command, please refer to below command to adjust your command.

EXEC xp_cmdshell ‘net use <driver letter> \\<servername>\<sharename> /user:<username> <password>’  

For example:

You can write the above statement as follows:

EXEC xp_cmdshell 'net use z: \192.168.1.1\shareddrive /user:YOURUSERNAME PASSWORD'

Once you run the above code it will map your shared folder share drive from the server 192.168.1.1 to the local system as a Z: drive.

---

If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

Answer 2

Disk mappings are per login session. So your personal mappings are unknown to SQL Server.

Thus, if you want to use the mapped drive, you need to map it from inside SQL Server:

   EXEC xp_cmdshell 'NET USE P: \\SUVEMETS\C /USER:user YourPassword'  

But beware that this permits all users on the server to access the share with your credentials.