4.3 Account Requirements

This section describes the account requirements for installing Data Warehouse, Reporting Center, and for the SQL Server services that support Analysis Center.

4.3.1 Data Warehouse Installation

To install Data Warehouse, you must have administrative access to the computer on which you are installing the components. You can use either a domain or local administrator account.

During installation, you are prompted to use either Windows or SQL Authentication to connect to the SQL Server. If you use Windows Authentication, the account with which you are running the installation must belong to the System Administrators group for the SQL Server. If you use SQL Authentication, you must specify a SQL Server account that belongs to the System Administrators group for the SQL Server.

Ensure that the SQL Server account that you use to login must comply with the following:

  • The user name must not contain spaces, single quotes, or double quotes.

  • The password must not contain spaces or ampersand. However, it can contain single quotes or double quotes.

You can install the multidimensional database on a local or remote computer.

4.3.2 Reporting Center Installation 

The following table lists the accounts you need to create or identify before installing Reporting Center.

Account

Description

Requirement

Console Account

Account that connects to the Web Service to display and use the Reporting Console.

  • Ability to log into the Web Service.

Database Installer Account

Account you log in with to run the setup program that creates the Configuration Database.

  • System Administrator privileges on the SQL server where you install the Configuration Database.

  • Local administrative permissions on the computer where you run the setup program.

Web Service Installer Account

Account you log in with to run the setup program that creates the Web Service and also configures the Web Service account in the Configuration Database.

  • System Administrator privileges on the SQL server where you install the Web Service.

  • Local administrative permissions on the computer where you run the setup program.

Web Service User Account

Account that the Web Service uses to retrieve data from the reporting database.

None. If the account does not exist, the setup program creates it and assigns the following roles:

  • dbcreator and bulkadmin on the SQL server.

  • db_owner on the Configuration Database.

4.3.3 SQL Server Services

This section describes the permissions required for the various SQL Server service login accounts in varied distribution scenarios. Each example assumes one instance of SQL Server or Analysis Services on a computer.

If you distribute components across different instances of SQL Server on the same computer, the same requirements for permissions apply server to server. For example, from the Data Mart SQL Server to the Data Warehouse SQL Server.

Non-Distributed Scenario

This scenario considers the following:

  • Source database and Analysis Center databases (SQL Server and Analysis Server) all on one computer

  • Source database on one computer and all Analysis Center databases (SQL Server and Analysis Server) on another computer

Authentication Mode

Required permissions

Windows Only Authentication

SQL Server

  • Member of System Administrators server role for the SQL Server.

  • (Conditional) db_datareader database role for the source database: This is applicable only if source database is on one computer and all Analysis Center databases on another computer.

SQL Server Agent

  • Member of System Administrators server role for the SQL Server.

  • (Conditional) db_datareader database role for the source database: This is applicable only if source database is on one computer and all Analysis Center databases on another computer.

SQL Server Analysis Services

  • Member of System Administrators server role for the SQL Server.

NOTE:All services must use the same domain account.

SQL Server and Windows Authentication

SQL Server can run as Local System.

SQL Server Agent and SQL Server Analysis Services must have the same permissions specified above for Windows Only Authentication mode.

Distributed Scenario

This scenario considers the following:

  • Source database on first computer, Data Mart on second computer, Data Warehouse on third computer

  • Source database and each Analysis Center database on a separate Computer

Data Mart computer (SQL Server):

Authentication Mode

Required Permissions

Windows Only Authentication

SQL Server

No special requirements.

SQL Server Agent

  • Member of System Administrators server role for the Data Mart SQL Server.

  • Member of System Administrators server role for the Data Warehouse SQL Server.

  • db_datareader database role for the source database.

SQL Server and Windows Authentication

SQL Server can run as Local System.

SQL Server Agent must have the same permissions specified above for Windows Only Authentication mode.

Data Warehouse computer (SQL Server and Analysis Server) or Data Warehouse relational database computer (SQL Server):

Authentication Mode

Required Permissions

Windows Only Authentication

SQL Server

  • Member of System Administrators server role for the Data Warehouse SQL Server.

  • (Conditional) Member of System Administrators server role for the Data Mart SQL Server. This is applicable only if the source database and each of the Analysis Center database are on a separate computer.

  • db_datareader database role for the source database

SQL Server Agent

  • Member of System Administrators server role for the Data Warehouse SQL Server.

  • Member of System Administrators server role for the Data Mart SQL Server.

  • db_datareader database role for the source database.

(Conditional) SQL Server Analysis Services

This is applicable only if source database is on first computer, Data Mart on second computer, and Data Warehouse on third computer.

  • Member of System Administrators server role for the Data Warehouse SQL Server.

NOTE:All services must use the same domain account.

SQL Server and Windows Authentication

SQL Server and SQL Server Agent must have the same permissions specified above for Windows Only Authentication mode.

SQL Server can run as Local System.

(Conditional) SQL Server Analysis Services must use Windows authentication and have permissions specified above for Windows Only Authentication mode. This is applicable only if source database is on first computer, Data Mart on second computer, and Data Warehouse on third computer.

(Conditional) Data Warehouse multidimensional database computer (Analysis Server). This is applicable only if the source database and each of the Analysis Center database are on a separate computer

Authentication Mode

Required Permissions

Windows Only Authentication

SQL Server Analysis Services

  • Member of System Administrators server role for the Data Warehouse SQL Server.

  • Member of System Administrators server role for the Data Mart SQL Server.

SQL Server and Windows Authentication

SQL Server Analysis Services must have the permissions specified above for Windows Only Authentication mode.

4.3.4 Connection to Data Mart Database

During the creation of a Data Source, you are asked to specify whether the Data Warehouse SQL Server Agent connects to the Data Mart database using Windows or SQL Server authentication. If you use SQL Server authentication, the login name you specify must be a System Administrator for the Data Mart SQL Server.