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

Article translations Article translations
Article ID: 304967 - View products that this article applies to.
This article was previously published under Q304967
This article has been archived. It is offered "as is" and will no longer be updated.
IMPORTANT: This article contains information about modifying the registry. Before you modify the registry, make sure to back it up and make sure that you understand how to restore the registry if a problem occurs. For information about how to back up, restore, and edit the registry, click the following article number to view the article in the Microsoft Knowledge Base:
256986 Description of the Microsoft Windows Registry
Expand all | Collapse all

SUMMARY

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.

MORE INFORMATION

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:
263556 INF: How to Configure SQL Mail
268996 MAPI Profiles Are Deleted and Error Message Occurs When SBS Console Is Reinstalled
266418 Microsoft does not support installing Exchange Server and Outlook on the same computer

Properties

Article ID: 304967 - Last Review: February 28, 2014 - Revision: 1.2
APPLIES TO
  • Microsoft Small Business Server 2000 Standard Edition
Keywords: 
kbnosurvey kbarchive kbhowto kbenv KB304967

Contact us for more help

Contact us for more help
Connect with Answer Desk for expert help.
Get more support from smallbusiness.support.microsoft.com