SQL Mail worked as of last Friday - Now Its DOA !!

[JayKusch]

Morning Folk ...

Here is my situation. Had SQL Mail configured and working great. Seems we moved to Exchange Server 2003 over the weekend and now SQL Mail is down. Here is the error message returned:

Server: Msg 18025, Level 16, State 1, Line 0
xp_sendmail: failed with mail error 0x8004010f

Here is the test command I am using:

EXEC MASTER..xp_sendmail
@Recipients = 'MyName@MyCom.com',
@Message = 'this is a test message',
@Copy_Recipients = 'MyName@MyCom.com',
@Subject = 'This is the test subject ...'

I am able to go to Support Services..SQL Mail in Enterprise Manager and am able to test the profile that has been in place all along and it tests out fine.

I am able to email out thru the server using Outlook w/ no issues. The Profile is still set up on the Domain Account that starts SQL Server and The SQL Server Agent service.

Any Ideas?


Thanks

J. Kusch

 

[JayKusch]

OK ... solved my issue. We basically dropped and recreated the MAPI profile account. The NT Admin made sure the appropriate rights were in place. We then let it propogate the Active Directory which took about 15 minutes. I then stopped and restarted SQL Server, and the agent for good measure. It came up working like a champ.



Thanks

J. Kusch