Skip to content
  • Categories
  • Recent
  • Tags
  • Popular
  • World
  • Users
  • Groups
Skins
  • Light
  • Cerulean
  • Cosmo
  • Flatly
  • Journal
  • Litera
  • Lumen
  • Lux
  • Materia
  • Minty
  • Morph
  • Pulse
  • Sandstone
  • Simplex
  • Sketchy
  • Spacelab
  • United
  • Yeti
  • Zephyr
  • Dark
  • Cyborg
  • Darkly
  • Quartz
  • Slate
  • Solar
  • Superhero
  • Vapor

  • Default (No Skin)
  • No Skin
Collapse
Code Project
  1. Home
  2. Database & SysAdmin
  3. Database
  4. Mail sending problem from sql server URGENT

Mail sending problem from sql server URGENT

Scheduled Pinned Locked Moved Database
htmlsharepointdatabasesql-servercom
3 Posts 3 Posters 0 Views 1 Watching
  • Oldest to Newest
  • Newest to Oldest
  • Most Votes
Reply
  • Reply as topic
Log in to reply
This topic has been deleted. Only users with topic management privileges can see it.
  • T Offline
    T Offline
    Tridip Bhattacharjee
    wrote on last edited by
    #1

    i have configure the mail in sql server but when i am sending mail from sql server it is showing mail queue message but i am not getting the mail. i also grant the permission to msdb.dbo.sp_send_dbmail sp for public. my mail sending code as follows. EXEC msdb.dbo.sp_send_dbmail @recipients='test@bba-reman.com', @subject = 'test', @body = 'Test', @body_format = 'HTML'; i just do not understand why i am not getting mail where as i am getting mail queue message when sending. please guide me.

    tbhattacharjee

    A S 2 Replies Last reply
    0
    • T Tridip Bhattacharjee

      i have configure the mail in sql server but when i am sending mail from sql server it is showing mail queue message but i am not getting the mail. i also grant the permission to msdb.dbo.sp_send_dbmail sp for public. my mail sending code as follows. EXEC msdb.dbo.sp_send_dbmail @recipients='test@bba-reman.com', @subject = 'test', @body = 'Test', @body_format = 'HTML'; i just do not understand why i am not getting mail where as i am getting mail queue message when sending. please guide me.

      tbhattacharjee

      A Offline
      A Offline
      Amu_27
      wrote on last edited by
      #2

      Are you sure your smtp works as expected and not blocked from the subnet you trying to send the email? You need dbMailUser permission for the id that trying to send email under msdb as well. Please confirm. Thank you. Amit...

      1 Reply Last reply
      0
      • T Tridip Bhattacharjee

        i have configure the mail in sql server but when i am sending mail from sql server it is showing mail queue message but i am not getting the mail. i also grant the permission to msdb.dbo.sp_send_dbmail sp for public. my mail sending code as follows. EXEC msdb.dbo.sp_send_dbmail @recipients='test@bba-reman.com', @subject = 'test', @body = 'Test', @body_format = 'HTML'; i just do not understand why i am not getting mail where as i am getting mail queue message when sending. please guide me.

        tbhattacharjee

        S Offline
        S Offline
        Simon_Whale
        wrote on last edited by
        #3

        which version of SQL server are you using?

        As barmey as a sack of badgers Dude, if I knew what I was doing in life, I'd be rich, retired, dating a supermodel and laughing at the rest of you from the sidelines.

        1 Reply Last reply
        0
        Reply
        • Reply as topic
        Log in to reply
        • Oldest to Newest
        • Newest to Oldest
        • Most Votes


        • Login

        • Don't have an account? Register

        • Login or register to search.
        • First post
          Last post
        0
        • Categories
        • Recent
        • Tags
        • Popular
        • World
        • Users
        • Groups