January 19, 2006 at 6:00 am
Please tell me how to setup the SQL mail service...in SQL2k
is it necessary to have MS Exchange server in the SQL Server machine
Kindly suggest
Deepak
January 19, 2006 at 7:43 am
You need a MAPI based mail client, like MS Outlook
January 19, 2006 at 7:56 am
Thanks for the response...I have got Outlook Express as default mail client in my server.... can i set the SQL mail only with this....
Can u pls guide me....
Deepak
January 19, 2006 at 8:22 am
YOu need to use MS Office Outlook.
check out this link - it takes you through all the steps you need to do:
http://support.microsoft.com/kb/263556/EN-US/
best of luck!
January 19, 2006 at 10:03 pm
Thanks....Hope this would work...
January 20, 2006 at 4:31 am
Also check the account you are running your sqlserver service
January 20, 2006 at 8:14 am
There are several other ways available to you that deal with a SMTP Server and extended stored procs. This to me, is the only way with SQL 2000 and has been brought forward with SQL 2005.
http://support.microsoft.com/default.aspx?scid=kb;en-us;263556
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/adminsql/ad_1_server_8xf0.asp
http://support.microsoft.com/default.aspx?scid=kb;en-us;312839
My favorite for SQL 2000 would be xp_smtpmail. Google it!
January 20, 2006 at 9:27 am
Sorry... I meant xp_smtp_sendmail - google it!
Viewing 8 posts - 1 through 7 (of 7 total)
You must be logged in to reply to this topic. Login to reply