The Experience Analytics Database Manager provides a simple graphical interface through which you can install or update the SQL Server reporting database.
Through the interface, you can configure your database installation options, which can include completing the installation or generating the SQL scripts that can create the databases later.
Setup.exein the initial installation.
The Database Manager uses a statement ID-based method for managing updates and revisions to the Experience Analytics databases. The most recent statement that runs for each database is displayed in the General Info window.
When you install or upgrade Experience Analytics databases, the Database Manager must have permission to create databases and users on SQL Server and to grant permissions to the new users.
Microsoft™ IIS is sensitive to changes in directory
permissions. It is important that changes are made with care. If you have questions about
configuring the correct permissions for an Application Pool identity, visit