Database Journal
MS SQL Oracle DB2 Access MySQL PostgreSQL Sybase PHP SQL Etc SQL Scripts & Samples Tips Database Forum

» Database Journal Home
» Database Articles
» Database Tutorials
MS Access
SQL Scripts & Samples
» Database Forum
» Slideshows
Free Newsletters:

News Via RSS Feed

Database Journal |DBA Support |SQLCourse |SQLCourse2

Featured Database Articles


Posted Aug 7, 2001

SQL Mail with SQL Server 6.5

By DatabaseJournal.com Staff

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.

MS SQL Archives

Latest Forum Threads
MS SQL Forum
Topic By Replies Updated
SQL 2005: SSIS: Error using SQL Server credentials poverty 3 August 17th, 07:43 AM
Need help changing table contents nkawtg 1 August 17th, 03:02 AM
SQL Server Memory confifuration bhosalenarayan 2 August 14th, 05:33 AM
SQL Server Primary Key and a Unique Key katty.jonh 2 July 25th, 10:36 AM