SSRS Report Builder gives “Failed to preview report.” – “Specified method is not supported.”

Posted on Wednesday 13 Oct 2010 | 2 Comments

This one had me stumped for a little while. It appears to be as a result of using a report that uses a Report Model that in turn is using a data source that uses the Native SQL Server driver which is presented just as “Microsoft SQL Server on the data source”:

This should be changed to OLE DB and an appropriate Provider= entry made:

This was with Report Builder 3.0 / SQL Server 2008 R2 but I would imagine it affects previous versions aswell.

This entry was posted in Uncategorized. Bookmark the permalink.

2 responses to “SSRS Report Builder gives “Failed to preview report.” – “Specified method is not supported.””

  1. Sindhu | Friday 24 Dec 2010 at 4:59 | Reply

    Hi,

    This did not help. I am still facing the same issue

  2. anit | Tuesday 4 Dec 2012 at 1:50 | Reply

    have you changed your domain password recently, if so the report manager does not know you did that and the data source is failing to connect. Go to report services configuration manager and change your password to the new one where necessary.

Leave a comment