Post reply

Outlook 2003 and SQL 2000 SP4

  • July 17, 2006 at 12:19 am

    #61422

    Hi there,

    I am trying to Configure SQL Mail on the SQL server 2000 with SP4. (Sice I am testing first, I am doing this on my notebook that has an evaluation edition of SQL 2000 Sp4, and Outlook 2003 Sp2).

    I am having trouble trying set it up, so I am wondering if SQL Mail works with Outlook 2003 and SQL 2000 SP4. Has anyone tried it?

    Your help is highly appreciated.

    Thanks,

    TK

  • July 17, 2006 at 12:38 am

    #649458

    Surely it works, but you need to do followings:

    1. SQL Service must be running under an account (either NT or local)
    2. This account must has at least one Outlook profile
    3. When SQL starts up with the account you set you are going to see Outlook profiles under SQL Mail "Profiles" menu

    That's all.

  • July 18, 2006 at 8:10 am

    #649795

    If it is still not working after setting up the above, give it a reboot. Or at least stop and restart the sql server and associated services. Sometimes exchange's pop3 can lock up with automated updates, thats another point to consider, if your not receiving the messages.

    Also, it is easier if the exchange box is on the same domain of the sql server or even better run both on the same box but be mindful of memory related challenges.  These all matter if you are working with DC's.

  • July 18, 2006 at 7:20 pm

    #649994

    Hi all,

    I have another trouble when configuring SQLMAIL:

    I have 2 SQL servers,both are Win 2000 Advance Server.

    -With the first server,I installed SQL Server with one local account(this server has been joined domain already).Then,I created Mail Profile,but when i configured SQL Server to use that mail profile,I couldn't see that profile.

    -With the second server,I installed SQL Server with one domain account.I could see my MAIL Profile when i configured SQL Server.

    I couldn't understand why.....

  • July 18, 2006 at 7:37 pm

    #649996

    hey Cao, I was having lots of problems setting up SQL mail myself. However, everyone on this site helped me and how I have been able to successfully test it on my test server So, I'll try to help with whatever knowledge I have gained so far.

    Are the servers clustered? If not, did you logon to both the servers using same NT account that the SQL servers will use to run SQL server agent?

  • July 19, 2006 at 7:47 pm

    #650284

    Thanks Tejwant Kaur for your response.

    The servers are not Clustered.

    And I didn't logon to both servers using the same NT account that the SQL servers will use to run SQL server agent.

    One server i could did ,and another I couldn't although i did in the same way.

    Help me please....

  • July 19, 2006 at 7:52 pm

    #650286

    You need to logon to both the servers using the same account Cao. That is the reason why SQL Mail worked on the one where you logged on with the same account.

    If this doesn;t help, could you be a bit more specific about what error you are getting?

  • July 19, 2006 at 10:43 pm

    #650303

    I will try ur solution.

    So now, i would like to tell u more about my problem:

    -I have 2 SQL Server.

    -With the first server,i logoned using local administrator account.I installed SQL Server,created backup tasks,Mail Profile.When i configured SQLMAIL,i couldn't see my MAIL profile.I left that problem there.

    -And I continued with the second server.I logoned using domain account.After that,i did as i did with the first server.Everything was smooth.The server could send me mails whenever jobs failed.

    I hope u can understand my problem.PLease help!!!

  • July 19, 2006 at 11:39 pm

    #650306

    If you do what I said it should work.

    otherwise, Read the following

    http://msdn.microsoft.com/library/default.asp?url=/library/en-us/adminsql/ad_1_server_2ecs.asp

    this should help you understand the concepts.

  • July 20, 2006 at 7:58 am

    #650380

    The problem is you are using Outlook 2003. You need to use a version of Outlook that the MAPI client can be spawned up by services. (Ie Outlook 2000). Or if you just want to "test", if you open Outlook2003 and leave it open, you should be able to send the emails.

    Please see http://support.microsoft.com/kb/263556

    That should answer all your questions.

  • July 20, 2006 at 7:01 pm

    #650573

    Thanks all.

    I read the link which Tejwant Kaur gave me yesterday.Then i found the reason why i had troubles with my first server.

    "SQL Mail must run using a mail profile created in the same domain account that is used to start an instance of Microsoft® SQL Server™."

    But another problem is that how can i start an instance of MS SQL Server with the same domain account without recreating the instance,because i started an instance with the local domain account.

    Can u give me any good solutions for that?

  • July 21, 2006 at 1:29 am

    #650594

    If I understood right;

    you can change the SQL service startup account. In SQL 2000 EM right click on related SQL Server, open properties, go security tab, change "Startup service account" to the desired one and restart the service.

    Cheers.

Viewing 12 posts - 1 through 11 (of 11 total)

You must be logged in to reply to this topic. Login to reply