Directory path display false as not exist although it exist with full control permission ?

[ahmedsa2018]

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

I have directory path \\192.168.7.9\Import\8 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 return false

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 .

script python

declare @ExportPath varchar(max)='\\192.168.7.9\Import\8'
EXEC sp_execute_external_script
@language =N'Python',
@script=N'
import os
d = os.path.isdir(ExportFilePath)
print(d)'
,@params = N'@ExportFilePath NVARCHAR(MAX)'
,@ExportFilePath = @ExportPath

Expected result is True

from sql server it return true as exist but from python script it return false for same server and same user.

 

[ahmedsa2018]

are need to add user name and password
to nert use command
or no need
if required how to add

 

[mikrom]

I don't know, how to set right permissions for your system (MS SQL server with Python)
But you asked this question on several other forums and I think you got the right answer here:

https://docs.microsoft.com/en-us/an...-directory-at-shared-path-remotely-it-di.html

 

[ahmedsa2018]

can you help me answer this question

if i use on python script as below
it will working
or no need to do that
i use code below to reach remote server

import paramiko

hostname = "your-hostname"
username = "your-username"
password = "your-password"
cmd = 'your-command'

try:
    ssh = paramiko.SSHClient()
    ssh.set_missing_host_key_policy(paramiko.AutoAddPolicy())
    ssh.connect(hostname,username=username,password=password)
    print("Connected to %s" % hostname)
except paramiko.AuthenticationException:
    print("Failed to connect to %s due to wrong username/password" %hostname)
    exit(1)
except Exception as e:
    print(e.message)    
    exit(2)

 

[ahmedsa2018]

i try now to use mape network drive
it give me error 5 access is denied
using code below

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)

so i try to using domain/account name
my question i need to ask is
can access direct to remote path without using map network drive
are this possible
if possible how to do using python

import paramiko

hostname = "your-hostname"
username = "your-username"
password = "your-password"
cmd = 'your-command'

try:
    ssh = paramiko.SSHClient()
    ssh.set_missing_host_key_policy(paramiko.AutoAddPolicy())
    ssh.connect(hostname,username=username,password=password)
    print("Connected to %s" % hostname)
except paramiko.AuthenticationException:
    print("Failed to connect to %s due to wrong username/password" %hostname)
    exit(1)
except Exception as e:
    print(e.message)    
    exit(2)

are code above allow to me export data directly from remote host
please help me