How can we help you today? How can we help you today?

MAILTO via stored procedure

Using this command via QA, I'm receiving error 150: SMTP host name not defined. The same command via sqlbackupc and the SMTP test in the GUI work fine.

master..sqlbackup '-SQL "BACKUP DATABASE [ISI] TO DISK = [d:\sql_data\MSSQL\BACKUP\<AUTO>] WITH LOGTO = [d:\sql_data\MSSQL\BACKUP\Logs\], MAILTO = ''<my email>''" -E'
Ulfius
0

Comments

2 comments

Sort by
  • petey
    The SMTPHost setting is stored in the registry key HKEY_LOCAL_MACHINE\SOFTWARE\Red Gate\SQLBackup\BackupSettingsGlobal\SMTPHost. Pls check if the SQL Server service startup account has rights to the entire HKEY_LOCAL_MACHINE\SOFTWARE\Red Gate\SQLBackup node.
    petey
    0
  • Ulfius
    This fixed the problem. I believe since my SQL Server service account is a domain account and not a local account, it could not read the key.
    Ulfius
    0

Add comment

Please sign in to leave a comment.