access is denied error 5 for network drive mapping ?

[ahmedbarbary]

I working on script running on sql server 2019 using python 3.10 .

I have directory path \\192.168.7.9\Import\8 as mapped network drive and can
write and read to files and delete and create files on this directory path \\192.168.7.9\Import\8.

my issue when run script python on sql server 2019 it give me error 5 access is denied
but it must return true because directory path exist.

this path have permissions everyone and administrator and system full control read and write and delete .

EXEC sp_execute_external_script
@language =N'Python',
@script=N'
import os
result = os.system("net use S: \\\\192.168.7.9\\Import\\8")
print("result =", result)
d = os.path.isdir("S:")
print("d =", d)'

Yoriz write Aug-14-2022, 09:22 AM:
Please post all code, output and errors (in their entirety) between their respective tags. Refer to BBCode help topic on how to post. Use the "Preview Post" button to make sure the code is presented as you expect before hitting the "Post Reply/Thread" button.