Hosting Management Data Warehouse (MDW) reports on a reporting service

Management Data warehouse generates excellent report useful for a database professional with click of a mouse. However these reports can be accessed and navigated from SQL Server Management Studio only. Is not this a problem?

Well, I believe it is a shortcoming on MDW. Being able to host there reports on a SQL Server reporting instance automatically (like having real-time publishing capacity in-built) will actually complete this great feature.

However I found a series of great post from Microsoft PM Bill Ramos where he described how to host these reports in a reporting service portal in details. These steps can be referred at

These series of post will enable you to host all MDW reports on a SSRS portal which can be very helpful for complete automation of MDW reporting.