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

Posted on Wednesday 13 Oct 2010 | 1 Comment

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.

Advertisement
This entry was posted in Uncategorized. Bookmark the permalink.

One Response 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

Leave a Reply

Fill in your details below or click an icon to log in:

Gravatar
WordPress.com Logo

You are commenting using your WordPress.com account. ( Log Out / Change )

Twitter picture

You are commenting using your Twitter account. ( Log Out / Change )

Facebook photo

You are commenting using your Facebook account. ( Log Out / Change )

Cancel

Connecting to %s