SQL Reports – Can’t access SQL Reports (Exception from HRESULT: 0x80070005 (E_ACCESSDENIED)


[UnauthorizedAccessException: Access is denied. (Exception from HRESULT:
 0x80070005 (E_ACCESSDENIED))]

 [FileLoadException: Could not load file or assembly
 'System.Web.RegularExpressions, Version=, Culture=neutral,
 PublicKeyToken°3f5f7f11d50a3a' or one of its dependencies. Access is
 System.Web.Configuration.RegexWorker..cctor() +0


Go to the Reporting Services Configuration Manager and … Read the rest

SQL Server Reporting Services (SSRS) – How to union or join tables from different databases on the same server

This example applies to SSRS 2008

SELECT a.datafield1 As Col1, a.datafield2 As Col2, b.datafield6 As Col3
LEFT OUTER JOIN databaseB.dbo.Table4 b on b.datafield6 = a.datafield1
FROM databaseA.dbo.Table5 a 


SELECT a.datafield7 As Col1, a.datafield8 As Col2, b.datafield12 As Col3
Read the rest