DNN Blogs

Written for the Community, by the Community
All Posts Term: Database Mail
1 post(s) found

Activating and Configuring Database Mail in MS SQL Server Express Edition

Do you know Database Mail? Those who administer an MS SQL Server apart from the Express Edition might know it, and there is a nice interface to configure it in SQL Server Management Studio (SSMS). But this interface is missing in the Express Edition. The reason for that is that the SQL Server Agent Services are not present in this edition, which does not let us configure maintainence tasks or Database Mail.
These services use the MSDB database, and this database is installed as one of the system databases, even in SQL Server Express Edition. With a few SQL statements we can activate and configure Database Mail, and make use of this feature.

Would you like to help us?

Awesome! Simply post in the forums using the link below and we'll get you started.

Get Involved