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.
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
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
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.
I am able to use the profile with SQL Mail, but not SQL Server Agent.
ASKER
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.