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
Email Address for Database Mail Profile	[e-mail]
SMTP Authentication	Basic authentication
Credentials for Email Address	Username: [e-mail] Password: <somepassword>

How to do it...

1. Open the PowerShell console by going to Start | Accessories | Windows PowerShell | Windows PowerShell ISE.

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

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

3. Add the following script...