Warning 150: MAILTO Error: SMTP Host not defined

• 
  The SMTP settings are specific to each SQL Server instance. Could you please check the registry, in the following location:
  
  HKLM\Software\Red Gate\SQL Backup\BackupSettingsGlobal\<instance name>
  
  and see if there is a value for SMTPHost?

  petey October 08, 2008 02:37

  - 0 +
• 
  The value is there. and compared to the other servers all the other values seem correct.
  
  Could it be a permissions problem on the key? what should the security be?

  Surinder October 08, 2008 02:46

  - 0 +
• 
  The SQL Backup Agent service startup account needs to have read permissions to that value.

  petey October 08, 2008 03:58

  - 0 +
• 
  In that case the permissions seem fine. All other settings are being picked up from there, ie. backup location etc. Just not the SMTP host.

  Surinder October 09, 2008 02:27

  - 0 +
• 
  Could you please run the following on the instance where you are receiving the warning:
  

  DECLARE @settings varchar(1024)
  EXEC master..sqbutility 1008, @settings OUTPUT
  SELECT @settings
  

  Is the SMTPHost value returned?

  petey October 09, 2008 02:43

  - 0 +
• 
  No, and looking at the other values that have come back, its not getting any of the settings.
  
  i.e. The SMTPSender, BAckup location is not right as well
  
  SMTPHost= SMTPPort=25 SMTPUserName= SMTPPassword= SMTPSender=SQLBackup@EVSQL BackupFolder=C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Backup BackupFileName= LogDeleteOptions=0 LogDeleteHours=2160 LogDelete=0 LogFolder=C:\Documents and Settings\All Users\Application Data\Red Gate\SQL Backup\Log\(LOCAL)\ MSDBDeleteHours=2160 MSDBDelete=0 MaxDataBlock=0 MaxTransferSize=0 VDITimeout=30 SkipChecks=1
  
  Just checked the settings via the GUI, and it has also gone back to default settings. But the settings in the registry are still correct.

  Surinder October 09, 2008 02:50

  - 0 +
• 
  What is the location in the registry that you are seeing the values? Is this server running a 64-bit Windows?
  
  Thanks.

  petey October 09, 2008 03:09

  - 0 +
• 
  Extract of the registry
  
  Windows Registry Editor Version 5.00
  
  [HKEY_LOCAL_MACHINE\SOFTWARE\Red Gate\SQL Backup\BackupSettingsGlobal]
  
  [HKEY_LOCAL_MACHINE\SOFTWARE\Red Gate\SQL Backup\BackupSettingsGlobal\(LOCAL)]
  "DataPath"="C:\\Documents and Settings\\All Users\\Application Data\\Red Gate\\SQL Backup\\Data\\(local)"
  "ServiceLogin"=""
  "CopiedVersion4Settings"=dword:00000001
  "BackupFolder"="\\\\vipsii\\SQLServerBackups\\<SERVER>\\<DATABASE>\\"
  "BackupFileName"="<TYPE>_<SERVER>_<DATABASE>_<DATETIME yyyymmdd_hhnn>"
  "LogFolder"="C:\\Documents and Settings\\All Users\\Application Data\\Red Gate\\SQL Backup\\Log\\(LOCAL)\\"
  "LogDelete"=dword:00000000
  "LogDeleteHours"=dword:00000870
  "LogDeleteOptions"=dword:00000000
  "MSDBDelete"=dword:00000000
  "MSDBDeleteHours"=dword:00000870
  "SMTPHost"="Mail"
  "SMTPPort"=dword:00000019
  "SMTPUserName"=""
  "SMTPPassword"=""
  "SMTPSender"="SQL-RG@EVSql"
  
  
  The server is "Windows 2003 R2 Enterprise x32"

  Surinder October 09, 2008 03:23

  - 0 +
• 
  Could you please run the following:
  

  EXEC master..sqbutility 1040, 'SMTPHost', 'RGTEST.COM'
  

  and check if the value for SMTPHost in the registry is changed? Thanks.

  petey October 09, 2008 04:06

  - 0 +
• 
  Nope, the value doesnt change

  Surinder October 09, 2008 04:08

  - 0 +
• 
  I have granted the RG Backup service "Full Access" to this registry location. Now the SP does change the value as expected
  
  Just done a test run and the alerts are coming through now as expected.
  
  Thanks,
  Surinder..

  Surinder October 09, 2008 04:10

  - 0 +

Add comment

Please sign in to leave a comment.