Forum Discussion
DirectQuery from Report Server to remote MSSQL-Server isn't working
Hello Community, i am trying to configure a working DirectQuery from my Report Server to an MSSQL-Server which is not running ob the same server. But i can't figure out how to configure the authenti...
Developer Edition?
Are you sure you have enable network protocols for SQL and SSAS?
https://docs.microsoft.com/en-us/sql/relational-databases/lesson-2-connecting-from-another-computer?view=sql-server-ver16#protocols
Hello sheigor,
thank you for your reply.
When i enter administrator-credentials in the datasource configuration of the report i get the data. But this is in my opinion only an workaround. I'm looking for an solution to get it running without giving extra credentials to my users.The problem is the forwarding of the login credentials from the report server to the database, so i can configure the userrights for my tables and views.
kind regards
Sal_