Post reply

problems sending emails from SQL Server

  • May 15, 2004 at 5:21 am

    #85665

    HI,

    I have set up a mail profile (Outlook which is the default profile) for SQL server Agent. when i Test this profile from SQL Agent, it displays a message: "Successfully started (and stoped) a mail session whith this profile" which I think is OK.

    I have also created an operator which I made available to receive emails from SQL Server. On Operators properties, when I click on the Test button, it displays message shown below:

    when I press OK, it tells me that the message has been sent successfully. But it never sends Email to that account, it does not send Emails at all.

     

    Sometimes but not often, when I press OK to send message, it displays the message below:

    I restart the computer (Server) where the SQL Server is installed, after that I test Email from the operator's  properties and everything is OK, but I still do not receive messages.

    Can someone Help me pleaseee.

    thank you.

  • May 15, 2004 at 9:37 am

    #506569

    Hello,

    Unfortunately, I cannot see your messages, so maybe repost them in text.

    Since it sounds as though you successfully configured the profile and SQL Agent Mail, are you sure its not on the email end?

    If you open up outlook on the sql server box, and send an email from there to the same account, do you see it?

    If I see the messages, I may be able to provide more help. 

     

  • May 16, 2004 at 2:09 am

    #506577

    Hi, thanks for trying to help me.

    First message is:

    "This will send the message 'Microsoft SQL Enterprise Manager Alert Test notification - Please Ignore.' to the user or group with address ''behar.haziri@kpst.org. OK to send?'."

    and the second is:

    "Error 22022:SQLServerAgent Error: The file C:\Documents and Settings\AdminSQL\Local Settings\Application\Data\Microsoft\Outlook\Outlook.pst could not be accessed because another workstation has modified it. Close and then restart all mail-enabled applications.

     

    Thanks

  • May 16, 2004 at 9:02 am

    #506579

    Reboot the server to release the file, then try out SQL Mail again.  Did you reboot when you installed outlook?

  • May 17, 2004 at 1:30 am

    #506600

    Yes.

    Every time after error message, I reboot the server computer, after that when I test it from the operator's property, it displays a message tellig that the message has been sent successfully. but the message are not sent. 

  • May 17, 2004 at 9:30 pm

    #506726

    You never said whether you can send a message from Outlook.  Can you?

    Derrick Leggett
    Mean Old DBA
    When life gives you a lemon, fire the DBA.

  • May 18, 2004 at 2:00 am

    #506744

    Yes, I can send and receive emails from outlook. Also the email that SQL server is configured can send and receive emails from outlook

  • May 18, 2004 at 5:58 pm

    #506882

    Do you have the latest service packs installed on Outlook and SQL Server?  Also, do you have other people accessing the server (through terminal services for example).

    Derrick Leggett
    Mean Old DBA
    When life gives you a lemon, fire the DBA.

  • May 20, 2004 at 7:30 am

    #507128

    Yes, outlook is updated.

    I connect to the server through remote desktop, most of the work I do from remote desktop.

  • May 20, 2004 at 9:09 pm

    #507217

    when you use a pst file as your Outlook mail store, SQL Server will use the file while it's running.

    When you connect via Remote Desktop, you are actually creating a second session on the server.

    It sounds like the two sessions are trying to access the pst file.

    Do you need to use the pst file? Can you change Outlook to use Exchange instead?

    --------------------
    Colt 45 - the original point and click interface

Viewing 10 posts - 1 through 9 (of 9 total)

You must be logged in to reply to this topic. Login to reply