How to Configure SQL Server to Send Email on Small Business Server 2000

This article describes how to properly configure a MAPI profile on Microsoft Small Business Server 2000 with both Microsoft Exchange Server 2000 and Microsoft SQL Server 2000 installed on the same computer to work with SQL Mail. In this example, you need to log on as the domain\administrator and configure the SQL Server to log on as the domain\administrator.

WARNING: If you use Registry Editor incorrectly, you may cause serious problems that may require you to reinstall your operating system. Microsoft cannot guarantee that you can solve problems that result from using Registry Editor incorrectly. Use Registry Editor at your own risk.

1. Copy the following files to a temporary folder:
   • \ClntApps\ClientApps5\Outlook2000SR1\PFiles\Common\System\Mapi\1033\NT\newprof.exe
   • \ClntApps\ClientApps5\Outlook2000SR1\PFiles\Common\System\Mapi\1033\mapisvc.inf
   • \Program Files\Microsoft BackOffice\ClientSetup\Clients\Setup\sbs.prf
2. From a command prompt, run the following command from the temporary folder to which you copied the files in step 1:
   newprof -p .\sbs.prf
3. Modify the registry:
   1. Start Registry Editor (Regedt32.exe).
   2. Locate the <!-- value name --> value under the following key in the registry:
      HKEY_CURRENT_USER\Software\Microsoft\Windows NT\CurrentVersion\Windows Messaging Subsystem\Profiles\Microsoft Outlook\13dbb0c8aa05101a9bb000aa002fc45a
   3. Double click the 001e6608 value, change %SBSServer% to the NetBIOS name of your server, and then click OK.
   4. Quit Registry Editor.
4. Check the account that SQL Server uses:
   1. Click Start, point to Programs, point to Microsoft SQL Server, and then click Enterprise Manager.
   2. Expand Microsoft SQL Servers.
   3. Expand SQL Server Group.
   4. Right-click your server, and then click Properties.
   5. Click the Security tab.
   6. Make sure that the SQL Server is logging on as a specified account (such as domain\administrator) and that the password is correct.
   7. Click OK.
5. Make the following changes:
   1. Expand the Management item.
   2. Right-click SQL Server Agent, and then click Properties.
   3. On the General tab, make sure that the SQL Server Agent is configured to log on as a specific account (such as domain\administrator).
   4. In the Mail Profile drop-down box, you should see an entry for Microsoft Outlook.
   5. Click the Microsoft Outlook profile, and then click the Test button to verify that it can start and stop a mail session by using that profile.
   6. Click OK on the SQL Server Agent Properties dialog box.
   7. Click Apply, and then click OK on the SQL Server Agent Properties dialog box.
   8. Right-click SQL Server Agent, and then click Start.
   9. Expand the Support Services item.
   10. Right-click SQL Mail, and then click Properties.
   11. Click the Microsoft Outlook profile from the drop-down list, and then click the Test button to verify that it can start and stop a mail session by using that profile.
   12. Click OK on the SQL Mail Configuration dialog box.
6. On the Tools menu, click SQL Query Analyzer. Using the following query, you should be able to send a test e-mail message to the administrator:
   xp_sendmail @recipients=administrator,@subject='test1'
   Note: In this example, the master database needs to be selected in the Database window.

For more information about SQL Mail or creating a new MAPI profile, click the following article numbers to view the articles in the Microsoft Knowledge Base: