Page 1 of 2 12 LastLast
Results 1 to 15 of 22

Thread: Sql Mail And Sql Server Agent Mail With Lotus Notes Domino Server

  1. #1
    Join Date
    Jul 2003
    Location
    New York City
    Posts
    29

    Angry Sql Mail And Sql Server Agent Mail With Lotus Notes Domino Server

    Hello Everyone,
    I am trying to configure SQL MAIL and SQL SERVER AGENT MAIL feature of SQL SERVER 2000 with Lotus Domino server (Not Microsoft Exchange). Every thing goes fine and it works also. Problem starts when I try to restart SQL Agent Service. It hangs and the status of service remain 'starting'...
    Also the size of the sqlagent service process goes upto 12MB. I don't understand why? Can any one help me in solving this problem.
    I am using Windows 2000 Advanced Server and SQL Server 2000 with SP3. Domino client is R5.0.5 and Outlook 2000.

  2. #2
    Join Date
    Sep 2002
    Location
    Fantasy
    Posts
    4,254
    Look in sql server log, sql agent log and event viewer for warnings or errors

  3. #3
    Join Date
    Jul 2003
    Location
    New York City
    Posts
    29
    I checked all the log files, there is no error message. The only message I can see is Agent is starting MAPI session...

    Also, After setting up SQL MAIL/SQL AGENT MAIL, behaviour of Outlook 2000 changes abruptly. It hangs.

  4. #4
    Join Date
    Sep 2002
    Location
    Fantasy
    Posts
    4,254

  5. #5
    Join Date
    Nov 2002
    Location
    New Jersey, USA
    Posts
    3,932

  6. #6
    Join Date
    Sep 2002
    Location
    Fantasy
    Posts
    4,254

  7. #7
    Join Date
    Jul 2003
    Location
    New York City
    Posts
    29
    Hello Everyone,
    Thanks for your help. Those documents are really helpful, but they don't tell any thing about Domino Server and SQL MAIL/Agent Mail. I explored all the possibilities but didn't get any success so far. Also I am tied with internet security issues, so I can't have access to my mail server (using POP3/SMTP services). The only option left is using Domino Server as corporate/workgroup mail server. I don't have any idea about SMTP Server. Can any one tell me, in order to send e-mail using SMTP(after creating a stored procedue, as suggested in one of the reply to this thread), what information about the mail server( Domino Server - I can send/receive e-mail to any internet domain using my id) do I need to have? Once again I am thankful for your help - Suresh

  8. #8
    Join Date
    Nov 2002
    Location
    New Jersey, USA
    Posts
    3,932

  9. #9
    Join Date
    Sep 2002
    Location
    Fantasy
    Posts
    4,254
    For sending smtp emails you need to enable one smtp service. Ask your Network Admin for the relay IP address you can use for smtp.

    Smtpsend.exe can be found anywhere on the internet. shoot me an email if you need that .exe file. its a shareware.

    Your network admin can enable it.

  10. #10
    Join Date
    Jul 2003
    Location
    New York City
    Posts
    29
    Thanks to everyone, I am NOW working on SMTP USING netsend.exe...

  11. #11
    Join Date
    Sep 2002
    Location
    Fantasy
    Posts
    4,254
    send your email id i will send the smtpsend.exe that i was using, so that you dont have to update the procedure,switches and codes.

    mak_999@yahoo.com

  12. #12
    Join Date
    Jul 2003
    Location
    New York City
    Posts
    29
    Hi,
    I am using CDOSYS for sending e-mails using SMTP server, its working... thanks to every one

  13. #13
    Join Date
    Sep 2002
    Location
    Fantasy
    Posts
    4,254
    For KB purpose, could you please copy and paste the CODE on how you are using CDOsys?

  14. #14
    Join Date
    Jul 2003
    Location
    New York City
    Posts
    29
    MAK,

    I used same code as given by Microsoft KB - 312839

    This is working fine.

    CREATE PROCEDURE dbo.sp_send_cdosysmail
    @From varchar(100) ,
    @To varchar(100) ,
    @Subject varchar(100)=" ",
    @Body varchar(4000) =" "
    AS
    Declare @iMsg int
    Declare @hr int
    Declare @source varchar(255)
    Declare @description varchar(500)
    Declare @output varchar(1000)
    EXEC @hr = sp_OACreate 'CDO.Message', @iMsg OUT
    EXEC @hr = sp_OASetProperty @iMsg,
    'Configuration.fields("http://schemas.microsoft.com/cdo/configuration/sendusing").Value','2'

    -- Replace MailServerName by the name or IP of your SMTP Server.
    EXEC @hr = sp_OASetProperty @iMsg, 'Configuration.fields("http://schemas.microsoft.com/cdo/configuration/smtpserver").Value', 'MailServerName'

    EXEC @hr = sp_OAMethod @iMsg, 'Configuration.Fields.Update', null
    EXEC @hr = sp_OASetProperty @iMsg, 'To', @To
    EXEC @hr = sp_OASetProperty @iMsg, 'From', @From
    EXEC @hr = sp_OASetProperty @iMsg, 'Subject', @Subject

    -- If you are using HTML e-mail, use 'HTMLBody' instead of 'TextBody'.

    EXEC @hr = sp_OASetProperty @iMsg, 'TextBody', @Body
    EXEC @hr = sp_OAMethod @iMsg, 'Send', NULL

    -- Sample error handling.
    IF @hr <>0
    select @hr
    BEGIN
    EXEC @hr = sp_OAGetErrorInfo NULL, @source OUT, @description OUT
    IF @hr = 0
    BEGIN
    SELECT @output = ' Source: ' + @source
    PRINT @output
    SELECT @output = ' Description: ' + @description
    PRINT @output
    END
    ELSE
    BEGIN
    PRINT ' sp_OAGetErrorInfo failed.'
    RETURN
    END
    END

    -- Do some error handling after each step if you need to.
    -- Clean up the objects created.
    EXEC @hr = sp_OADestroy @iMsg
    go


    Then use the stored procedure you created and provide the proper
    parameters:

    declare @Body varchar(4000)
    select @Body = 'This is a Test Message'
    exec sp_send_cdosysmail 'someone@microsoft.com', 'someone2@microsoft.com','Test of CDOSYS', @Body

  15. #15
    Join Date
    Sep 2002
    Location
    Fantasy
    Posts
    4,254

Posting Permissions

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