Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

SQL 2000 Agent & Outlook / Exchange 2003

Status
Not open for further replies.

mutley1

MIS
Jul 24, 2003
909
Morning all,

Not sure if this is SQL Agent or Exchange 2003 and it's a bizarre one but wondered if anyone has come across it.

We have a domain account running all SQL servces. We have Outlook installed and the profile set up for the domain account. All was working fine and has been for years, but the other day they migrated the mail from Exchange 5.5 to 2003. Since then it has been flaky with our alerts. We changed the profile to point to the correct server, tested after restarting SQL agent and some servers were fine, some were saying mail sent but nothing arrived and some just didn't want to play (Login to MS Exchange server failed).

Strage part - take 1 server. Logging onto the machine as the domain account running SQL services, I open Outlook and if gets login failed message. I open EM, test and it sends a test (and is still sening alert mails that are set up). Bear in mind opening outlook gives the error "Login failed), if i stop the SQL agent then outlook opens fine.

Take server 2. Same SQL SP (SP4) no difference and it just will not do anything. It will work for about 2 minutes if we kill off any MAPI23SP.exe processes, log off, log in, restart SQL Agent, then it gives up the ghost even with test emails where the other one worked.

Anyone come across this?

Thank in advance if anyone can get me out of this as i am positive it isn't SQL.

M.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top