IIS Installer

  1. Automated Server Setup

    Download the installer for Windows by clicking here.

Follow the instructions on the Windows installer and you'll be able to get everything set up! If you have an offline installation, please see step #2.

  1. Offline Install (optional)

    We realize not all servers have outside network access. After you have run the standard installer in step #1 above, then simply place the offline installation package in your wwwroot folder. Update config/database.php, then run artisan october:up to finalize the setup.

IIS Manual Install Guide

  1. Server Setup

    If the server is not already setup for web traffic, install Httpd, MariaDB/MySQL, PHP, and dependancies. The easiest way to do this is to upgrade to the latest IIS package and use the Web Platform Installer: https://www.microsoft.com/web/downloads/platform.aspx

With Web PI, you can navigate to the "Web Platform" tab and select "PHP" under "Framework and Runtimes" customize link.

After you have installed PHP, download and install MariaDB (or MySQL): https://downloads.mariadb.org/

You can test your setup with a PHP file containing

<?php phpinfo(); ?>

Note: Make sure you have at least PHP 7. (Search for PHP 7 on Web Platform Installer and grab the latest version of that)

  1. MariaDB/MySQL Setup

    For MariaDB you can use mysql_install_db.exe to create a database instance (cf. https://mariadb.com/kb/en/mariadb/mysql_install_dbexe/). Log into MySQL with your root user. (Password blank by default - but you should configure something else!) To do this, you can use the "mysql.exe" command in "bin" folder of the MySQL install.

cd C:/PathToMySQLInstall
./mysql.exe -u root -p

or for MariaDB

cd C:/PathToMySQLInstall/bin
mysql --user=root --password=

Then, run the following commands to create a database and user:

CREATE DATABASE tableau_portal;
CREATE USER 'newuser'@'localhost' IDENTIFIED BY 'password';
GRANT ALL PRIVILEGES ON tableau_portal.* TO 'newuser'@'localhost';
FLUSH PRIVILEGES;
  1. IIS Setup

    Either use the Default Web Site in IIS, or create a new site. In the PHP Manager, make sure the "fileinfo" extension is enabled (It isn't enabled by default.)

  2. Code Installation

    Now that we have installed the server, unzip the latest Integration System install code to your root web directory.

Make sure the directory is open for writing. To do this, you will need to right click on the root web folder and go to "Properties -> Permissions". Grant the Internet Guest User full access. If you don't find the Internet Guest Account click Add/Advanced/Find Now/ and find in the list the name starting with IUSR_ . Then press Ok.

Copy web.config from docs/iis/web.config to the root folder in your installation. This tells IIS how to route correctly.

Run http://[your-server-here]/install.php in a web browser.

  1. LDAP Passthrough

Using IIS, you can use the user's AD credentials automatically.

Enable Windows Authentication in "Add/Remove Windows Features". (Sometimes this is known as Add Roles and Features) Server Roles -> Web Server (IIS) -> Web Server -> Security -> Window Authentication

Once this is added, go to your site in IIS, click "Authentication". Change "Windows Authentication" to "Enabled" and "Anonymous Authentication" to "Disabled".

In the portal's Tableau Server Settings, select "Active Directory" as the Authentication Type.

If you have issues, make sure to disable UAC, to allow access to the filesystem. (Control Panel -> System and Security -> User Account Control Settings)

  1. Set up Cron

    Add a Windows Scheduler task to execute every minute with the following details. Modify the path to artisan as needed.

php C:\inetpub\wwwroot\artisan schedule:run

Note: Make sure the user executing the task has appropriate permissions

  1. Final Steps

    After installation, remove install.php and the install_files folder. Manage the portal through /backend as needed.

  2. Troubleshooting

    HTTP Error 500.19 If you see a HTTP error after installation with the message "The request page cannot be accessed because the related configuration data for the page is invalid" chances are you need to install a URL Rewrite Module. This can be downloaded from here: http://www.iis.net/downloads/microsoft/url-rewrite Restart your website after installation

'Your current security settings do not allow this file to be downloaded' in Internet Explorer If you see the error above when trying to download files in Internet Explorer, go to Internet Options -> Security Settings and select "Custom Level" on Internet. Look for "Downloads" and enable it.