PRB: SQLMail Functions Hang on MAPI Error

ID: Q136869

The information in this article applies to:
  • Microsoft SQL Server versions 4.2x, 6.0, 6.5, 7.0

SYMPTOMS

In Microsoft SQL Server version 6.0, any SQLMail extended stored procedure that you execute hangs indefinitely and does not return any results. This occurs when a MAPI function encounters an error that causes it to present a dialog box to the user. This problem could also affect alert notifications, scheduled backup notifications, and anything else that relies on the SQLMail extended stored procedures.

When this problem occurs, the MSSQLSERVER service may get into a state where it cannot be shut down and the Windows NT computer must be rebooted in order to get SQLMail functionality to work properly again.

Identify the MAPI error that is being returned in the dialog box and take the appropriate steps to avoid that error by working with your primary messaging support provider.

In order to see the MAPI dialog box on the server, the SQL Server process must be run in a configuration that allows interaction with the desktop. There are two methods of accomplishing this:

  1. Run SQL Server from the Windows NT command prompt using the following command:
    sqlservr -c


  2. Set up the MSSQLServer service to run under the System account with the option selected to "Allow service to interact with desktop." You can set this option in the Control Panel, Services application.


Note that when the SQL Server process is set up to run under the System account, certain steps may be necessary to enable connectivity to the mail post office. These steps are described in Chapter 18 of the SQL Server version 6.0 "Administrator's Companion," and in Microsoft Knowledge Base article Q118501 INF: Troubleshooting SQLMail Problems


CAUSE

Under some circumstances, the current implementation of MAPI causes a dialog box to appear on the desktop to indicate a MAPI error. When such a MAPI error is encountered while SQLMail is running, it can cause all SQLMail functions to hang until you click the OK button in the dialog box on the SQL Server computer. If the MSSQLSERVER service is running under a user account (or does not have permission to interact with the desktop), the dialog box never appears on the screen and all SQLMail functions hang until SQL Server is restarted (this may require restarting Windows NT if the MSSQLServer service cannot be shut down).

Note, however, that other queries continue to execute normally on the server. Only queries which call a SQLMail extended stored procedure will hang.

The following two conditions are known to cause the MAPI error dialog box (other MAPI errors could potentially cause the same symptoms):

  1. The mail MMF file is stored on the post office server and the post office server is rebooted after SQLMail has been started.


  2. The mail MMF is stored locally and the drive it is stored on runs out of disk space.


The error message in the MAPI dialog box for both of the preceding situations is the following (note that other MAPI error messages are possible):
Mail is unable to save information to your message file. Check that the connection to your message file still exists and you have disk space available.

Additional query words: sql6 xp windows nt

Keywords : kbprg SSrvProg SSrvStProc
Version : winnt:4.2x,6.0,6.5,7.0
Platform : winnt
Issue type : kbprb


Last Reviewed: October 7, 1999
© 2000 Microsoft Corporation. All rights reserved. Terms of Use.