Results 1 to 7 of 7
  1. #1
    Join Date
    Feb 2003
    Posts
    4

    Wink Unanswered: Setting up SQL Mail Session SQL2002

    I am receiving this error message when I try to configure and test the mail session
    Error 18030 : xp_test_mapi_profile

    I check the Outlook2000 is the default mail client and it is.
    I am running SQL Server 2000, Server Pack 3
    SQLmap70.dll is 12/17/2002 located in the bin directory.

  2. #2
    Join Date
    Feb 2003
    Posts
    6

    Re: Setting up SQL Mail Session SQL2002

    Originally posted by Cassy
    I am receiving this error message when I try to configure and test the mail session
    Error 18030 : xp_test_mapi_profile

    I check the Outlook2000 is the default mail client and it is.
    I am running SQL Server 2000, Server Pack 3
    SQLmap70.dll is 12/17/2002 located in the bin directory.
    How are you testing SQLMail - with xp_sendmail or through the SQLMail GUI?

  3. #3
    Join Date
    Feb 2003
    Posts
    4

    Re: Setting up SQL Mail Session SQL2002

    Originally posted by zarathustra
    How are you testing SQLMail - with xp_sendmail or through the SQLMail GUI?
    Through SQLMAIL GUI

  4. #4
    Join Date
    Feb 2003
    Posts
    6

    Re: Setting up SQL Mail Session SQL2002

    Originally posted by Cassy
    Through SQLMAIL GUI
    What account is the SQL service running under. Does that account have a valid MAPI profile?

  5. #5
    Join Date
    Feb 2003
    Posts
    4
    The SQLServer account is the same account I am using for email. I installed Outlook 2000, set up corporate/workgroup account back to our exchange server. I am able to send and receive email via Outlook with the same SQLServer account configured to start SQLServer.

  6. #6
    Join Date
    Jan 2003
    Location
    Massachusetts
    Posts
    5,799
    Provided Answers: 11
    Cassy
    It has been a while since I set one of these up, but I believe the SQLAgent service must be running under the same NT logon that created the exchange profile you want to use. Like I say, it has been a while since I set one of these up, so have those grains of salt at the ready ;-).
    ~Matt

  7. #7
    Join Date
    Dec 2002
    Posts
    1,245

    Re: Setting up SQL Mail Session SQL2002

    Hi Cassy,

    Some things to check for:

    1. As someone has already pointed out, the SQL mail profile must exist for the SQL Agent service account. This means that you must configure outlook while logged in as SQL Agent.

    2. You don't mention what you're outlook is connecting to (Exchange, Lotus or POP3). I have had nothing but heartache when trying to connect to Lotus. It is doable, but like I said, it gave me nothing but heartache. Same with setting up Outlook to connect to a standard POP3 account. Nothing but a trail of tears (okay, that may be an exaggeration, but you get the picture).

    HTH,

    Hugh Scott

    Originally posted by Cassy
    I am receiving this error message when I try to configure and test the mail session
    Error 18030 : xp_test_mapi_profile

    I check the Outlook2000 is the default mail client and it is.
    I am running SQL Server 2000, Server Pack 3
    SQLmap70.dll is 12/17/2002 located in the bin directory.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •