In addition to Mark's handy SQL statement, you'll also probably want to report the actual owner of the database, which you can find with:

SELECT name, suser_sname(owner_sid) FROM sys.databases;

Phil, thank you very much for the response. I went ahead and incorporated the rsreportserver.config correction, and your note about the keys in my original post.

But, for ApplicationPoolConfigured_RM and...

Well, I couldn't leave the problem alone, and eventually found a solution. This fix involves manual registry changes and manually modifying .config files, so beware, AND I've only given...

Though getting email alerts from the trace log errors in general would be nice, I'll settle for this to get started on monitoring subscriptions.

In SQL Server 2000 SP3 and later, no CONNECT to the database needed to be explicitly made...or was there some other mechanism at work that I didn't know about that...

Good to know. Thanks for your help.

Thanks for the quick response. Do you have any additional thoughts when I mention the following (particularly #1 below)?

3) I probably wasn't very clear in the last paragraph...

bitbucket (9/23/2008)

---

I would like to thank all who have commented. I have learned a little more to apply to any additional QOD that I may submit. Please note...

Thanks for the query. Part of the issue is that the SQL Agent user I use is a sysadmin, and so I don't/haven't defined it as a database principal...

This sounds more like a SQL Server 2000 dilemma to me. When failed login auditing is turned on in SQL Server 2000, sadly no State information is returned to...

Despite my testing, I could not get a private profile to work for the SQL Agent user, especially with the other security we have setup for that user. The...

I'm not a huge fan of the BOL article referenced, http://msdn2.microsoft.com/en-us/library/ms178134.aspx. I answered the question as the author of the question intended, so I'm a bit biased,...

I had a similar situation where we wanted to take a large mdf and split it into multiple files. Because this database is from a vendor that has an...

Disclosure:  I answered 'No'

I read the question very literally to mean that you cannot directly access a mirrored database for reporting.  Instead, you must combine 2 solutions, database mirroring with...

From BOL 2005:

"Although understanding how snapshots work is not essential to using them, it can be helpful. Database snapshots operate at the data-page level. Before a page of the source...