January 25, 2009 at 10:12 pm
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
binu.ma (1/25/2009)
HiI 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'
January 26, 2009 at 5:30 am
Alternatively set execute permissions on the procedure to the user.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply