SQL Server used to rely on SQL Mail to for email capabilities. This was a pain as it required you to install a MAPI mail client onto your server. SQL Server 2005 has done away with this and now uses Database mail which relies on using your SMTP server instead of a mail client to send out email. You can set up Database Mail by following these instructions…
1. Open SQL Server 2005 Management Studio
2. Connect to the server.
3. Expand the Management node in the left pane.
4. Right-click on Database Mail.
5. Select Configure Database Mail from the resulting menu.
6. In the resulting Welcome screen, click Next.
7. Select Set up Database Mail by performing the following tasks.
8. Click Next.
9. At this point, if Database Mail has not been enabled on the server, you will get a prompt asking you if you wish to enable this feature, click Yes.
10. In the New Profile window, enter a name and description for your profile.
11. Click Add.
12. In the New Database Mail Account window, fill out all necessary information for the mail account that is to be used to send email from the server. When you are finished click OK.
13. The account will now be listed in the SMTP accounts section of the Profile window.
14. Click Next.
15. In the Manage Profile Security window, click the checkbox under Public and select Yes from the dropdown beneath Default Profile.
16. Click Next.
17. In the Configure System Parameters window, make any changes you need (Maximum File Size, Prohibited Attachment File Extensions, etc.).
18. Click Next.
19. The Complete the Wizard window will come up, giving a summary of your settings. If there are any changes that need to be made click Back. If everything is correct, click Finish.
20. The Configuring window will show the status of the installation. Once complete, click Close.