Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
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: Wednesday, March 4, 2015 2:28 PM
Points: 478, Visits: 375
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, July 15, 2015 7:42 AM
Points: 2, Visits: 25
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