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.

 All Forums
 SQL Server 2008 Forums
 SQL Server Administration (2008)
 Database Mail Error

Author  Topic 

tracy5436
Yak Posting Veteran

50 Posts

Posted - 2011-08-09 : 11:33:47
I have setup database mail with the following settings :

servername : smtp.gmail.com
Port: 587
This server requires a SSL
Basic authentication using the gmail username and password

When I do a test mail, I receive the following error message "no connection could be made because the target machine actively refused it"

What is causing this ?





tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2011-08-09 : 12:17:35
Are you sure you can connect to that SMTP server over that port? Do a telnet test to check.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog
Go to Top of Page

tracy5436
Yak Posting Veteran

50 Posts

Posted - 2011-08-09 : 16:47:23
What do I type at the telnet prompt?
Go to Top of Page

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2011-08-09 : 18:46:17
telnet smtp.gmail.com 587

If it errors, then that's the problem. If it displays a blank screen, then that's good.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog
Go to Top of Page

tracy5436
Yak Posting Veteran

50 Posts

Posted - 2011-08-10 : 18:42:49
I receive the error "could not open connection to the host on port 587". What could be causing this ?
Go to Top of Page

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2011-08-10 : 18:47:13
Maybe a firewall problem. You'll need to talk with a network admin if the problem is at the network layer or a windows admin if it's a problem at the windows layer.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog
Go to Top of Page

tracy5436
Yak Posting Veteran

50 Posts

Posted - 2011-08-11 : 14:19:39
I got the telnet to work on port 465 but when I change the database mail settings to that I am still receiving the error.
Go to Top of Page

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2011-08-11 : 14:22:55
Is 465 the right port for gmail? I don't know what their SMTP port is, but your config will need to match.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog
Go to Top of Page

russell
Pyro-ma-ni-yak

5072 Posts

Posted - 2011-08-11 : 15:01:45
Are you using your gmail account in the mail profile?
Go to Top of Page
   

- Advertisement -