Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase «««123

SSAS CUBE PROCESSING ERROR Expand / Collapse
Author
Message
Posted Tuesday, November 19, 2013 8:55 AM
SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: Friday, October 9, 2015 3:12 PM
Points: 479, Visits: 379
Adding all rights is ok for my sandbox environment, but what is the best practice for assigning rights and permissions to SSAS in a production environment?

What are people doing out there that is considered the safe norm?

Thanks,

Andre Ranieri
Post #1515621
Posted Friday, February 20, 2015 3:00 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Wednesday, December 2, 2015 3:21 PM
Points: 2, Visits: 48
Changing the server role of the NT AUTHORITY\SYSTEM account to sysadmin cured the login error.

I now get an error 'A connection could not be made to thedata source with the DataSourceID of 'Adventure Works DW2012'.

Can anyone help with this ?
Post #1662034
« Prev Topic | Next Topic »

Add to briefcase «««123

Permissions Expand / Collapse