Inbound Emails arrive in queue - can't connect to SQL Server to post

Reply

|

Contact

By: jenp

Posted: Wed, Apr 4 2007 2:55 PM

Odd one this - we're running on SQL Express 2005 (a development instance on the same machine as CS), and can't seem to establish a connection to it.

 We can connect to the database when looking at the outgoing email queue, and outgoing emails send just fine. The emails also come in just fine, and sit in the correct queue. The normal processor log file (not the error one) then reports the 'cannot connect to the remote instance, this is turned off by default etc.' message - which could indicate an incorrect connection string, but the outbound email service uses exactly the same string - or does it?

 We're using Windows Authentication if that makes any difference - am I right to assume the processor service is connecting as NT AUTHORITY\SYSTEM? We've given db_datareader and db_datawriter access to it - but since the connection isn't even established I don't think this is a permissions issue.

 So basically, is there any reason that outgoing mail could connect to SQL Server, but the incoming mail service not?

• Post Points: 5 |