Create the Enterprise Warehouse database

ADMINISTRATOR

The following procedure is for the enterprise administrator who creates and configures the Enterprise Warehouse database and the Enterprise BI website. (Site administrators configure each site.) 

1. Log into SQL Server Management Studio.
2. Right-click Databases, then select New Database to create an empty database.
   
   
   
   
3. Name the database Enterprise Warehouse Database (or something similar), then select OK.
4. Select File > Exit.
5. Select the Windows Start button, enter IIS, then select Open to start Internet Information Services (IIS) Manager.
6. On the right side of the window, select View Application Pools.
7. Select Add Application Pool to host the website, name it Enterprise Warehouse (or similar), then select OK.
   
   
   
   
8. Right-click the application pool in the list and select Advanced Settings.
9. Select Identity under Generate Process Model Event Log Entry, then select the Browse (...) button.
   
   
   
   
10. Select Custom Account, then select the Set button.
    
    
    
    
11. Enter the User Name and Password of the administrator domain account, confirm the password, then select OK until you return to the main IIS window.