Brian you should contact http://www.devproconnections.com/ and have this article printed. What a great piece of writting.

I ran your T-SQL on a SharePoint Content DB ---- WSS_Content DB and I was suprised to see auth_scheme is KERBEROS which is great news.

However, my question is I did not configure that, so I am assuming this is something SharePoint 2010 does. Thank you so much for the article.

I will keep this in my Favorites for SQL Server when configuring SSRS. You made the start of my day nice with my cup of coffee.