Post reply

DB Mail

  • January 25, 2009 at 10:12 pm

    #204534

    Hi

    I am having problem with dbmail.When I am trying to send mail in the event viewer i am getting the error

    Web page returned error: ERRORS

    exec soe.dbo.BlueappsRead error: -2147217911, 'Microsoft OLE DB Provider for ODBC Drivers', '[Microsoft][ODBC SQL Server Driver][SQL Server]EXECUTE permission denied on object 'BlueappsRead', database 'SOE', owner 'dbo'.'

    I stopped and started the dbmail .still same error.Pls help

  • January 26, 2009 at 1:42 am

    #932488

    binu.ma (1/25/2009)

    Hi

    I am having problem with dbmail.When I am trying to send mail in the event viewer i am getting the error

    Web page returned error: ERRORS

    exec soe.dbo.BlueappsRead error: -2147217911, 'Microsoft OLE DB Provider for ODBC Drivers', '[Microsoft][ODBC SQL Server Driver][SQL Server]EXECUTE permission denied on object 'BlueappsRead', database 'SOE', owner 'dbo'.'

    I stopped and started the dbmail .still same error.Pls help

    Make database user dbo in database

    sp_dbowner 'username'

    _____________________________________________________________________________________________________________
    Paresh Prajapati
    ➡ +919924626601
    http://paresh-sqldba.blogspot.com/[/url]
    LinkedIn | Tweet Me | FaceBook | Brijj

  • January 26, 2009 at 5:30 am

    #932531

    Alternatively set execute permissions on the procedure to the user.


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

Viewing 3 posts - 1 through 2 (of 2 total)

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