This section describes the account requirements for installing Data Warehouse, Reporting Center, and for the SQL Server services that support Analysis Center.
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.
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. |
|
Database Installer Account |
Account you log in with to run the setup program that creates the Configuration Database. |
|
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. |
|
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:
|
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.
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
SQL Server Agent
SQL Server Analysis Services
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. |
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
|
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
SQL Server Agent
(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.
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
|
SQL Server and Windows Authentication |
SQL Server Analysis Services must have the permissions specified above for Windows Only Authentication mode. |
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.