cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
dutchlimits Regular Visitor
Regular Visitor

Analysis services remotely or locally

Hi there

 

I got a report server with a local database and local analysis services which works fine. 

 

However, i'm trying to have a seperate report server and a seperate database server as a test enviroment, so two servers with this enviroment. I have installed analysis services and SQL server on the database server, the report server is running fine, however analysis services is not working when opening a directquery report.

 

Now here comes the question, since i've installed analysis on the remote server, is this even going to work, if so, what am i doing wrong? Or do i need to have analysis services installed locally on the report server.

 

Thanks! 

2 REPLIES 2
Super User
Super User

Re: Analysis services remotely or locally


Now here comes the question, since i've installed analysis on the remote server, is this even going to work, if so, what am i doing wrong? Or do i need to have analysis services installed locally on the report server.


This works fine, you just need to have Kerboros authentication configured in order to securely pass the user credentials between the report server and the remote servers.

 

see https://docs.microsoft.com/en-us/power-bi/report-server/configure-kerberos-powerbi-reports

 

You just want to be slow and methodical when setting this up. But once it's up and running it works fine. We currently have both our test and prod environments configured this way.

dutchlimits Regular Visitor
Regular Visitor

Re: Analysis services remotely or locally

Ah! i've not seen this page before. I'll try it out. Thanks for the link. 

Helpful resources

Announcements
Ask Amir Anything

Exclusive LIVE Community Event No. 2 – Ask Amir Anything

Next in our Triple A series: Ask Amir Netz questions about the latest updates, features and future.

Ask Amanda Anything Q&A

Ask Amanda Anything Q&A

Learn the answers to some of the questions asked during the Amanda Triple A event.

October 2019 Community Highlights

October 2019 Community Highlights

October was a busy month in the community. Read the recap article to learn about some of the events and content.

New Solution Badges

New Solution Badges

Two waves of brand new solution badges are coming! Read the article for more information on our new community badges.

Users Online
Currently online: 373 members 3,855 guests
Please welcome our newest community members: