Unable to configure SQL Agent Mail profile.  
Author Message
runcyclexcski





PostPosted: Wed Aug 04 05:01:10 CDT 2004 Top

SQL Server >> Unable to configure SQL Agent Mail profile.

I've configured my MSSQL server and MSSQLAgent services start up account with "sqladminlocal" which has local admin rights and system administrator role in SQL. And I've configured Outlook on that server with a domain user account "sqladmin" which is added into local Administrator group of that server and it is also an account in Exchange server.

The problem is each time I want to configure the SQLAgent Mail Profile, there will be an error prompted "Error 22022:SQL Server Agant Error:Unable to get the default MAPI Message store due to MAPI error 273:The information store could not be opened. Could you please advise me on this problem.

Thanks.

SQL Server289  
 
 
Alexander





PostPosted: Wed Aug 04 05:01:10 CDT 2004 Top

SQL Server >> Unable to configure SQL Agent Mail profile. Hi Alida,

try to start the sql server ad the domain user, who has got the mail
account.
The local admin user is not allowed to use the profile of a domain user I
think.
This might be the reason for your trouble with the mail things.

Hope it helps you!

Regards
Alexander


> I've configured my MSSQL server and MSSQLAgent services start up account
with "sqladminlocal" which has local admin rights and system administrator
role in SQL. And I've configured Outlook on that server with a domain user
account "sqladmin" which is added into local Administrator group of that
server and it is also an account in Exchange server.
>
> The problem is each time I want to configure the SQLAgent Mail Profile,
there will be an error prompted "Error 22022:SQL Server Agant Error:Unable
to get the default MAPI Message store due to MAPI error 273:The information
store could not be opened. Could you please advise me on this problem.
>
> Thanks.


 
 
Guest





PostPosted: Thu Jun 09 03:59:49 CDT 2005 Top

SQL Server >> Unable to configure SQL Agent Mail profile.

> I've configured my MSSQL server and MSSQLAgent services start=
up account with "sqladminlocal" which has local admin rights and=
system administrator role in SQL. And I've configured Outlook on=
that server with a domain user account "sqladmin" which is added=
into local Administrator group of that server and it is also an=
account in Exchange server.
>
> The problem is each time I want to configure the SQLAgent Mail=
Profile, there will be an error prompted "Error 22022:SQL Server=
Agant Error:Unable to get the default MAPI Message store due to=
MAPI error 273:The information store could not be opened. Could=
you please advise me on this problem.
>
> Thanks.
User submitted from AEWNET (http://www.aewnet.com/)
 
 
Wojtek





PostPosted: Thu Jun 09 06:25:08 CDT 2005 Top

SQL Server >> Unable to configure SQL Agent Mail profile.



> I've configured my MSSQL server and MSSQLAgent services start up account
> with "sqladminlocal" which has local admin rights and system administrator
> role in SQL. And I've configured Outlook on that server with a domain user
> account "sqladmin" which is added into local Administrator group of that
> server and it is also an account in Exchange server.
>
> The problem is each time I want to configure the SQLAgent Mail Profile,
> there will be an error prompted "Error 22022:SQL Server Agant Error:Unable
> to get the default MAPI Message store due to MAPI error 273:The
> information store could not be opened. Could you please advise me on this
> problem.

Run Outlook under SQLServer account.

Regards, Wojtek