question

SSRS-VS avatar image
0 Votes"
SSRS-VS asked SSRS-VS edited

Connect to SSRS server in remote from pc with different domains

Hello.
We are developing a report server 2019 in native. From a visual studio project, in a .cshtml view, we show the mobile reports embeded in the page.


When the user goes to that page, we connect in local (localhost) to the SSRS, and the explorer asks (credential prompt) for user data to connect (this user is defined in the SSRS portal web) wich uses the domain of the local pc.



But now we want to move the project to production (and change "localhost" for the server direction). The VS project to one server and the SSRS and DB to other.
When the user will use the web application and connect to the SSRS server, what will happen?
The user's pc will have x domain wich will not be the same as the server where the SSRS will be stored. We cannot register the user in the SSRS web portal since this will only accept users with same domain of the host.

For SSRS credentials and datasource connection, we have specified a sqluser in order to avoid the user to introduce any credentials.



But it didn't work. It ask for a user registered in the web portal.
So the questions are:

1) Can we avoid to ask the user to write the data registered in the web portal (avoid the prompt)? Keep in mind that the user has already had to enter their data to enter the visual studio website (and we do not want them to enter a second user to enter the SSRS server and display the reports).



2) And, I f we cannot avoid 1) How can a user from client pc with x domain connect to SSRS server with y domain? Can we fill the prompt with credentials from code?

sql-server-generalsql-server-reporting-services
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

OlafHelper-2800 avatar image
0 Votes"
OlafHelper-2800 answered

Hi, I asked this two days ago. And I'm seeing that you are answering questions more recent than mine.

"You" is the community here, with volunteers trying to answer questions. If this is somehow urgent, then contact the paid support.


SSRS support Windows authentication from the same domain where the SSRS server is running, cross-domain access is not directly supported.
You have to setup the domains a s trusted/forrest to my get it working, but that's nothing SSRS related, but Windows server.



5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

SSRS-VS avatar image
0 Votes"
SSRS-VS answered SSRS-VS edited

Thank you.
But if I have registered users with the windows domain where the SSRS server is hosted (eg: ServerDomain\User pass: abcd). And I connect from other client pc (regardless of his domain -ClientDomain) and I just write in the prompt the credentials saved in the server (User\abcd) here


That would work?

· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

What I mean is: will the server detect that my domain is different from the one I typed in the prompt? If the user registered is: ServerDomain\User And I type just User, the server will accept that or it will interpreted as ClientDomain\User?

0 Votes 0 ·