Activity overview
Latest activity by Carl Corwin
Hi, Telnet is not a SMTP program. Why should I use it ?
And don't tell me that to find a SMTP server you have to telnet it !!!!
The server is able to send SMTP mail, the SQL Agent service is able to send SMTP mail, my own vbscript is able to send SMTP mail too from that server so why I cannot use SQL Backup to send email ?
From that SQL server, I can send email two ways usually, one directly to my SMTP server (external IP with no account needed), the other way is by using the local IIS SMTP domain relay setup on that server.
Please Help ! / comments
Hi,Telnet is not a SMTP program. Why should I use it ?
And don't tell me that to find a SMTP server you have to telnet it !!!!
The server is able to send SMTP mail, the SQL Agent service is able t...
Hi petey,
Thanks for the prompt answer ! ! ! [image]
Our SQL server does not have any firewall onto it.
I have verify our Anti-virus software and SQBCoreService.exe is listed in the allow list of program to send email.
Does the SQL Backup email module has a specific name (.exe) so I can add it to the exception list of programs allow to send email :?:
I have made a test email from Outlook Express and it work.
Even some local WBScripts can send email from that server.
Please advise ! (Thanks in advance) / comments
Hi petey,
Thanks for the prompt answer ! ! !
Our SQL server does not have any firewall onto it.
I have verify our Anti-virus software and SQBCoreService.exe is listed in the allow list of progra...
Socket Error # 10053
Hi,
I try to configure the E-Mail preference and when I try to send the Test Email, I receive the following error message box :
Socket Error # 10053 Software caused connection abort.
Please advise !
Hi Petey,
You're right. My mistake ! ! ! [image]
I've modified the Agent EXEC line, as you've provide, like this :
EXEC master..sqlbackup @backupcmd, @exitcode OUTPUT, @sqlerrorcode OUTPUT
and everything works fine now. No more error. All success ! ! !
Thanks for your help, greatly appreciated ! ! ! [image] / comments
Hi Petey,
You're right. My mistake ! ! !
I've modified the Agent EXEC line, as you've provide, like this :
EXEC master..sqlbackup @backupcmd, @exitcode OUTPUT, @sqlerrorcode OUTPUT
and everythin...
Step 1: Log backup with copy (Error 50000)
Hi,
I'm using a vbscript that generate a SQL Agent for LogShipping using SQL Backup. The agent created is : SQL Backup log shipping <database>
There's only one step into the agent.
Here's the T-SQ...