How to change service lanuch pad from D drive to C driver ?

ahmed salah 3,216 Reputation points
2022-11-09T21:20:18.253+00:00

I working on sql server 2019 i face issue
access is denied when access shared path by python from sql server 2019
i try more time and more monthes
but i not reach to solving that
what i found is
launchpad service path exist on
D:\SQL Data\MSSQL15.MSSQLSERVER\MSSQL\Binn\launchpad.exe" -launcher RLauncher.dll -launcher Pythonlauncher.dll -launcher commonlauncher.dll -pipename sqlsatellitelaunch -timeout 600000 -logPath "D:\SQL Data\MSSQL15.MSSQLSERVER\MSSQL\LOG\ExtensibilityLog" -workingDir "D:\SQL Data\MSSQL15.MSSQLSERVER\MSSQL\ExtensibilityData" -externalLanguagesTempDir "D:\SQL Data\MSSQL15.MSSQLSERVER\MSSQL\ExternalLanguagesTemp" -externalLanguagesDir "D:\SQL Data\MSSQL15.MSSQLSERVER\MSSQL\ExternalLanguages" -externalLibrariesTempDir "D:\SQL Data\MSSQL15.MSSQLSERVER\MSSQL\ExternalLibrariesTemp" -externalLibrariesDir "D:\SQL Data\MSSQL15.MSSQLSERVER\MSSQL\ExternalLibraries" -satelliteDllPath "D:\SQL Data\MSSQL15.MSSQLSERVER\MSSQL\Binn\sqlsatellite.dll
and i install operationg system on c drive
so are this may be issue that prevent access shared path

i give access shared folder all packages and every one
and not working 

EXECUTE sp_execute_external_script  
@language = N'Python',  
@script = N'import pandas as pd  
df = pd.read_excel(r"\\192.168.7.7\ExportExcel\testData.xlsx", sheet_name = "Sheet1")  
print(df)';
SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,713 questions
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,453 questions
Transact-SQL
Transact-SQL
A Microsoft extension to the ANSI SQL language that includes procedural programming, local variables, and various support functions.
4,552 questions
0 comments

2 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Erland Sommarskog 101K Reputation points MVP
    2022-11-09T22:45:54.523+00:00

    No, whether it is installed on the C: or D: drive does not matter. The problem is that the Launchpad service run under a local machine account which is not on the machine that is hosting the file share.

    You could grant access to the machine account for the SQL Server machine, that is, DOMAIN\MACHINE$, but I an not sure that this is a goo idea.

  2. YufeiShao-msft 7,056 Reputation points
    2022-11-10T07:49:52.023+00:00

    Hi @ahmed salah ,

    External Python scripts only have read access permission to their working directories, if you want to access to any other directory, you need give either read & execute and/or write permissions to NT Service\MSSQLLaunchpad service user account and ALL APPLCATION PACKAGES on this directory

    Please refer to this doc:
    SQL Server on Windows: Isolation changes for Machine Learning Services

    In File Explorer, right click on the folder you want to use as working directory, and select Properties.
    Select Security and click Edit... to change permissions.
    Click Add...
    Make sure the From this location is the local computer name.
    Enter ALL APPLICATION PACKAGES in Enter the object names to select and click Check Names. Click OK.
    Select Read & execute under the Allow column.
    Select Write under the Allow column, if you want to grant write permissions.
    Click OK and OK.

    -------------

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

    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.