Forum Discussion

Anonymous

Not applicable

6 years ago

SSAS DNS name not working from Report Server:

Hi, I am able to connect to my SSAS Instance with DNS/Alias name from SSMS and Power BI desktop. But once report is published to report server, it fails to render data. And when i modify the con...

Anonymous

Not applicable

6 years ago

Thanks for your response.

SSAS instance and PBIRS are on same server box.

I will check if Keberos delegation is setup for this use case. If now will follow documentation and set it up.

Thanks

Manoj

Icon for Super User rank

Super User

6 years ago

No, if the two services are running on the one server Kerberos is not your issue.

What error do you get when using the DNS name?

If you log on to the server can you ping the DNS name and does it resolve correctly?

Anonymous
Not applicable
6 years ago
Hi d_gosbell

Once connection string is modified to have DNS name and click on test connection, i get below error message:
The report server couldn't connect to the data source using the information you entered. Make sure you've entered the connection string and any credentials correctly.
Hide error details
The connection either timed out or was lost.

If i just save the connection string with out testing the connection. I get below message while report is rendering/loading the data
We couldn't connect to the Analysis Services server. Make sure you've entered the connection string correctly.

Thanks
Manoj
- d_gosbell
  Super User
  6 years ago
  So you or an admin needs to remote desktop onto the server and see if you can ping the DNS name. If this fails (which I'm thinking it might) then you'll need to work with your IT people to figure out why.
  - Anonymous
    Not applicable
    6 years ago
    Hi d_gosbell
    
    I did ping the DNS name from server (by connection from remote desktop). And DNS name is being pinged with out issue.
    Kerberos delegation setup is needed when i have SSAS Instance and PBIRS on same server box?
    
    Thanks
    Manoj

Related content