• Log on to NT using the account that has been set up for using SQL Mail.
• Change the NT account for the SQL Server service to match your SQL Mail account
• Stop and start SQL Server
• Install Outlook or an Exchange client. You will want to select the Exchange service and leave all others blank.
• After installation is complete, reboot the machine and log on to NT.
• Have your Exchange administrator create a new mailbox that will be used by SQL Mail.
• On your SQL Server machine, create a new profile for the Exchange service. This profile needs to be setup using the Connect to Network option.
• Start up Outlook or the Exchange client and verify that you can send and receive mail.
• From within Enterprise Manager, right click on the SQL Mail icon and enter the profile name that you just created. Make sure you test the connection and have selected the auto start check box.
• Start SQL Mail. Once you see a green arrow display, SQL Mail is running.
• From within the Query Analyzer, execute xp_sendmail to send a message to the mailbox you created for the SQL Mail account.
• If you start up Outlook or your Exchange client, you should see the test message appear in the inbox.

Configuring SQL Mail for a POP3/SMTP server

Configuring SQL Mail to use a POP3/SMTP server is much more involved, although not more difficult.

To enable this, you will need to install Windows NT Messaging, acquire a POP and SMTP mail account, a mail client, and a named NT account.

Just like in the set up of SQL Mail for Exchange, you will need to use a named SQL Server account. This account should follow all of the restrictions and requirements noted in the section above.

To set up SQL Mail for a POP3/SMTP server, follow these steps:

• Close all programs and login to the SQL Server machine using the NT account you have selected for SQL Mail.
• Install Windows NT Messaging
• Right click the Inbox, select properties, and add a new profile.
• Create the new profile with only Internet Mail as an option and connecting through the network
• Specify the name of the mail server and an automatic transfer method.
• Specify your email address
• Enter the NT account name in the Full Name box.
• In the mailbox name box, enter the login name for the mail server.
• The profile should be setup to use the default address book and folder settings.
• After finishing the creation of this profile, select this profile name to be used when Windows messaging starts up.
• Stop the SQL Server and SQL Executive services
• Change the NT account name to the account you are using for SQL Mail
• Start up the MAPI compliant mail client you will be using.
• Create a new connection for your mail server.
• Specify the name of the account, POP3 server name, SMTP server name, e-mail account, and password.
• Make sure it is configured to use a LAN.
• Test the client setup to make sure mail can be sent and received.
• From within Enterprise Manager, right click on the SQL Mail icon and enter the profile name that you just created. Make sure you test the connection and have selected the auto start check box.
• Start SQL Mail. Once you see a green arrow display, SQL Mail is running.
• From within the Query Analyzer, execute xp_sendmail to send a message to the mailbox you created for the SQL Mail account.
• You should see the test message appear in the inbox.

Configuring and Managing SQL Mail 1 2 3 4 5 6 7