Tip: How to Quickly Test the SSRS Data Source Connection
By Garth Jones
In this video I will show you a quick way to ensure that your SSRS server is connected to the Configuration Manager 2012 database. I always use this method and by following the steps in this video you will be able to validate that there are no issues with your connection account.
Note: this will ONLY work if you are using SQL 2008 or later versions. It will NOT work with SQL 2005.