关于 Database Mail 配置时出现的错误 The configuration option 'Database Mail XPs' does not exist, or it may be an advanced option.

在通过 sp_configure 进行 Database Mail 配置时出现了以下的这个错误信息

Msg 15123, Level 16, State 1, Procedure sp_configure, Line 62

The configuration option 'Database Mail XPs' does not exist, or it may be an advanced option.

 

 

解决方法

 

EXEC sp_configure 'show advanced options', 1

GO

RECONFIGURE WITH OVERRIDE

GO

EXEC sp_configure 'Database Mail XPs', 1

GO

RECONFIGURE WITH OVERRIDE

GO