MS SQL Server - SQL Mail Issues

Author

SQL Mail Issues

Yoda

2006-02-12, 7:23 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:SQLServerAgen
t 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

2006-02-12, 1:23 pm

1. Log on to the server as the account you are using in SQL Server Agent.

2. You've already created the profile, so open Outlook and make sure
that you can access the mailbox. If that's successful, then...

3. Open Enterprise Manager. Expand Support Services. Right-click SQL
Mail. Select Properties. Select the profile that you created in Outlook.
Test the connection. If that's successful, then...

4. Expand Management. Right-click SQL Server Agent. Select Properties.
Select the Mail Profile that you created in Outlook. Test the Profile.
If that's successful, then...

5. Expand SQL Server Agent. Select Operators. Create the desired
Operator. Send a test message.

Also, look that the following KB article:
http://support.microsoft.com/defaul...b;en-us;Q315886

Read the second bullet comment in the "Check Your Configuration" section.

Yoda wrote:
> 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:SQLServerAgen
t 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
>

Jens

2006-02-12, 1:23 pm

This could be a problem if you are using a local file store for offline
synchronisation or a pst file which isn=B4t accessible at runtime for
the SQL Server agent, but which is accessible at interactive logon (at
creation time of the mapi profile). Try to look if the ost / pst file
resists on a network share. Best thing would be to get rid of using a
ost for this service account, just polling the results directly from
the server.

HTH, jens Suessmeyer.

Sponsored Links