Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
cidr
Posting Yak Master
207 Posts |
 Posted - 2011-09-01 : 07:10:22
|
| Hi folks, hope everyone is wellI have recently for the first time set up database mail in SQL server 2008.However when I test to see if I can send the mail by right clicking databaseMail icon in management studio and selecting 'Send Test EMail'.the mail could not be sent to the recipients because of the mail server failure.(sending mail using account 1 (2011-09-01T11:10:59)Exception message: could not connect to mail server. (an attempt was made to access a socket in a way forbidden by it's access permissions 10.226.1.23:25 )Does anyone know what the best ways are to troubleshoot this or has anyone any personal experience with this error.I'm in the mind that it's something to do with permissions or SMTP accounts but I don't know enough about SMPT. If it's basic authentication, do I type the username and password of the physical server? Or is there somewhere in SMPT where a username and password is specified that I can use? What other things could I check? (i.e SMTP port number, IP address etc?)The folks that are responsible for the SMTP aren't here and I need to sort this out as soon as I canCan anyone be so kind to help me?Many thanks |
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2011-09-01 : 11:22:52
|
| Need to allow SMTP relay at the mail server from you SQL box. |
 |
|
|
cidr
Posting Yak Master
207 Posts |
Posted - 2011-09-01 : 13:52:51
|
| Thanks for the response Russel. Turns out, everything was working and it was the antivirus. So had to make an exception to allow the exe's to run LOL |
|
|
|
|
|
|
database mail error