Professional Web Applications Themes

SQL Mailer Problem - Microsoft SQL / MS SQL Server

I am trying to setup SQL Server to send emails. SQL Server allows me to test the SQL Mailer but does not allow me to start the service. I am not using an exchange server and I think that is the problem. I am running a laptop with XP Pro. I read somewhere that I should install "Windows NT Messaging", is there a program for XP that I can install POP/SMTP service like "Windows NT Messaging"? Thanks Gerry...

  1. #1

    Default SQL Mailer Problem

    I am trying to setup SQL Server to send emails. SQL
    Server allows me to test the SQL Mailer but does not
    allow me to start the service. I am not using an
    exchange server and I think that is the problem. I am
    running a laptop with XP Pro. I read somewhere that I
    should install "Windows NT Messaging", is there a program
    for XP that I can install POP/SMTP service like "Windows
    NT Messaging"?

    Thanks

    Gerry
    Gerry Guest

  2. #2

    Default Re: SQL Mailer Problem

    www.aspfaq.com/2403





    "Gerry Whitworth" <com> wrote in message
    news:05de01c35c81$81268df0$gbl... 


    Aaron Guest

  3. #3

    Default Re: SQL Mailer Problem

    In order to use SQL Mail, you need to install the Outlook client on your PC,
    and configure a mail profile for the user that the SQL Server service runs
    under. Then you need to select that mail profile as the SQL Mail profile.
    Complete description of what is required is available in BOL.

    However, instead of using SQL Mail, you may consider implementing your own
    extended procedure that can send email using CDOSYS - I believe that would
    be available on WinXP Pro.

    HTH,
    Tore.

    "Gerry Whitworth" <com> wrote in message
    news:05de01c35c81$81268df0$gbl... 


    Tore Guest

  4. #4

    Default Re: SQL Mailer Problem

    That's a great reference. I could have saved myself several hours of
    research had I found that when I needed it. Hereby bookmarked!

    Tore.


    "Aaron Bertrand [MVP]" <com> wrote in message
    news:phx.gbl... 
    >
    >[/ref]


    Tore Guest

Similar Threads

  1. SMTPsvg.Mailer HTML format problem
    By wrytat in forum ASP Components
    Replies: 2
    Last Post: December 15th, 09:30 AM
  2. form mailer
    By andrewdekker in forum Macromedia Dynamic HTML
    Replies: 2
    Last Post: May 17th, 11:19 AM
  3. PHP Mailer
    By simec in forum PHP Development
    Replies: 1
    Last Post: November 20th, 02:53 AM
  4. ASP Mailer Question
    By John Davis in forum ASP
    Replies: 2
    Last Post: August 17th, 11:11 PM

Bookmarks

Posting Permissions

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

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139