Post reply

Installation software needs befor configure dbMail in sql server 2005

  • February 9, 2009 at 4:44 am

    #134530

    Hi friends,

    I am using Asp.Net 2.0 application. I need to send mail through stored procedures.

    I know that config dbmail we can get the sp_send_dbmail inbuilt procedure.But i dont have

    in my database that is msdb. I need to config dbMail. For config go to Management in the

    sql server 2005.But i dont have dbmail config in the Management. What can i do?? Is any

    software need to be installed for sql server 2005 to config dbmail. Kindly give me a

    suggestion. Its very urgent. I am wasting one day to config dbmail.

    Hope your's reply.

    Thanks & Regards

  • February 9, 2009 at 5:01 am

    #940390

    Hi Ashok,

    I hope the following would be of help to you and also not too late.....

    The option for enabling the mail option could be done by configuring the database mail services using the sp_configure

    use the following script and execute

    sp_configure 'Database Mail XPs',1

    reconfigure

    after which do a small test using the following

    xp_sendmail 'email'

    hope it was of help.

  • February 9, 2009 at 5:23 am

    #940398

    Hi dude,

    Thanks for your reply.

    I execute ,

    sp_configure 'Database Mail XPs',1

    reconfigure

    Msg 15123, Level 16, State 1, Procedure sp_configure, Line 78

    The configuration option 'Database Mail XPs' does not exist, or it may be an advanced option.

    Valid configuration options are:

    I got the above output. Its not working. 🙁

  • February 9, 2009 at 5:33 am

    #940401

    hi ashok,

    I feel firstly you have to run before you run dan's script.

    EXEC sp_configure 'show advanced option', '1';

    RECONFIGURE;

    EXEC sp_configure;

    Hope this helps.

    Sriram

  • February 9, 2009 at 5:39 am

    #940404

    hi friend,

    Thanks I think i am near from output. I asked my question this one. what is this error.

    What software i need to install to send mail.? kindly give me a suggestion

    DBCC execution completed. If DBCC printed error messages, contact your system administrator.

    Configuration option 'show advanced options' changed from 1 to 1. Run the RECONFIGURE statement to install.

    I got above exception.

    Regards

    Ashok

  • February 9, 2009 at 7:20 am

    #940466

    EXEC sp_configure 'show advanced option', '1';

    RECONFIGURE;

    EXEC sp_configure 'Database Mail XPs',1

    reconfigure

    EXEC sp_configure 'show advanced option', '0';

    RECONFIGURE;


    Shamless self promotion - read my blog http://sirsql.net

  • February 9, 2009 at 10:34 pm

    #940975

    Hi friend,

    i got the same exception. Could you tell please details??

  • February 10, 2009 at 2:10 am

    #941017

    Ashok,

    go to the Surface Area Configuration settings under the Configuration tools of MS server 2k5 and select the Surfacr Area Configurations for features.

    There go and select the one which says Database mail under the database engine icon. Click Apply to activate that.

    Then run the config scripts...give it a try....

  • February 10, 2009 at 5:58 am

    #941114

    ashok (2/9/2009)

    hi friend,

    Thanks I think i am near from output. I asked my question this one. what is this error.

    What software i need to install to send mail.? kindly give me a suggestion

    DBCC execution completed. If DBCC printed error messages, contact your system administrator.

    Configuration option 'show advanced options' changed from 1 to 1. Run the RECONFIGURE statement to install.

    I got above exception.

    Regards

    Ashok

    This is not an exception, rather an informational message.


    Shamless self promotion - read my blog http://sirsql.net

Viewing 9 posts - 1 through 8 (of 8 total)

You must be logged in to reply to this topic. Login to reply