Results 1 to 7 of 7

Thread: set SQL mail

  1. #1
    Join Date
    Mar 2004
    Location
    Princeton, NJ
    Posts
    12

    Red face Unanswered: set SQL mail

    Hello, does anyone knows how to set up the SQL mail as SQL server running under the local system ( for secutiy reason, it can't be set a domain account)?

    Help!!!!

  2. #2
    Join Date
    Jul 2003
    Location
    San Antonio, TX
    Posts
    3,662

  3. #3
    Join Date
    Feb 2004
    Location
    San Antonio, TX
    Posts
    565
    SQL Mail requires a mail connection, a mailbox, a mail profile, and the Windows NT account you used to start SQL Server. This Windows NT account needs to be a domain account if you are using an Exchange server as your mail server. It can be a local or domain NT account if you are using POP3/SMTP mail server.

  4. #4
    Join Date
    Apr 2003
    Location
    SC, USA
    Posts
    51
    There are alternatives. Personally I use a SMTP mail stored procedure I found here:

    http://www.sqlservercentral.com/scri...utions/510.asp

    You'll have to register with the site to get to it, but it's well worth it. Their script library is VERY impressive.

  5. #5
    Join Date
    Mar 2004
    Location
    Princeton, NJ
    Posts
    12

    Thanks Guys.

    I'll try SMPT to see.

  6. #6
    Join Date
    Aug 2002
    Location
    Scotland
    Posts
    1,578

  7. #7
    Join Date
    Jul 2003
    Location
    San Antonio, TX
    Posts
    3,662
    Satya does KB's...

Posting Permissions

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