Database Mail

[bikerboy718]

I am having an issue running the sp_send_dbmail from a non sysadmin account. I am running SQL Server 2008 R2 SP1. I gave the user permissions to the DatabaseMailUserRole under the msdb database however anytime I try to run the sp_send_dbmail I get the following error message:

Msg 14607, Level 16, State 1, Procedure sp_send_dbmail, Line 141
profile name is not valid

When I run the same command under a sysadmin account it runs with no problem. I am cutting and pasting the code. The code that I am sending is as follows:

EXEC msdb.dbo.sp_send_dbmail   
	@profile_name = 'Desktop',   
	@recipients = 'me@me.com',    
	@subject = 'Test',   
	@body  = 'Message',     @body_format = 'HTML';

Is there something that I am missing?

Any help would be greatly appreciated.

With Great Power Comes Great Responsibility!!!

Michael

 

[bikerboy718]

I actually figured this one out. I had 2 instances of management studio open and somehow not all of the settings took when I was executing the sp_send_dbmail under the non SysAdmin user between instances.

With Great Power Comes Great Responsibility!!!

Michael