Quick hints that may point you in the right direction when troubleshooting a specific problem.


SSRS is not generating or displaying reports

  • Check the disk space on the SSRS server.

SSRS Reports Error: The OLE DB provider "SQLNCLI" for linked server "NAME" reported a change in schema version between compile time ("173310525053760") and run time ("173314820023864") for table "tablename"

  • Actually an error from SQL Server. Try running the SQL View directly from SQL Server to update the schema version.  Immy case, I had a number of chained views. Executing the SQL View at the 'root of the chain' fixed this.
  • Alternatively, try removing and recreating the Linked Server with the same name.