Results 1 to 9 of 9

Thread: SQL Mail

  1. #1
    Join Date
    Jan 2004
    Posts
    21

    Unanswered: SQL Mail

    Dear all,

    I need to enable the SQL Mail in our SQL Server 2000 server. However, we do not MS Outlook installed in the server where the SQL sits and we have a policy in our company not to install outlook in servers. Is there any way to enable SQL Mail without Outlook installed?

    Thanks in advance.

    Snoopy

  2. #2
    Join Date
    Feb 2004
    Location
    San Antonio, TX
    Posts
    565
    try The Bat
    OR
    call the mail api from vb
    OR
    Talk to your admins and explain the process so that they will allow you to add the outlook client to your server.
    most reasonable people will change the group policy or allow you to block inheritance on the policy.(just for your servers)

  3. #3
    Join Date
    Aug 2002
    Location
    Scotland
    Posts
    1,578
    KBA http://support.microsoft.com/default...;en-us;Q312839 to do more with OS supplied tools./
    --Satya SKJ
    Microsoft SQL Server MVP
    [IMG]http://sqlserver-qa.net/google_bart.gif[/IMG]

  4. #4
    Join Date
    Feb 2004
    Location
    San Antonio, TX
    Posts
    565
    you thiink you're so smart huh??!

    seriously,
    that's a great kb article. i wish i would've found it first
    all i had was my lame alternative email client...and some vb code..

    i'm gonna have to use this solution in some of my more difficult consults.

  5. #5
    Join Date
    Feb 2004
    Posts
    492
    yeah, but would you really want IIS running on a DBServer just to email (html email that is)?

  6. #6
    Join Date
    Oct 2002
    Posts
    66
    I am in a situation that I cannot see a solution for. I need to set up SQL Mail on our servers without installing IIS or Outlook. We are using SQL Server 2000 on Windows 2000 Advanced Server. Our current mail client is Lotus Notes.

    I have taken a look at the Bat link you provided, but I cannot see how that will help me here.

    Any ideas?

  7. #7
    Join Date
    Feb 2004
    Location
    San Antonio, TX
    Posts
    565
    the trick in your situation is not the iis
    web server is not neccessary in this situation
    what you need is a mail server that is exposed externally and a client
    i have set up sql mail on lotus notes with outlook 98 and 2000 and it works very well.
    the previous article that indicates the ms kb article is an excellent situation.
    your mission if you accept it is to choose either a third party client or create the programmatic solution from the kb article.

    one last question,,,, what mail client is being currently used?

  8. #8
    Join Date
    Feb 2002
    Posts
    2,232
    Is your lotus notes configured to support smtp ? Under what circumstances will you need to use email from sql server ?
    If you do not have SQL Server Books Online (BOL) installed - please do so. The majority of questions asked in the SQL Server forum could be eliminated if people had access to bol. BOL

  9. #9
    Join Date
    Aug 2002
    Location
    Scotland
    Posts
    1,578
    I never thought so... but KBAs are always reliable and useful, which is most suggested way to resolve the issues rather than using third party tools which has crumbling behaviour and dependant on enterprise to enterprise network setup.

    And its my general tendency to refer a knowledgebase article issues by MS and discourage to enroute the solution.
    Originally posted by Ruprect
    you thiink you're so smart huh??!

    seriously,
    that's a great kb article. i wish i would've found it first
    all i had was my lame alternative email client...and some vb code..

    i'm gonna have to use this solution in some of my more difficult consults.
    --Satya SKJ
    Microsoft SQL Server MVP
    [IMG]http://sqlserver-qa.net/google_bart.gif[/IMG]

Posting Permissions

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