Tried to find a fix on here for my issue but everything I've found re the above problem me and my team have eliminated so was wondering if someone else could suggest something?
I've just installed SQL Server 2008 R2 on a new virtual server (VM Ware) running Windows Server 2008 R2 Enterprise which was installed from an image of another virtual server which I also installed SQL Server on which performs perfectly.
The SQL Server install has gone fine however, I've set up database mail and used exactly the same settings and configurations as the previous server but keep getting the following error/exception message when I try to send a test email through SSMS:
"The mail could not be sent to the recipients because of the mail server failure.......Exception message: Could not connect to mail server (No such host is known)"
Things we've looked into:
Correct spelling of everything
Tested port 25 is open
No antivirus on virtual server to block connection
Antivirus on Exchange server allows connections via port 25
Other servers with the same database mail setup can send and receive test emails
Can telnet to Exchange server from virtual server
Can ping Exchange server from virtual server
We're at a bit of a loss, can anyone suggest anything please?
MCTS - E-Business Card
Try not! Do or do not, there is no try
Personal Website: www.markallen-online.co.uk
Business Website: www.weekendwebdesign.co.uk