We went to Office 365 months ago, and it worked fine then. The only thing that's different now is having migrated to SQL 2012.

I believe the answer to your question is yes. We have Office...

As far as I can determine, the profile has been set correctly....

Thank you, that was very useful. I've run the SELECT statement that you gave me in msdb and here's the results:

The mail could not be sent to the recipients because...

John Jakob (10/14/2013)

---

Like the other poster said, what happens when you try sending a test email?

If you try something like this:

EXEC msdb.dbo.sp_send_dbmail

@profile_name = 'DBMailPublicProfile', ...

Thanks!

Thank you, this does help, but I wonder about setting up an on-premise SMTP server? We didn't have to do that before, when we had...

Thank you!

We have now migrated to SQL Server 2012, with SSRS 2012. Does SSRS 2012 allow for multiple sorts, or do you still suggest that we use a report parameter?

Just an addendum, the more I think about this, the less I think that I actually had a disk for service pack 1 for SQL Server 2008 R2. I believe...

Thank you, Koen and Grant.

Thank you, Gail, for your answer. Now I'm trying to work out the correct syntax. It looks as though I should use the GRANT statement. I've created a custom role...

Hi Gail,

I'm confused, I'm sorry. I thought that the MSDN article that Bhuvnesh pointed to said that you could...

OK, Bhuvnesh and Gail, I've created a new role, but adding db_datareader and db_datawriter has me stumped. I've tried doing it through the SSMS GUI, but it won't let me,...

Very interesting article, Andy!