how to connect two tables of two different Database

Question

hi, assume that we have 2 database:- DB1 and DB2 in Db1 there are few tables and also in DB2 there are few tables in Db1 there is one table named tbl101 and in DB2 there is one table named tbl303 now i want to connect this two tables: tbl101 and tbl303 how that can be achieved? what is the code?

Answer 1

I found the Solution:

Finf the Report web config in the below path :

C:\Program Files\Microsoft SQL Server\MSRS12.MSSQLSERVER\Reporting Services\ReportManager\web .config

Replace or add below line: to set admin credential for all users to access the report.

<authentication mode="Windows" /> // Authentication mode to be set to windows

<identity impersonate="true " userName="UserName" password="Password"/> // identity impersonate to be set to true and User name & Password of the SQL Server administrator should be added.