all groups > sql server connect > april 2004 >
You're in the

sql server connect

group:

SQL Mail, MAPI clients and Outlook from Office 2003


SQL Mail, MAPI clients and Outlook from Office 2003 David Lightman Robles
4/18/2004 9:22:20 PM
sql server connect:
I have SQL Server 2000 running on a Windows 2000 Server. I have Outlook
(from Office 2000) installed on the server and set a mapi profile for using
SQL mail. This configuration is running ok. I once tried to install Outlook
XP but since it was not a mapi-compliant client that configuration didn't
work and I had to go back to Outlook 2000. We are now upgrading all our
clients to Office 2003 and I want to know if I can upgrade the server too.

Will SQL mail work with Outlook from Office 2003? Has someone tried this
configuration? Will I still need to use Outlook 2000 for this purpose on the
server until the end of time?

Regards.

Re: SQL Mail, MAPI clients and Outlook from Office 2003 SqlJunkies User
6/16/2004 9:53:09 AM
In answer to your question:

Yes you can install MS Office 2003 using Outlook 2003, however there is a microsoft know issue with MS Outlook 2003 and SQL Mail. In order to use SQL Mail, Outlook has to be running on the server AT ALL TIMES or SQL Mail or xp_sendmail will not work. The MAPI communication is severed between Outlook and SQLServerServices. The work-a-around is to have MS Outlook mail in the startup folder so that it will alway start when for whatever reason the server is taken down for backup or whatever.

Hope this helps!

---
Posted using Wimdows.net NntpNews Component -

Re: SQL Mail, MAPI clients and Outlook from Office 2003 SqlJunkies User
6/21/2004 12:29:26 PM
Please post KB Article link for this issue. We are having the same problem.

Thanks!

---
Posted using Wimdows.net NntpNews Component -

RE: SQL Mail, MAPI clients and Outlook from Office 2003 evanwiley
8/13/2004 11:01:03 AM
yes i have done the same. There is a tech article on this. you need to go to
windows system32 dir at a dos prompt and run fixmapi.exe which restores your
mapi dll back to the one compatable with SQL and ms exchange. the outlook
2003 one is to new for exchange and sql.

Evan Wiley
evanwiley@evanwiley.com

[quoted text, click to view]
AddThis Social Bookmark Button