Setting up Database Mail

This recipe demonstrates how to set up Database Mail programmatically using PowerShell.

Getting ready

The assumption in this recipe is that Database Mail is not yet configured on your instance.

These are the settings we will use for this recipe:

Setting	Value
Mail Server	mail.queryworks.local
Mail Server Port	25
E-mail address for Database Mail profile	[e-mail]
SMTP authentication	Basic authentication
Credentials for e-mail address	Username is [e-mail] Password is <some password>

How to do it...

To set up Database Mail, follow these steps:

1. Open PowerShell ISE as administrator.

2. Import the SQLPS module and create a new SMO Server object:

   #import SQL Server module
   Import-Module SQLPS -DisableNameChecking
   
   #replace this with your actual server name
   $instanceName = "localhost"
   
   $server = New-Object -TypeName Microsoft.SqlServer.Management.Smo.Server -ArgumentList $instanceName

   Add the following script block to create a Database...