Link to home
Start Free TrialLog in
Avatar of awilson1111
awilson1111

asked on

SQL Server Agent Mail Profile fails

I am trying to configure my SQL Server 7 to use Exchange to send email messages.

ON the SQL Server Agent Properties General tab I select MS Exchange Service and click Test and I get this message

"Microsoft SQL-DMO (OBDC SQL State: 4200)

Error 22030: A MAPI error (error number:273) occurred: MapiLogonEx Failed due to MAPI error 273:MAPI Logon fialed."

I have configured an email account on the server through Outlook 2000 for the same domain user that MSSQL Server service and SQLServerAgent use to start with. I have successfully sent email to and from the account.
ASKER CERTIFIED SOLUTION
Avatar of nigelrivett
nigelrivett

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of awilson1111
awilson1111

ASKER

I am not sure what this step means:

On your SQL Server machine, create a new profile for the Exchange service. This profile needs to be
setup using the Connect to Network option.


My SQL Server and Exchange are on the same machine.
I just re-read your response and realized something, I am not configuring SQL Mail at this time, I am trying to configure SQL Server Agent, it is part of an exercize in the MOC 832 manual. I took the class a few months ago and I am now going back through them in prep for the test.

I am able to use the profile with SQL Mail, but not SQL Server Agent.