Sending SQL Notifications with CDOSYS

• van800

  Valued Member

  Points: 61

  More actions

  April 1, 2009 at 2:36 pm

  #970229

  I have added several propertities to use google smtp as smtp server

  But I get the error "Description: The server rejected the sender address. The server response was: 530 5.7.0 Must issue a STARTTLS command first. 28sm166958fxm.4"

  It is rather strange cause I enabled SMTPUseSSL

  Does any one have ideas?

  EXEC @hr = sp_OASetProperty @iMsg, 'Configuration.fields("http://schemas.microsoft.com/cdo/configuration/SendUsing").Value','2'

  EXEC @hr = sp_OASetProperty @iMsg, 'Configuration.fields("http://schemas.microsoft.com/cdo/configuration/smtpserver").Value', 'smtp.googlemail.com'

  EXEC @hr = sp_OASetProperty @iMsg, 'Configuration.fields("http://schemas.microsoft.com/cdo/configuration/sendusingport").Value', '465'

  EXEC @hr = sp_OASetProperty @iMsg, 'Configuration.Fields("http://schemas.microsoft.com/cdo/configuration/SMTPUseSSL").Value',True

  -- SMTPAuthenticate

  EXEC @hr = sp_OASetProperty @iMsg,

  'Configuration.Fields("http://schemas.microsoft.com/cdo/configuration/smtpauthenticate").Value',1

  --0 is do not authenticate

  --1 is Use basic (clear-text) authentication. The configuration

  --sendusername/sendpassword or postusername/postpassword fields are used

  --to specify credentials.

  --2 Use NTLM authentication. The current process security context is used

  --to authenticate with the service. Integrated security.

  EXEC @hr = sp_OASetProperty @iMsg,

  'Configuration.Fields("http://schemas.microsoft.com/cdo/configuration/SendUsername").Value','myAdr@gmail.com'

  EXEC @hr = sp_OASetProperty @iMsg,

  'Configuration.Fields("http://schemas.microsoft.com/cdo/configuration/SendPassword").Value','myPass'