Problem with e-mail

• 
  Did you check if your smtp server requires authentication? Also try using the IP address of the smtp server instead of the host name.

  petey August 06, 2005 08:14

  - 0 +
• 
  Already checked - the SMTP server doesn't require authentication and have tried using IP instead of name.

  rlindsay August 06, 2005 08:41

  - 0 +
• 
  Strange. Any firewall/router rules preventing SQL Backup from connecting externally to port 25 because it's not a recognized e-mail client?

  petey August 06, 2005 09:25

  - 0 +
• 
  No, nothing preventing external access and it doesn't work with a local SMTP server either. The fact that I can telnet to the local and external SMTP servers also indicates that it isn't a firewall issue.

  rlindsay August 06, 2005 10:34

  - 0 +
• 
  Try renaming telnet.exe to sqlbackup.exe, and see if you can still connect to the smtp server using this renamed telnet app.

  petey August 06, 2005 12:47

  - 0 +
• 
  Using the renamed file to telnet to SMTP servers works OK.

  rlindsay August 06, 2005 13:04

  - 0 +
• 
  Hello,
  
  You may want to try enabling logging for the SMTP server and find the reason for failure there. In IIS and Exchange, it's a matter of looking at the properties of the SMTP virtual server, and clicking the 'enable logging' checkbox. This will write a text log to (default) %SYSTEMROOT%\system32\logfiles\smtpsvc1.
  
  If you are using your site's Exchange server to send mail, you will most likely have the IP addresses which can relay mail limited as much as possible. You'll want to make sure that the mail server allows relay from your SQL Server's IP address.

  Brian Donahue August 06, 2005 16:50

  - 0 +
• 
  I already have logging turned on for my local SMTP virtual server and there are no log file entries generated.
  
  I do use a few different network cards in this laptop - could it be trying to use a device that isn't available?

  rlindsay August 07, 2005 14:06

  - 0 +
• 
  >> I do use a few different network cards in this laptop - could it be trying to use a device that isn't available?
  
  Perhaps. Did you try disabling the non-active NICs' and see if SQB can contact the SMTP server?

  petey August 07, 2005 22:37

  - 0 +
• 
  I have disabled all of the NICs apart from the current acive NIC but it still doesn't work.

  rlindsay August 08, 2005 07:50

  - 0 +
• 
  Maybe the SMTP virtual server isn't listening on the correct interface. That certainly would explain why there is no SMTP log. Even if the client connects and simply says HELO there should be something in that log.
  
  Have you though about looking at the SMTP virtual server configuration and changing the address to 'All Unassigned'?

  Brian Donahue August 08, 2005 11:19

  - 0 +
• 
  Its currently on 'All Unassigned' and I do get activity in the log if I telnet into the server and can complete a full mail session, I just don't get activity when using the SQL Backup utility and the error message appears.

  rlindsay August 08, 2005 11:51

  - 0 +
• 
  anybody?

  rlindsay August 11, 2005 05:22

  - 0 +
• 
  Have you tried telling SQL Backup to use the IP address of the other network interface?

  Brian Donahue August 12, 2005 12:28

  - 0 +
• 
  Brian,
  
  There is only one interface enabled and the problem also happens with external SMTP servers. The problem seems to be with SQL Backup picking the correct interface to use for communications.

  rlindsay August 15, 2005 04:26

  - 0 +
• 
  Hello,
  
  Just checking, but is Peter working with you directly on this issue now?

  Brian Donahue August 15, 2005 11:42

  - 0 +
• 
  Brian,
  
  Yes he was but haven't heard anything since Friday morning.

  rlindsay August 15, 2005 11:49

  - 0 +

Add comment

Please sign in to leave a comment.