Paloma,
PSS ID Number: Q153159
Article last modified on 07-11-1997
6.0 6.5
WINDOWS
======================================================================
------------------------------------------------------------
The information in this article applies to:
- Microsoft SQL Server, versions 6.0 and 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>",""
Neil Pike MVP/MCSE
Protech Computing Ltd
by