INF: Troubleshooting SQLMail with Microsoft Exchange Server

• Microsoft SQL Server versions 6.0, 6.5

SUMMARY

You can use certain basic troubleshooting techniques to diagnose and resolve most SQLMail problems. Typically, errors in starting a SQLMail session or sending mail from SQLMail with a Microsoft Exchange Server fall into two categories: permissions problems and Exchange client setup problems. SQLMail functionality is documented in the "Books Online" for version 6.x. These should be thoroughly reviewed before using SQLMail.

MORE INFORMATION

You should examine the following checklist of items, preferably in the order given:

1. Log on to Windows NT with a user account that is an administrator of the local computer and is a domain account.



2. Confirm that the Exchange client, EXCHNG32.EXE, can connect to the Exchange server and mail can be sent.



3. Confirm that the Exchange profile used does not have a Personal Message Store (.pst) by running the Mail and Fax tool in Control Panel. Click the Show Profiles button and in the Mail dialog box select the default profile in the profile list according to the drop-down list labeled "When starting Microsoft Exchange, use this profile." Click the Properties button.



4. Select the services tab in the new dialog box and confirm that the only services are Microsoft Exchange Server and Personal Address Book. Click the Delivery tab and confirm that what is selected on the Deliver To drop-down list is the Mailbox on the Exchange Server, which should be something like "Mailbox - <Friendly User Name>" where Friendly User Name is the name of the user who logged on to Windows NT in step one.



5. To run SQLMail with an Exchange Server, it is necessary that the MSSQLServer service is run under the same user account that logged on during step one above. You can determine this by opening the Services tool in Control Panel, selecting the MSSQLServer service and clicking the Startup button.



6. Confirm that the SQLMail user name and password are correct by running SQL Server Setup. Select Set Server Options and click the Mail Login button. The user name must match the Profile name from step three above.


NOTE: The password and Copy SQLMail Configuration in the Current User Account check box do not matter since both no longer apply.

NOTE: SQL Server Setup version 6.5 will only ask for the Exchange Profile name.

7. Test SQL Server access permissions to the Exchange Server. You can do this by using the XP_CMDSHELL extended stored procedure, which runs with the same permissions as SQLMail. Use the following command to test connectivity to the server, assuming the Exchange Server is located on a computer named "NTServer".
   
   xp_cmdshell "NET USE \\NTServer\IPC$"


If the above command fails, step three has not been completed correctly.


8. At this point SQLMail should be able to Autostart or be started manually with the xp_startmail extended stored procedure. Additionally, you can choose the profile to use with xp_startmail by replacing <Profile name> with the profile name from step three, as in the following example:
   
   xp_startmail "<Profile name>",""

Additional query words: Exchng32 Mapi Mail

Keywords :
Version : 6.0 6.5
Platform : WINDOWS
Issue type :