Results 1 to 8 of 8

Thread: Sql Mail

  1. #1
    Join Date
    Feb 2004
    Location
    El Salvador
    Posts
    46

    Unanswered: Sql Mail

    I am trying to configure the sql mail, but have had some problems. I have configured outlook 2000 as "corporate or workgroup", and made a succesful test of the MAPI session. When I try to test with an operator mail I get the following error:

    22022: SQLServerAgent Error: The SQLServerAgent mail is not running; check the mail profileand/or the SQLServerAgent service startup account in the SQLServerAgent Properties dialog.

    I've tried to fix these problems with no results.

    I would gladly appreciate any help.

  2. #2
    Join Date
    Apr 2003
    Posts
    5

    Re: Sql Mail

    Are you installing SQL Mail in a cluster sql instalation?

  3. #3
    Join Date
    Feb 2004
    Location
    El Salvador
    Posts
    46

    Re: Sql Mail

    No, just a single server.

  4. #4
    Join Date
    Aug 2002
    Location
    Scotland
    Posts
    1,578
    Are you running SQL server in fiber mode as specified in this KBA ?

    Run msdb.dbo.sp_get_sqlagent_properties which will give you the information from SQLAgent log.
    --Satya SKJ
    Microsoft SQL Server MVP
    [IMG]http://sqlserver-qa.net/google_bart.gif[/IMG]

  5. #5
    Join Date
    Jul 2003
    Location
    San Antonio, TX
    Posts
    3,662
    You'll have to use the same account for both services.

  6. #6
    Join Date
    Aug 2002
    Location
    Scotland
    Posts
    1,578
    I would also prefer to link this KBA - configure SQL Mail, just in case it may light the resolution.
    --Satya SKJ
    Microsoft SQL Server MVP
    [IMG]http://sqlserver-qa.net/google_bart.gif[/IMG]

  7. #7
    Join Date
    Feb 2004
    Posts
    5

    Thumbs up

    There are two places you have to set up the mail. One is in the properties of the SQL Server Agent under the Management Folder and the other one is the properties of the SQL Mail under the Support Services folder.

  8. #8
    Join Date
    Feb 2004
    Location
    El Salvador
    Posts
    46
    thanks for the info, I'll post if it works

Posting Permissions

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