0

Let me explain my situation:

Server A: This is my SSRS (SQL Server Reporting Services) server, which hosts all users and source connections.

SQL Server B: This server is used for query connections created in the SSRS Server. Server B has two linked server connections with Impala: one for unmasked data and one for masked data, each using a different user account created on the Hadoop side. These masking implementations are managed in Apache Atlas/Ranger.

I want to configure SSRS on Server A such that user data determines which linked server connection (masked or unmasked) is used when running queries on Server B.

Could you provide any configuration guidance for this setup?

Improve this question
7
  • If you want masked data, why are you not using one server with Dynamic Data Masking? Then you could ensure that users who should be connecting to "Server B", instead don't have permission to UNMASK the data in Server A; then you don't even need a server B. This sounds like an XY Problem to me, Commented Jun 10, 2024 at 15:17
  • Also, how is [impala] related to the question? Commented Jun 10, 2024 at 15:19
  • This is kinda tricky, but perhaps if you have a view which does create View x AS select userid, * from maskedusers u cross join openquery(maskedserver, '...') oq union all select userid, * from unmaskedusers u cross join openquery(unmaskedserver, '...') oq and then select from the view based on userID Commented Jun 10, 2024 at 15:30
  • I have over 400 reports which Called through Hadoop, developed by different developers, all of which currently use a single linked server. Now, my situation has changed and I need to implement grouping on the SQL Server side. However, the reports always call the previous linked server instead of the new two linked servers (one for masked data and one for unmasked data). Commented Jun 10, 2024 at 15:36
  • Maybe this answer is what you're after? Dynamically set the data source for SSRS reports Commented Jun 11, 2024 at 10:47
Related questions
4
SSRS 2005 - Configuring User Authentication/Authorization
0
Azure MI SQL Agent cannot use Linked Server
0
IIS SQL Linked Server Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'
Load 5 more related questions Show fewer related questions

0

Reset to default

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.