Warning 150: MAILTO Error: SMTP Host not defined

Surinder · October 7, 2008 4:42AM

Hi,

Getting the warning above on one of our servers. The SMTP has been declared in the GUI, and the entries are in the registry on the server.

Sending a test message via the GUI works fine, but non of the alerts work from the server

Surinder..

petey · October 8, 2008 2:37AM

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?

Surinder · October 8, 2008 2:46AM

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?

petey · October 8, 2008 3:58AM

The SQL Backup Agent service startup account needs to have read permissions to that value.

Surinder · October 9, 2008 2:27AM

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.

petey · October 9, 2008 2:43AM

Could you please run the following on the instance where you are receiving the warning:

DECLARE @settings varchar&#40;1024&#41;
EXEC master..sqbutility 1008, @settings OUTPUT
SELECT @settings

Is the SMTPHost value returned?

Surinder · October 9, 2008 2:50AM

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.

petey · October 9, 2008 3:09AM

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

Thanks.

Surinder · October 9, 2008 3:23AM

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"

petey · October 9, 2008 4:06AM

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.

Surinder · October 9, 2008 4:08AM

Nope, the value doesnt change

Surinder · October 9, 2008 4:10AM

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..

Warning 150: MAILTO Error: SMTP Host not defined

Comments

Product Learning

Community Forums

Events & Friends

Simple Talk