RE: Access denied on xp_sendmail

From: Erika Christensen (erikach@online.microsoft.com)
Date: 09/11/02 

From: erikach@online.microsoft.com (Erika Christensen)
Date: Wed, 11 Sep 2002 20:23:04 GMT

Hi Tim,

The Access Denied message may be returned by SQL, the operating system, or
your email client. I have a few questions about your environment: What
version and service pack of SQL Server are you using? What version and
service pack of operating system is the server? What email client are you
connecting to (ie Outlook XP, etc)? What email server is the client
connecting to (ie. Exchange, etc.)?

The first step in troubleshooting this error is to ensure that SQL Mail is
still configured correctly. To do this try the following steps:

1) Verify what account is starting the SQL Server service (MSSQLSERVER is
the default service name). You may check this using the services control
panel.
2) Log in to the server using the account found in step1.
3) Open your default email client. Ensure that you are not prompted for
password or connection information during the opening of the application.
4) Send an email from the client, verify that it is sent without errors.
5) Close your email client. Check the properties of it to verify what the
name of the profile you are using is.
6) Open SQL Server Enterprise Manager, right-click on the servername and
choose properties.
7) On the Server Settings tab (SQL2000) click on the Change button in the
SQL Mail section. This should bring up another window. Verify that the
profile you confirmed in step is the one listed and click the test button.

If you have any questions regarding the above steps, please see the
following article:

     Q263556 INF: How to Configure SQL Mail
      http://support.microsoft.com/default.aspx?scid=kb;EN-US;Q263556

8) Verify that the account starting SQL Server has the following
permissions. For NT 4.0 this is configured through User Manager, in Windows
2000 it is configured using Local Security Policy\User Rights Assignment:
     Log on as Locally
     Log on as a batch
     Act as part of O/S
     Access this computer from network
     Log on as a service
     Replace process level token

Thank you!!
Erika Christensen
SQL Server Support

This posting is provided "AS IS" with no warranties, and confers no rights.

Are you secure? For information about the Strategic Technology Protection
Program and to order your FREE Security Tool Kit, please visit
http://www.microsoft.com/security.