I recall reading something about replication in one of the latest SQL Patches - i forget which one it was but it says errors with replication.

Have a look at the...

Take offline and see if anyone complains 🙂

Was this running on the exchange server...........

Do you want to share what spam filter they had on.

I have same thing - i got case open with MS Boys who don't know what it is either.

Sometimes i...

So if anyone is watching this thread put in MS call but after a week of just looking around nothing could be found...then viola it starts working - all jobs...

I think it is more like client - server for reporting services. The client you then connect to the MAIN SQL which creates the databases mentioned.

The 4th box you...

yes exchange server .....

We don;t have any of the mailroot bits that would easy to figure out cause i see the mail in the badmail queue - what we have is mail relay...

Thinking over here - job fires email - then i take it at this stage it sends packet to SMTP and some kind of acknowlegement and then handshakes (forgive the...

If unsent on my end i guess it not left to go to SMTP server ? or would there still be some kind of errors on the SMTP ....

SQL Agent account is domain\account

Well the network guys said they checked DNS just now and viola the email just fired on its own i had given up for the day...

Network guys said - We have not installed SMTP on those servers. If you need to relay messages you just point it to the mail server to relay off...

It might happen if your SMTP virual server authentication is set to Integrated Windows instead of Anonymous.

The "unsent" status is ALWAYS linked to SMTP configuration.

I can't see where the...

If i run the procedure in sql query the databasemail gets started and sends email.

If the job runs the procedure it will not start the databsemail sits in unsent.

The job...

Thanks i am still on this thread - just read every thread from ms.

Does seem odd that it doesn't start up - because this had been working.

Perhaps i had another...