SQL Server 2016 Send mail feature

--1 Installing SQL Server 2016

--2 Installing. Net 3.5

Because SQL Server 2016 installation does not prompt to force the installation of. NET 3.5 but still needs to be installed, the database sends messages using the content provided by. NET 3.5, and if you do not install. NET 3.5 then mail does not send properly

Windows Server R2 installation of. NET 3.5 failed to install in the Add Services and Applications feature, prompting 0x800f0907

This is because the installation source files for. NET 3.5 are required.

The best way to do this is to load the Windows Server R2 ISO image to disk using the virtual optical drive, and then read the contents of the SxS folder under source to install the alternate installation source.

--3 Configuring mail delivery

The first time you use it, follow the default options

Create configuration files, add configuration accounts, etc.

Check public access to avoid permissions, but many mail servers require Basic authentication. This is a private mail server, and there's no limit.

--4 activating the Database Mail function

sp_configure ' show advanced ', 1
GO
RECONFIGURE
GO
sp_configure ' Database Mail XPs ', 1
GO
RECONFIGURE
GO

--5 test Send mail

--6 Confirm receipt, if not received, note the Firewall section and the configured mail profile information

SQL Server 2016 Send mail feature