Does SQL Mail 2000 require Outlook?
-
I've been trying to get SQL Mail to work in my SQL Server 2000 database (using Exchange 2000). I've assigned a profile associated with a mailbox in Exchange. Then I went into Enterprise Manager, selected the profile in the Profile Name list, and clicked on the test button. I got the following error message:
Error 18025: xp_test_mapi_profile: failed with mail error 0x80040111
I then went to Microsoft's MSDN page and looked up the extended procedure xp_test_mapi_profile and found article Q281293, which strongly suggests that one has to have Outlook 2000 installed on the server that you're going to be running SQL Mail on.
Bottom line: is this true?
Second question: are there other things that have to be present in order for SQL Mail to work, that I don't know about? (I mean, besides the fact that it runs in SQL Server 2000)?
I have checked and I have service pack 3 for SQL Server installed on this particular instance of SQL Server 2000.
Doctor Who -
YES you must need a mail client.
Shas3
-
You do not need Outlook. You could use the Exchange client and seperately create the profile. This is covered in a couple of different KB articles. However, the simplest solution is to install Outlook because it has the Exchange client and it creates the profile.
K. Brian Kelley
http://www.truthsolutions.com/
Author: Start to Finish Guide to SQL Server Performance Monitoring
http://www.netimpress.com/shop/product.asp?ProductID=NI-SQL1
K. Brian Kelley
@kbriankelley -
What is the Exchange Client? And how do I set that up?
Doctor Who
quote:
You do not need Outlook. You could use the Exchange client and seperately create the profile. This is covered in a couple of different KB articles. However, the simplest solution is to install Outlook because it has the Exchange client and it creates the profile.K. Brian Kelley
http://www.truthsolutions.com/
Author: Start to Finish Guide to SQL Server Performance Monitoring
http://www.netimpress.com/shop/product.asp?ProductID=NI-SQL1
Doctor Who -
quote:
You do not need Outlook. You could use the Exchange client and seperately create the profile. This is covered in a couple of different KB articles. However, the simplest solution is to install Outlook because it has the Exchange client and it creates the profile.to piggy-back on Brian (haha, applied knowledge transfer
) in case you utilize Outlook, you have to buy another license unless you haven't a company license. I think even if you only install parts like the Outlook Object Library you need a separate license, because it is not redistributable.Cheers,
Frank
--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url] -
How to create MAPI Profiles without Outlook:
http://support.microsoft.com/default.aspx?scid=kb;EN-US;306962
This article talks about the procedure. Basically, you'd be installing the Exchange server-side MAPI instead of the client-side MAPI of Outlook. Having not done this myself I can only refer you to the KB article. You might be able to solicit some help from your Exchange administrator.
http://support.microsoft.com/default.aspx?scid=kb;EN-US;311231
K. Brian Kelley
http://www.truthsolutions.com/
Author: Start to Finish Guide to SQL Server Performance Monitoring
http://www.netimpress.com/shop/product.asp?ProductID=NI-SQL1
K. Brian Kelley
@kbriankelley
) in case you utilize Outlook, you have to buy another license unless you haven't a company license. I think even if you only install parts like the Outlook Object Library you need a separate license, because it is not redistributable.Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply