Outlook 2003 and SQL 2000 SP4

Question

Post reply

Outlook 2003 and SQL 2000 SP4

Tejwant Kaur-333539

SSCommitted

Points: 1647
More actions
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

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

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

Zubeyir SSCrazy Points: 2559 More actions · Answer 1

Surely it works, but you need to do followings:

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

That's all.

Edward W. Stanley SSCertifiable Points: 6512 More actions · Answer 2

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.

Cao Thanh Xuan SSC Veteran Points: 232 More actions · Answer 3

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.....

Tejwant Kaur-333539 SSCommitted Points: 1647 More actions · Answer 4

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?

Cao Thanh Xuan SSC Veteran Points: 232 More actions · Answer 5

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....

Tejwant Kaur-333539 SSCommitted Points: 1647 More actions · Answer 6

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?

Cao Thanh Xuan SSC Veteran Points: 232 More actions · Answer 7

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!!!

Tejwant Kaur-333539 SSCommitted Points: 1647 More actions · Answer 8

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.

Ron Aughenbaugh SSC Eights! Points: 975 More actions · Answer 9

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.

Cao Thanh Xuan SSC Veteran Points: 232 More actions · Answer 10

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?

Zubeyir SSCrazy Points: 2559 More actions · Answer 11

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.