SQL Mail Issues -- sql server notification services

Yoda
2/12/2006 4:36:27 AM

Hi,

I am having problems with SQL Mail on a Windows 2003 Enterprise server with
SQL 2000 sp4 installed. I've got Outlook 2002 sp2 installed as well.

I've created a domain account used by sql and also created an exchange
mailbox using this sql account. The MSSQLServer and SQLSERVERAGENT also uses
this domain account to start. I've also logged in as this account and
created a mapi profile.

When I go into enterprise manager and try and configure the SQL Agent for
email notifications it comes up with the follwong error: -

Error 220022:SQLServerAgent Error:Unable to get the default MAPI Message
Store due to MAPI error 272:The Information store could not be opened.

Has anyone seen this before as I've tried what was suggested in the
microsoft articles regarding sql configuring etc.

Thanks for your help

Joe Webb
2/13/2006 8:09:00 AM

You'll probably have more luck in the
microsoft.public.sqlserver.server.

For example:
http://groups.google.com/group/microsoft.public.sqlserver.server/browse_thread/thread/b26a23cdb5a48233/4b3ed88a39c1ed8b?lnk=st&q=sql+server+2000+mail+information+store&rnum=4#4b3ed88a39c1ed8b

Good luck!

--
Joe Webb
SQL Server MVP
http://www.sqlns.com

~~~
Get up to speed quickly with SQLNS
http://www.amazon.com/exec/obidos/tg/detail/-/0972688811

I support PASS, the Professional Association for SQL Server.
(www.sqlpass.org)

On Sun, 12 Feb 2006 04:36:27 -0800, "Yoda"
[quoted text, click to view]

Got something to say? Click here to post a reply to this thread.

Don't see what you're looking for? Try a search.

View other messages about sql server notification services

sql server notification services : SQL Mail Issues