Granting SSRS Access to Cube

• ps_vbdev

  SSCarpal Tunnel

  Points: 4060

  More actions

  November 24, 2016 at 3:42 am

  #147822

  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