sql-server - 无法在 Linux 上的 SQL Server 2017 Express 上启用 xp_cmdshell

Question

我正在尝试在 Linux RedHat 7.4 上运行的 SQL Server 2017 Express 上启用 xp_cmdshell

我正在关注 this guide ，并得到以下错误:

The specified option 'xp_cmdshell' is not supported by this edition of SQL Server and cannot be changed using sp_configure.

缺少它是因为 xp_cmdshell 在 Linux 上不起作用，还是因为我使用的是免费的 Express 版本？

谢谢!

Answer 1

而且您也无法启用它。 Editions and supported features of SQL Server 2017 on Linux - Unsupported features & services :

The following features and services are not available for SQL Server 2017 on Linux. The support of these features will be increasingly enabled over time.

Area	Unsupported feature or service
Database engine	Merge replication
	Stretch DB
	PolyBase
	Distributed query with 3rd-party connections
	Linked Servers to data sources other than SQL Server
	System extended stored procedures (XP_CMDSHELL, etc.)
	Filetable, FILESTREAM
	CLR assemblies with the EXTERNAL_ACCESS or UNSAFE permission set
	Buffer Pool Extension

注意“系统扩展存储过程(XP_CMDSHELL 等)”被列为不受支持。

---

SQL Server 2019也是如此(请注意，虽然 Polybase 已从不受支持的项目中删除):

The following features and services are not available for SQL Server 2019 on Linux. The support of these features will be increasingly enabled over time.

Area	Unsupported feature or service
Database engine	Merge replication
	Stretch DB
	Distributed query with 3rd-party connections
	Linked Servers to data sources other than SQL Server
	System extended stored procedures (XP_CMDSHELL, etc.)
	Filetable, FILESTREAM
	CLR assemblies with the EXTERNAL_ACCESS or UNSAFE permission set
	Buffer Pool Extension