Besides read-access on the data source(s), the following role memberships are required for any user deploying and executing timeXtender projects
- The user needs Administrator rights on Analysis Services.
- On the msdb database, membership of the db_ssisadmin role (db_dtsadmin on SQL Server 2005).
- On repository, staging and data warehouse databases, membership of the db_owner role.
Database connections are set up independently, which means that you can mix Windows and SQL authentication as it suits your setup.
This article applies to: timeXtender 4.5, tX2012, TX2014. Last updated: 2014-03-24.