Data source permission error when processing cube

Question

Hi All,
When i tried to deploy a new dimension i am getting the following error
"Error 208 Errors in the metadata manager. The data source permission with the ID of 'DataSourcePermission 1', Name of 'DataSourcePermission 1' was invalidated by operations in the transaction. 0 0 "
Please see the screen shots. I opened the .ds and checked my connection to the source database and it is successful, also please see the snap shot attached regarding impersonation info. I am using domain\username to connect to the source database . Our DBA created a new role on the SSAS Database as "cubeadmin" and added my domain\username to the role which has access to deploy, process and full administration. In spite of this I am not able to deploy or process my dimension. Please advice.

Thanks

Answer 1

As noted in the documentation here https://learn.microsoft.com/en-us/analysis-services/tabular-models/impersonation-ssas-tabular?view=asallproducts-allversions#tabular-1400-and-higher-models the current user option is only supported when using Direct Query mode and if you are trying to process the model I'm assuming that it is probably in import mode.

So you will either need to do one of the following:

• get your DBA to give access to the service account.
• or setup a separate account to use for this data source (which is the most secure option)
• or you could enter your username/password into the windows account (but I would only do this temporarily for testing)

Answer 2

Thanks All finally was able to resolve the issue. The issue was i was getting the version from subversion , which has the .ds as fully qualified name (SQLSERVER.ABC.COM\SQLSERVER) where as the PROD database has .ds as (SQLSERVER\SQLSERVER) and hence this issue. I made them both as fully qualified name and issue is resolved. Thanks all for your valuable time

Answer 3

Thanks @Darren Gosbell I am using a Multi Dimensional model and not tabular. I am not sure if I understood the IMPORT mode, here is what I am doing.

1. Opened BIDS
2. Opened project from SUBVERSION
3. Added a new dimension
4. Tried to process it

I have also tried like below

1. Opened BIDS
2. File open SSAS Database, connected to the PROD SSAS Server and opened the database.
3. Added the new dimension and tried to process.

One more question is does the Service account for SSAS should have access to both databases (Source database (.ds) and SSAS Prod database), also should the service account be granted access at the SSAS Server level?
Thanks

Answer 4

Thanks @Darren Gosbell I am using a Multi Dimensional model and not tabular. I am not sure if I understood the IMPORT mode, here is what I am doing.

so the same limitation applies to Multi Dimensional models, it's just that the terminology is different so IMPORT is roughly similar to MOLAP partitions (which is the default storage mode) and the "Current User" credentials would only be used with ROLAP partitions

One more question is does the Service account for SSAS should have access to both databases (Source database (.ds) and SSAS Prod database), also should the service account be granted access at the SSAS Server level?

No the service account does not need access to both databases, it would only need access to the source database. You don't need to add any permissions to the service account at the SSAS Server level

Answer 5

@Darren Gosbell Thanks,
Here is what is happening. I can open (.ds) click on edit and using windows authentication can test the connection successfully. Then I created a new dimension (NOTE: The Authentication is set to use the service account). Then tried to process the dimension and i get a window to deploy to the server first
clicked yes
Another message> will over write the existing database and clicked yes

I get this error message
The ImpersonationInfo for datasource 'Avi Data Warehouse' contains an ImpersonationMode that can only be used by a server administrator.
My DBA added my windows account to the SSAS Server Instance as Admin and now i get bunch of error messages
Error 208 Errors in the metadata manager. The datasource permission with the ID of 'DataSourcePermission 1', Name of 'DataSourcePermission 1' was invalidated by operations in the transaction. 0 0
Error 209 Errors in the metadata manager. The cube permission with the ID of 'CubePermission 5', Name of 'CubePermission 5' was invalidated by operations in the transaction. 0 0
Error 210 Errors in the metadata manager. The cube permission with the ID of 'CubePermission 5', Name of 'CubePermission 5' was invalidated by operations in the transaction. 0 0
Error 211 Errors in the metadata manager. The cube permission with the ID of 'CubePermission 5', Name of 'CubePermission 5' was invalidated by operations in the transaction. 0 0
Error 212 Errors in the metadata manager. The cube permission with the ID of 'CubePermission 5', Name of 'CubePermission 5' was invalidated by operations in the transaction. 0 0
Error 213 Errors in the metadata manager. The cube permission with the ID of 'CubePermission 3', Name of 'CubePermission 3' was invalidated by operations in the transaction. 0 0

Please advice.
Thanks