Activity overview
Latest activity by broughtie
Where's the "Uppercase Keywords" command
I used this all the time in SQL Refactor for code I wanted to make easier to read but didn't want to have layout changes. I figured this would be coming, but its not in the "final" preview version...
Startup errors in SSMS
I uninstalled SQL Prompt 4 as directed before installing SQL Prompt 5, but know when I start up SSMS, I get an error that SQL Refactor 1.5 can't be loaded and it doesn't work. I also still see SQL...
Searching in SQL Agent Job
Unless I'm missing it somehow, it doesn't appear to search in SQL Server agent jobs for my search term, even if I select the master database. Maybe a deliberate version 1.0 shortcoming, but that a...
Ok, having access to the logs is nice, but even that info isn't helping me get email sent. Here is the error in the log:
10:43:42.971|Error |AlertRepository |8 |Error sending test email|System.Net.Mail.SmtpException: Transaction failed. The server response was: 5.7.1 <kevin.broughton@elmlocating.com>: Sender address rejected: Access denied
at System.Net.Mail.RecipientCommand.CheckResponse(SmtpStatusCode statusCode, String response)
at System.Net.Mail.SmtpTransport.SendMail(MailAddress sender, MailAddressCollection recipients, String deliveryNotify, SmtpFailedRecipientException& exception)
at System.Net.Mail.SmtpClient.Send(MailMessage message)
at e.a(a , RepositoryConfiguration , Boolean )
at e.a(String , RepositoryConfiguration , String& )
I've checked and rechecked my settings for SMTP Host, Port, Account User Name, Password, Send From Name, and Test Email address and they are all correct. I have other server software using the same email values fine, in addition the same values work in MS Outlook without problem. Based on the error message above, where do you suppose the problem lies?
P.S. I also have SQL Backup and I'm using the exact same email values in SQL Response as I am in SQL Backup. I copied and pasted all of them except the password which I retyped into both programs. SQL Backup can sent a test email, SQL Response still can't. / comments
Ok, having access to the logs is nice, but even that info isn't helping me get email sent. Here is the error in the log:
10:43:42.971|Error |AlertRepository |8 |Error sending test email|Syst...
Ah, hidden in plain sight. Thanks. / comments
Ah, hidden in plain sight. Thanks.
I'm getting this same error and it also appears to be happening on frequently run jobs. I just download and installed SQL Response yesterday and I'm running version 1.0.0.1596. / comments
I'm getting this same error and it also appears to be happening on frequently run jobs. I just download and installed SQL Response yesterday and I'm running version 1.0.0.1596.
I also have seen a negative job duration in SQL Response, but that isn't what reality reflects in the SQL Agent logs. Haven't seen in this thread the reason for the negative duration. / comments
I also have seen a negative job duration in SQL Response, but that isn't what reality reflects in the SQL Agent logs. Haven't seen in this thread the reason for the negative duration.
Can't get test email to send
I'm in the default template trying to setup my mail server settings so I can receive email alerts. I've checked and rechecked all the fields for setup, and when I try to send a test message, I get...
Type of Incidents To Monitor
I don't see where I can currently display a list of all incident types monitored with their description, so this may be a little redundant, but here are the incident types I'd most like to see (the...
More configurable alert system.
Although other may want more protocols like SNMP, I'm pretty content with just email alerts since I can turn those into voice calls, SMS, etc via other services. That said, even with just email al...