Forum Discussion
nhaminger
Aug 17, 2021Copper Contributor
SQL Server 2019 External Scripts Network Drive Access Denied
Hello Community, so we are invoking a Python script with the sp_execute_external_script command. Within this Python script, we access files that are located on a network drive (r/w). This works w...
Ronen_Ariely
Oct 13, 2021MVP
Good daynhaminger,
There is a full discussion and explanation here:
https://docs.microsoft.com/en-us/answers/questions/518211/sql-server-2019-external-scripts-network-drive-acc.html
The short answer is that you need to give permission to the account which running the NT Service\MSSQLLaunchpad service. The Launchpad is a service that manages and executes external scripts.
- nhamingerOct 14, 2021Copper Contributor
Hi Ronen_Ariely , thank you for your answer. The discussion you linked was started by me and all the provided solutions were not working for me. It seems that those external script processes don't have the rights to access files on network drives for whatever reason.