Select the software components to install on this server. For a single server installation, such as a demo server, just accept the selection of all 4 software components and the Sample database. Click Next to continue.
This dialog box only appears when you select the Web Service software component in step 3. Normally you do not need to change this entry. If the IIS Server on this machine has been reconfigured to use a different name for the default web site, enter the appropriate name here.
This dialog box only appears when you select the Web Service software component in step 3.
In the top section, enter the user id and password that the Admin Web Service will be configured to use for privileged access to SQL databases, and administrator access to SQL Server Analysis Services, which is the User ONE from Pre-requisiters NO.8.
In the lower section, enter the user id and password that the reporting Web Services will be configured to use for access to SQL databases, and NOT administrator access to SQL Server Analysis Services, which is the User TWO from Pre-requisiters NO.8.
(Note: If this User Id has administrator access to SQL Server Analysis Services there will be NO security in mobile and browser reporting and all users will be able to see all data.)
These dialog boxes only appear if you select the NT Service and Web Report Services software components in step 3. Username must be entered in the full format of domain\username..
First prompt is for the NT Service setup. (Here should be the User ONE.)
Enter the user id and password the CallistoService will be configured to use for access to SQL Server and SQL Server Analysis Services. After the installation is completed, these credentials can be changed by changing the Log On properties for the Service named “CallistoService”. Click OK to continue.
Second prompt is for the Web Report Services setup. (Here should be the User TWO.)
Enter the user id and password the CLRptService will be configured to use for access to SQL Server and SQL Server Analysis Services. After the installation is completed, these credential can be changed by changing the Log On properties for the Service named “CLRptService”.
(Note: This user id should not be configured as an Administrator in SQL Server Analysis Services, and it should not be a user id that is used in any Performance Management Security Roles! Otherwise, security will not work correctly in mobile and browser reporting and users will be able see data they should not have access to.) Click OK to continue.
If everything installs with no problems, this dialog box will not appear. If any errors occur during the install a warning dialog box similar to the following will appear. The messages will indicate if the error can be manually corrected after the install. To save a copy of the full install log, click the Yes button and a file will be created on your desktop. After that you will receive a dialog box where you can decide to complete the install or cancel the install. If you click OK to complete the install all of the files for the installation will be left in place. If you click Cancel all components will be uninstalled.
(Note: The Install_Sample_Application can be run at any time from the short cut link on the desktop. If you “Close” without actually installing the “Sample” app, you can install it later.)
After successful installation of the server, Deploy the Sample database to make it available for reporting:
To grant full write access to some users:
A common problem encountered on the first Deploy attempted on a new server is caused by an incomplete setup of SQL Server database security on a new installation of SQL Server and Analysis Services. By default, a new installation of Analysis Services is not granted access to SQL Server databases. For the UserID that Analysis Services is configured to run as, you must configure SQL Server Security to grant that user access to SQL Server databases.
To install in a multi server environment, you only need to run the install on the Web Server. The first UserID entered in Step 7 for the Web Server User Credentials must have system admin rights in SQL Server and Administrator rights in Analysis Services. Multi-Server Installation Details