Granting SSRS Access to Cube

Question

Granting SSRS Access to Cube

ps_vbdev

SSCarpal Tunnel

Points: 4060
More actions
November 24, 2016 at 3:43 am

#332331

Im having issues when i deploy my ssrs report to the report server that queries my cube. It runs fine in visual studio but i am in the AD group that has permissions in a cube role. When i try to run the report once its deployed i get
An error has occurred during report processing. (rsProcessingAborted)
Cannot create a connection to data source 'TESTSERVER'. (rsErrorOpeningConnection)
If i test the the Datasource on the report server i get
Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'.
so the ssrs server can't access the cube. I tried adding the network account that the SSRS service runs under to the CUBE AD group but no joy. Normally i would create a sql server users on the database with the appropriate permissions and then use him in the datasource on the report server but with cubes you can only seem assign domain users to roles.
ani ideas?
thanks

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply

Thom A SSC Guru Points: 99130 More actions · Answer 1

I sounds like you've configured your datasource incorrectly. Are you using a shared datasource or a datasource saved within the report?

If shgared, have you deployed the datasource? Either way you'll then need to configure the credentials on SSRS Report Server for the new Datasource (either on the report or shared). You're error is saying that it is using anonymous authentication, which means it hasn't been configured.

Thom~

Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk

ps_vbdev SSCarpal Tunnel Points: 4060 More actions · Answer 2

Thanks

Im using an embeded datasource. You are right the credentials haven't been configured, because its SSAS i don't know what to configure them as. When im configuring a SSRS datasource to connect to database I create a user on the database, give him appropriate permissions and then use this user in the datasource for the report but in SASS you cant do that you can only add domain users to roles as far as i can see. so how do you get SSRS to connect to SSAS as a domain user? do i have to change the web service or something?

confused:w00t:

Thom A SSC Guru Points: 99130 More actions · Answer 3

You can still configure datasources to use Windows Authentication (it's one of the options in the Web portal, just make sure you tick "Use Windows Credrentials when connected to the data source"), you'll just need to create a service account that can connect and read the cube, but not update it, in Analysis Services. Then use those credentials in your datasource on the Report Server.

Thom~

Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk