Results 1 to 7 of 7

Thread: SQL Mail

  1. #1
    Join Date
    May 2002
    Location
    belmont
    Posts
    2

    Arrow Unanswered: SQL Mail

    Hi,
    I want to know step by step procedure for installing SQL Mail and what r the essential software needed for that to run properly .

    Hari babu.

  2. #2
    Join Date
    May 2002
    Location
    belmont
    Posts
    2

    reply

    Hi,
    u need to install the outlook and sql server on the system u want to load SQL Mail

  3. #3
    Join Date
    May 2002
    Posts
    25
    not necessarily.

    if you have an Exchange server, its very easy. If you don't it can get a little more complicated.

    http://www.swynk.com/faq/sql/sqlfaq_sqlmail.asp


    How to with Exchange:
    Create an account on the domain
    Setup the account in Exchange
    Add the domain account the the local administrator’s group on the SQL Server
    Configure a MAPI profile for the new domain account using “Internet Mail” on the SQL Server
    Login to the SQL Server as that account
    Modify the SQL Server so that it starts as the new Domain Account (currently, its set to startup as a Local Account)
    Restart the SQL Server service
    Once the server is restarted, open up EM, expand Support Services, right click on SQL Mail and select the newly created Profile. Select Test. It should work
    Last edited by helpimstuck; 05-28-02 at 11:40.

  4. #4
    Join Date
    Jun 2002
    Location
    iceland
    Posts
    4

  5. #5
    Join Date
    Nov 2002
    Posts
    33
    I have tried to follow this.
    I changed the MSSql server logon service account and the SQL agent account, then did the same to the SMTP service.
    I get an error reading:
    Could not start.
    The account specified for this service is deferent from the account specified for services running same processes.

    What is I forget to change?


    Thanks
    Motty

  6. #6
    Join Date
    Jan 2003
    Location
    Surrey, UK
    Posts
    23
    Are you running on NT or 2K?

    IIRC the service account needs some specific privileges. The ones I remember are:

    Act as part of the operating system
    Replace a process level token

    There may be some others..

    I recall that the documentation in SQL BOL covered this adequately.

    In 2K the privilege setup is a bit more obscure but if you follow the documentation you should get it right. I managed to get it working in about an hour about 2 years ago....

    The other thing that I found (That was on SQL2K SP1) was that SQLMail would only work if you installed the Outlook 2000 client on the server. I could not get it to work with any other client. This issue has been fixed in subsequent SP's (per the documentation) but I have not verified that it works with any other client.

    Regards
    Andy


  7. #7
    Join Date
    Nov 2002
    Posts
    33
    I'm running SQL 7.0 on a W2K OS.
    I did not include the ID in the act as part of the OS...
    All I did was add the ID to the local administration group.
    I do have Outlook running on the system...

    Thanks
    Motty

Posting Permissions

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