SQL Mail with SQL Server 6.5

How to install a Microsoft.
Exchange(tm) Client so SQL Server can send and receive mail:

Created by Mike Culver — see his web site for additional info on SQL 6.5 and 7.0: http://www.realworldinfo.com/techinfo/

  1. In User Manager for domains, connect to the local
    account database on the NT server where SQL
    Server is installed.
  2. Create an NT user account to be used by SQL
    Server to log into the network. Make sure the
    account has "Password Never Expires
    checked" and does NOT have "User Must
    Change Password at next logon" checked.
  3. Make the NT account a part of the local
    administrators group on the server where SQL
    Server is installed. You could use the local
    Administrator account for this purpose, as long
    as this account will not be sending and receiving
    mail independently of SQL Server’s mail client.
  4. Make sure that the new account is part of the
    same domain from where the exchange mailboxes are
    being created, or that there is a trust
    relationship with that domain.
  5. Still in User Manager for Domains, choose the
    Policies menu and select User Rights. In the User
    Rights dialog, select the "Show Advanced
    User Rights" checkbox.
  6. In the "Right" list box, choose
    "Act As Part Of the Operating System."
    Add the account SQL Server is using to log into
    NT to the "Grant To" list box. Repeat
    this process for the "Increase Quotas"
    right, the "Log On As a Service" right,
    and the "Replace a Process Level Token"
    right. SQL Server must have all of these rights
    when using other than the Localsystem account.
    Exit User Manager for Domains.
  7. In the Exchange Administrator, create a new
    mailbox for SQL Server, specifying the new NT
    account SQL Server will use to log into the
    network.
  8. Go to Control Panel, Services on the server where
    SQL Server is installed; alternatively, run the
    Server Manager utility from the Administrative
    Tools program group, choose the NT server where
    SQL Server is installed and open the Services
    utility. In the Services list box, choose the
    MSSQLSERVER service. Press the Startup
    button. SQL Server probably is logged into the
    network as the System Account.
  9. Choose "Log on as This account." The
    LOCALSYSTEM account will probably be in the
    "log on as this account" text box.
    Press the ellipse button (the three dots) to go
    to the List Accounts dialog, and choose the
    account that you just created for SQL Server to
    log into the network. Change the password and
    exit out of the Startup dialog.
  10. Stop and Restart the MSSQLSERVER service to have
    SQL Server log into the network under the new
    account.
  11. At the NT server where SQL Server is installed,
    log in to NT as the account that was just created
    for SQL Server, making sure the correct domain is
    specified.
  12. Install the Exchange client on the NT server.
  13. While still logged into NT as SQL Server’s new
    account, run the Exchange client for the first
    time. Go through the Wizard to set up a new
    profile.
  14. When the profile has been created and you are
    running the Exchange client, go to the Tools menu
    and select Options. Choose the Delivery tab.
  15. Make sure the "Deliver To" setting is
    "Mailbox-name" where name is the name
    you chose during profile setup for the Exchange
    mailbox. If the "deliver to" setting is
    "personal folders" then SQL Mail will
    not work correctly.
  16. Verify that the Exchange client can send and
    receive mail. Correct any lack of permissions
    that is preventing mail from being sent or
    received. You can then exit out of the Exchange
    client.
  17. Go to Control Panel on this NT server where SQL
    Server is installed, and run the Mail and Fax
    utility. Choose "Show Profiles."
  18. Make sure the profile just created from the
    Exchange client is the profile to be used as the
    default when running Exchange. Make a note of the
    name of this profile. Exit from Control Panel.
  19. Run SQL Enterprise Manager. Log into the SQL
    Server by drilling down on the "+" icon
    next to the server name. Right-mouse-button click
    on the SQL Mail icon and choose Configure.
  20. You will be prompted for the name of the Exchange
    profile that SQL Server is to use. Type in the
    name of the profile that you just made a note of
    in Control Panel, e.g., "MS Exchange
    Settings".
  21. Right-mouse-button click on the SQL Mail icon
    again and this time choose Start. If the SQL Mail
    icon turns green then SQL Server’s mail client is
    running and can send and receive mail.
  22. If SQL Mail fails to start, go to the NT
    Application Event log and check on the error. If
    it is a "MAPI logon failure" that means
    that SQL Mail was not able to log into the
    Exchange server. If you were able to send and
    receive mail through the Exchange client when
    testing it interactively, then 99% of the time
    this is a network permissions problem, meaning
    that SQL Server doesn’t have permissions on the
    network to get to the Exchange server. Make sure
    that SQL Server has been stopped and restarted
    since changing its logon settings and make sure
    that that SQL Server’s NT user account has
    permissions on the network to get to the Exchange
    server. It should have, if you can send and
    receive mail from the Exchange client.
Previous articlesp_MSforeachtable
Next articlesp_ABCheckFreeSpace.sql

Latest Articles