MAPI profil

Hi,
I try e-mail through SQL Server. I have Outlook 2000 installed, MAPI profile created. If I want test it, SQL Server displays this error:
Error 18030: xp_test_mapi_profile : Either there is no default mail client or the current mail client cannot fulfill the messaging request. Please run Microsoft Outlook and set it as the default mail client.
Can me sombody help, thanks.Hi
You need to login as the SQL Agent on the machine, configure outlook, log
off and re-start SQL Agent.
See the following KB article on exactly how to do it.
http://support.microsoft.com/default.aspx?scid=kb;en-us;263556&Product=sql2k
--
Mike Epprecht, Microsoft SQL Server MVP
Epprecht Consulting (PTY) LTD
Johannesburg, South Africa
Mobile: +27-82-552-0268
IM: mike@.NOSPAMepprecht.net
Specialist SQL Server Solutions and Consulting
"Ondrik" <anonymous@.discussions.microsoft.com> wrote in message
news:80987291-A063-4B4A-BBDB-6DC363DD2849@.microsoft.com...
> Hi,
> I try e-mail through SQL Server. I have Outlook 2000 installed, MAPI
profile created. If I want test it, SQL Server displays this error:
> Error 18030: xp_test_mapi_profile : Either there is no default mail client
or the current mail client cannot fulfill the messaging request. Please run
Microsoft Outlook and set it as the default mail client.
> Can me sombody help, thanks.|||Hmmm, it is terrible. I have it so done. Same domain account for log on machine, SQL Server and SQL Agent. What mean in error message: "Please run Microsoft Outlook and set it as the default mail client." How? I don't want reinstall server.

MAPI Error 22022 in SQL Server 2000

When I try to test the ability to send e-mail to an operator on one of my servers by opening up the properties for the operator and clicking the "test" button, I get the following error:

"Error 22022: SQLServerAgent Error: MAPI error: Table too big."

Has anyone encountered this? What's the resolution?

Can you log in to the server using the same account that the SQL Server Agent is using and send emails that way? If so, try deleting and recreating the pst file for that user.

BTW - you'll likely receive more feedback from another group. This one is dedicated to Notification Services, which despite the similar sounding name, is a completely different technology.

HTH...

Joesql

MAPI Error 22022 in SQL Server 2000

When I try to test the ability to send e-mail to an operator on one of my servers by opening up the properties for the operator and clicking the "test" button, I get the following error:

"Error 22022: SQLServerAgent Error: MAPI error: Table too big."

Has anyone encountered this? What's the resolution?

Can you log in to the server using the same account that the SQL Server Agent is using and send emails that way? If so, try deleting and recreating the pst file for that user.

BTW - you'll likely receive more feedback from another group. This one is dedicated to Notification Services, which despite the similar sounding name, is a completely different technology.

HTH...

Joe