通过SQL Server Agent执行Python脚本时导入typing_extensions遭遇PermissionError的问题求助
通过SQL Server Agent执行Python脚本时导入typing_extensions遭遇PermissionError的问题求助
我最近碰到个头疼的问题:在PyCharm里和直接用命令行跑Python脚本都没问题,但把它放到SQL Server Agent里当作业执行时,就弹出了PermissionError,卡在导入typing_extensions这一步。
具体错误信息
Traceback (most recent call last): File "C:\Users\Kevin\Desktop\Scripts\generate_documentation.py", line 1, in <module> from sqlalchemy import create_engine, text File "C:\Program Files\Python313\Lib\site-packages\sqlalchemy\__init__.py", line 12, in <module> from . import util as _util File "C:\Program Files\Python313\Lib\site-packages\sqlalchemy\util\__init__.py", line 15, in <module> from ._collections import coerce_generator_arg as coerce_generator_arg File "C:\Program Files\Python313\Lib\site-packages\sqlalchemy\util\_collections.py", line 39, in <module> from .typing import is_non_string_iterable File "C:\Program Files\Python313\Lib\site-packages\sqlalchemy\util\typing.py", line 38, in <module> from typing_extensions import Annotated as Annotated # 3.8 ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ File "<frozen importlib._bootstrap>", line 1360, in _find_and_load File "<frozen importlib._bootstrap>", line 1331, in _find_and_load_unlocked File "<frozen importlib._bootstrap>", line 935, in _load_unlocked File "<frozen importlib._bootstrap_external>", line 1022, in exec_module File "<frozen importlib._bootstrap_external>", line 1159, in get_code File "<frozen importlib._bootstrap_external>", line 1217, in get_data PermissionError: [Errno 13] Permission denied: 'C:\\Program Files\\Python313\\Lib\\site-packages\\typing_extensions.py'
我的环境信息
- Python版本:3.13.1
- SQL Server版本:2022
- 操作系统:Windows 11 Pro
相关设置
- Python安装在 C:\Program Files\Python313
- 所有需要的依赖包(SQLAlchemy、Pandas、Jinja2等)都安装在 C:\Program Files\Python313\Lib\site-packages
Agent Job里的执行命令
"C:\Program Files\Python313\python.exe" C:\Users\Kevin\Desktop\Scripts\generate_documentation.py
我已经给SQLSERVERAGENT服务配置了对C:\Users\Kevin\Desktop\Scripts文件夹的读取和执行权限,也检查过Python安装目录及下属文件夹的权限,确保都设置到位了,但还是解决不了这个问题。
有没有大佬能指点下,怎么才能解决通过SSMS运行这个作业时出现的PermissionError呢?
备注:内容来源于stack exchange,提问作者user9172014
相关产品推荐
相关产品推荐

