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 |
|
Vack
Aged Yak Warrior
530 Posts |
 Posted - 2010-08-11 : 15:08:50
|
| What port needs to be open for SQL 2008 Database mail to work?I have successfully setup database mail on a SQL 2008 server on one box. But I have another user that has shut down just about all of their ports and I can't seem to get the mail to work on their box.I've tried port 25, 1433 and 80 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
jackv
Master Smack Fu Yak Hacker
2179 Posts |
Posted - 2010-08-11 : 15:27:39
|
| Assuming the server name is correct - check the parameters on the system a)port number : is it open on the firewall? is it being blocked?b)check authenticationJack Vamvas--------------------http://www.sqlserver-dba.com |
 |
|
|
Vack
Aged Yak Warrior
530 Posts |
Posted - 2010-08-11 : 15:27:56
|
| That port is 25 and its been opened. Can you think of anything else besides a port that may be preventing it?I'm using the same SMTP account info on both servers which are pretty much identical. both windows 2008 with SQL server 2008 installed. |
|
|
|
jackv
Master Smack Fu Yak Hacker
2179 Posts |
Posted - 2010-08-11 : 15:42:45
|
| Could you doublecheck the account has sufficient permissions to relay email on the SMTP server.A couple of other ideas:a)can you get the SMTP handshake output?b)Are you sql server startup accounts the same as your other server?Jack Vamvas--------------------http://www.sqlserver-dba.com |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
|
|
|
database mail port