unable to process dimension

• MGLTD

  Old Hand

  Points: 300

  More actions

  January 13, 2016 at 1:07 am

  #306916

  I am having problem processing a dimension, I tested the connection to the database succesfully, the connection is using Native OLE DB\SQLNCLI11.1

  but when I try to process a dimension I have the error

  Errors in the high-level relational engine. A connection could not be made to the data source with the DataSourceID of ....(it is in a sql server 2008r2)

  I have used all the impersonation options available and it has not been successfull, I have checked if i have read permission to the database which I have, please what else can I check. Thanks

  I am an administrator on the analysis services as well, I have also restarted the ssas

• MGLTD

  Old Hand

  Points: 300

  More actions

  January 13, 2016 at 2:20 am

  #1851496

  I used ole db provider for sql server and it is ok now