- First install Outlook 2000 on the server.
- Login as the user that you SQL service starts as (SQLService in our case).
- Run Outlook making sure you choose the Corporate or Workgroup option.
- Then Select the Pop3 account type.
- Setup the pop3 account with some valid credentials (in our case weâ€™re only sending so in doesnâ€™t matter if you use your own just make sure you tick the â€œleave messages on serverâ€ check box)
- Ok the account setup and you should see your unread emails flood in, test the sending with a test email to someone you like.
- Exit outlook and fire up enterprise manager and bring up your SQL Servers properties.
- On the â€œServer Settingsâ€ tab there in an â€œSQL Mailâ€ section, hit the â€œChangeâ€ button and select the MAPI profile you just created in Outlook ( there should only be the one in there).
- Now open up the properties of your â€œSQL Server Agentâ€ and check that the â€œMail sessionâ€ â€œMail Profileâ€ is set to the same MAPI profile you just set in the SQL Server properties and hit the test button to make sure it can send.
After the Agent service restarts itself you’re right to setup email notifications for Alerts and Agent Jobs.