¶ 1. Overview
This guide provides detailed instructions for System Administrators, Technical Consultants, employees, and clients on how to download, install, and configure T6 Enterprise, the platform for Tech6 products: T6 Planning, T6 Consolidation, T6 Performance, T6 IFRS, T6 TryAuth, T6 HR, and T6 Capex. It covers everything from environment preparation to installation completion.
¶ 2. Installation Prerequisites
The installation of T6 Enterprise requires the installation and configuration of some additional software, as listed below:
¶ 2.1. Software
Microsoft Windows Server, one of the options below:
- Microsoft Windows Server 2012 R2 (Standard or higher).
- Microsoft Windows Server 2016 (Standard or higher).
- Microsoft Windows Server 2019 (Standard or higher).
Microsoft SQL Server, one of the options below:
-
Microsoft SQL Server 2012 SP4 (Standard or Enterprise with Service Pack 4 or higher).
-
Microsoft SQL Server 2014 (Standard or higher).
-
Microsoft SQL Server 2016 (Standard or higher).
-
Microsoft SQL Server 2017 (Standard or higher).
-
Microsoft SQL Server 2019 (Standard or higher).
-
Microsoft SQL Server 2022 (Standard or higher).
-
Internet Information Services (IIS) version 8 or higher.
It is required that "IIS 6 Management Compatibility" be installed. For more details and tips
about IIS, refer to the manual: IIS Setup Tips. -
.NET Core 8.0 Runtime & Hosting Bundle for Windows (v8.0.0): Download .Net Core 8.0
-
Microsoft .Net Framework 4.8 or higher: Download .NET Framework 4.8
-
Report Viewer 2012: Download Report Viewer 2012
Before starting the installation, it is important to ensure that the environment is properly configured and all required software is installed.
¶ 2.2. Configurations
The installation of T6 Enterprise also depends on the prior configuration of some services and components.
¶ 2.2.1. Windows Server
-
Windows User Account: You can run T6 Enterprise using a new Windows user account. You must create and configure this account, ensuring that the new user is a member of the following groups:
AdministratorsandIIS_WPG. -
Server Name: During the installation of T6 Enterprise, use the server name instead of
localhost. -
WebSocket Protocol: It is necessary to install the WebSocket feature on the Windows server that will
host the T6 Enterprise application.- To perform the installation, first open the Control Panel. Then click on Turn Windows
features on or off.
- To perform the installation, first open the Control Panel. Then click on Turn Windows
The next screen will display the initial step of the Add Roles and Features Wizard. Click Next to proceed.
On the next screen, you must select role-based or feature-based installation. Click Next to proceed.
On the next screen, you will select the destination server. Click Next to proceed.
On this screen, you must verify whether the WebSocket Protocol option is or is not installed.
If it is already installed, you can cancel this wizard. Otherwise, click Next to proceed and follow the Windows instructions to complete the installation.
¶ 2.2.2. Windows Configuration (Collaborators)
This step is only required for collaborators who will use T6 Enterprise on their local machines, meaning it will not be necessary to perform these configurations on servers that will host T6 Enterprise for network access.
Windows Settings:
- The first step to perform on the machine is to change the operating system locale to English (United States). This is necessary to avoid issues with date and number formatting during installation and use of the system.
- Click the Windows Start menu and select Settings (gear icon);
- Access the Time & language category;
- Click Language & region in the right-hand options;
- Under Windows display language, select English (United States) from the dropdown. If the language is not listed, click Add a language and search for English (United States) to install it;
- Under Region, select United States from the dropdown;
A computer restart may be required for the changes to take effect.
- After changing the system locale, the next step is to rename the computer to a standard name that makes it easier to identify on the network.
- Click the Windows Start menu and select Settings (gear icon);
- Access the System category;
- Click Rename, displayed below the current computer name;
- Type the new computer name in the provided field. Use uppercase letters, with no spaces, quotes, or special characters.
- The next step is to Enable the required Windows features.
- Click the Windows Start menu and search for Turn Windows features on or off;
- In the window that opens, enable the options below:
Windows features to be enabled:
- .NET Framework 3.5 (includes .NET 2.0 and 3.0)
- Windows Communication Foundation HTTP Activation
- Windows Communication Foundation Non-HTTP Activation
- .NET Framework 4.8 Advanced Services
- ASP .NET 4.8
- WCF Services
- HTTP Activation
- TCP Port Sharing
- Internet Information Services
- FTP Server
- FTP Extensibility
- FTP Service
- Web Management Tools
- IIS 6 Management Compatibility
- IIS 6 management Console
- IIS 6 Scripting Tools
- IIS 6 WMI Compatibility
- IIS Metabase and IIS 6 Configuration Compatibility
- IIS Management Console
- IIS Management Scripts and Tools
- IIS Management Service
- IIS 6 Management Compatibility
- World Wide Web Services
- Application Development Features
- .NET Extensibility 3.5
- .NET Extensibility 4.8
- Application Initialization
- ASP .NET 3.5
- ASP .NET 4.8
- ISAPI Extensions
- ISAPI Filters
- Server-Side Includes
- WebSocket Protocol
- Common HTTP Features
- Default Document
- HTTP Errors
- HTTP Redirection
- Performance Features
- Dynamic Content Compression
- Static Content Compression
- Security
- Basic Authentication
- Request Filtering
- Windows Authentication
- Application Development Features
- FTP Server
→
¶ 2.2.3. SQL Server
It will be necessary to download and install SQL Server, as well as SSMS (SQL Server Management Studio) for database management.
We recommend using SQL Server 2019 or higher.
-
Access the official Microsoft website to download SQL Server: Download SQL Server. - Choose the Developer edition and follow the installation instructions provided on the website.
-
After installing SQL Server, install SSMS from the official Microsoft website: Download SSMS.
-
SQL Server Installation: The correct functioning of T6 Enterprise depends on some SQL Server options, listed below.
- Database Services;
- Integration Services (only if used for ETL);
- Workstation Components and Development Tools.
-
Required Configurations: The services listed above must be run from the Local System or Network Service.
- The SQL service must be started.
- The TCP/IP protocol must be enabled in SQL Server Network Configuration and SQL Native Client Configuration.
-
New Database: A new database must be created and configured before starting the T6 Enterprise installation. During the installation process, the necessary tables and data will be created automatically by the installer. To create a new Database, follow the steps below.
- Open SQL Server Management Studio.
- Connect to the Database Engine where you want to create the database for T6 Enterprise.
- Once connected, right-click on the Database folder in the Object Explorer and select the New Database option.
The database COLLATION must be set to Latin1_General_CI_AI.
-
T6 Enterprise User Creation: Ensure that this new T6 user has the attributes described below and that the default language is set to English.
- Authentication type of SQL Server Authentication or Windows Authentication, depending on how you wish to connect.
- If you use the SQL Server Authentication option, configure and confirm a password. Passwords must be configured to meet security policies, i.e., complex passwords.
- On the General tab, in the Default Database option, select the new T6 Enterprise database created for this purpose.
T6 Enterprise User Configuration - General Tab. - On the User Mapping tab, in the Users Mapped to This Login option, check the Map checkbox for the new T6 Enterprise database created in the previous item.
- In the Database Role Membership option, select the
db_owneroption. Thepublicoption should already be checked by default; if it is not, check it.
T6 Enterprise User Configuration - User Mapping Tab. - On the Status tab, under Settings, ensure that the Permission to Connect to Database Engine option is set to Grant, and that the Login option is set to Enabled.
T6 Enterprise User Configuration - Status Tab. - If you choose to run SQL Server Jobs through T6 Enterprise Workflow tasks, it will be necessary to define some specific roles for the T6 Enterprise user in SQL Server, as described below.
- On the User Mapping tab, in the Users Mapped to This Login option, check the Map checkbox for the msdb database.
- In the Database Role Membership option, select Public, SQLAgentUserRole, and SQLAgentOperatorRole.
- In the msdb.dbo.sysjobs table, SELECT access must be granted using the command
USE msdb GRANT SELECT ON msdb.dbo.sysjobs TO your_user_name.
- In the msdb.dbo.sysjobs table, SELECT access must be granted using the command
-
If it is necessary to filter these Jobs, T6 Enterprise provides a parameter that indicates a Database View responsible for filtering specific Jobs. To configure the View, follow the instructions below.
- Access the T6 Enterprise menu → Modeling → Others → Parameters. Fill in the value of the databasejobsview parameter with the name of the View to be used. This View must mandatorily contain the fields jobid, jobname, and jobdescription.
- In the Object Explorer, right-click on the server name and select the Properties option;
- In the window that opens, access the Security tab and verify whether the SQL Server and Windows Authentication mode option is selected. If it is not, select it and click OK;
If you select the Windows Authentication option, the credentials used will be the same credentials used to log in to Windows; however, we will need to enable the
Windows Authenticationcomponent in IIS;
To enable the component, press the Windows key and search for "Turn Windows features on or off".
After accessing it, locate Internet Information Services and enable the Windows Authentication component;
If you cannot log in, access the SQL Server Configuration Manager, enable the TCP/IP protocol, and restart the service.
-
Click the Windows Start menu and search for SQL Server Configuration Manager;
-
In the left panel, expand the SQL Server Network Configuration option and select Protocols for MSSQLSERVER;
- In the right panel, right-click on TCP/IP and select the Enable option;
-
In the left panel, select the SQL Server Services option;
- Right-click on SQL Server (MSSQLSERVER) and select the Restart option;
-
After restarting the service, open SSMS again and try to log in with your user.
If SQL Server Configuration Manager does not appear in the Start menu, it is still on your system — what happens is that in more recent versions of SQL Server, it no longer creates a visible shortcut.
If this happens, you can open SQL Server Configuration Manager directly in Windows:
- Press Win + R to open the Run window;
- Check the installed SQL Server version and type the corresponding command in the Run window:
| SQL Server Version | Command to open |
|---|---|
| SQL Server 2022 | SQLServerManager16.msc |
| SQL Server 2019 | SQLServerManager15.msc |
| SQL Server 2017 | SQLServerManager14.msc |
| SQL Server 2016 | SQLServerManager13.msc |
| SQL Server 2014 | SQLServerManager12.msc |
| SQL Server 2012 | SQLServerManager11.msc |
¶ 2.2.4. Web Server (IIS)
- Required Role Services: Some roles are required for the use of T6 Enterprise in Internet Information Services (IIS), as shown below.
In the next step, verify that all options for .Net Frameworks v3.5 and v4.5 are selected.
¶ 3. T6 Enterprise Installation
¶ 3.1. Downloading the Installer
To obtain an executable of the T6 Enterprise installer, click the following link: T6 Enterprise Installer.
By clicking the link, the download of the
Installer.exefile will start automatically.
¶ 3.2. T6 Enterprise Installer
After completing the installer download, run the Installer.exe file to start the T6 Enterprise installation process.
- Client Code: In this field, you must enter the Tech6 client code. If you do not have this code, contact the Tech6 sales department.
- Available Versions: After entering a valid client code, the installer will display the available versions for installation via a dropdown.
Only the versions available for the provided Client Code will be displayed.
- Available Builds: In the Available Builds field, you can choose which build you want, keeping in mind that the builds displayed will depend on the product version defined in the "Available Versions" field.
After filling in the fields above, the Download and Install buttons will be enabled.
- Download: By clicking the Download button, the installer will start downloading the files needed for the T6 Enterprise installation to your machine, allowing you to run it whenever necessary.
- Install: By clicking the Install button, the installer will start the T6 Enterprise installation process directly, without downloading the files to your machine.
¶ 3.3. Installation Process
If you clicked the Download button after selecting the desired version and build, the installer will download the files into a compressed folder, which will need to be extracted to proceed with the installation.
¶ 3.3.1. Extracting the Installer
Extract the contents of the Sysphera12.3_xxxxxxx.zip file into a folder of your choice. Open the extracted folder and locate the Installer.exe file.
Double-click the file to run the T6 Enterprise installer.
¶ 3.3.2. Running the Installer
Before starting the T6 Enterprise installation, it is important to note that the installation can only be performed by a user with Administrator access on the operating system.
When running the installer, you will see a brief description of T6 Enterprise on the initial screen. To proceed with the installation, click the Next button.
The next screen will display the available installation types: New installation, Update previous installation, and Remove previous installation.
- Select the New installation option and click the Next button to proceed.
After clicking Next, the following screen will display the T6 Enterprise License Agreement. Read the agreement carefully and, if you agree to the terms, select the I accept the terms of the license agreement option and click the Next button to proceed.
The next screen will request Customer Information, where you will need to enter a valid License file or the customer's Customer Code to proceed with the installation.
For more information regarding Licenses, access: Licenses.
To obtain the Customer Code, contact the sales department and request the code; this code will automatically retrieve your licenses without the need to search for or download them from the support website.
→
Locate the license.xml file or enter the Customer Code and click Browse/Find. Then proceed to the next screen. If the file or code entered is invalid, the installer will prevent the process from continuing. In case of doubt, contact the Sales representative.
The next screen is where we will define the Installation Modules, with the option to check only Install Portal, or to check both Install Portal and Install Data Provider.
The T6 Enterprise Installer allows the selection and installation of multiple modules simultaneously.
The next screen will display the prerequisites for the installation, according to the modules selected previously. If any mandatory prerequisite is not installed, the installer will display an error message and will not allow the process to continue until the prerequisite is met.
After installing the required Software, click Next to advance to the next step, where we will define the installation directory for the T6 Enterprise Portal.
On the next screen, we will define the SQL Server database connection settings, where the following data must be provided:
- Server: In the server field, enter the name of the SQL server where the database was created. Do not use localhost.
- Port: The default port to be used is port 1433. If you configured a different port on the SQL Server, fill in this field with the value defined on the server.
- Dynamic Port: If you do not know the port, confirm whether the SQL Server is running SQL Server Browser; if so, check the Dynamic Port option.
- Username: Enter the name of the user created for T6 Enterprise in the SQL Server.
- Windows Authentication: If you opted for SQL authentication, this option should remain unchecked.
- Password: Enter the password for the user created for T6 Enterprise in the SQL Server.
- Database: Enter the name of the database created for T6 Enterprise in the SQL Server.
- Do not create tables: Should not be checked when performing a New Installation; this option should only be checked when performing a version update.
The next screen relates to T6 Analytics settings, this step is optional.
The fields to fill in are the same as the previous step, with the exception of the Do Not Create Tables field.
Click Next to advance to the next step, where we will define the Reporting Services Service Settings, where the following data must be provided:
- Reporting Services URL: Enter the Report Server URL.
- User: Enter the Windows username. This user will be responsible for running the T6 Application Pool.
- Password: Enter the password for the Windows user provided.
On the next screen, we will define the Portal names for the T6 WF and UX that will be created in IIS and used in the URL to run the T6 application. If IIS has other configured sites, the T6 installer will show the "Select the IIS Site" option, so you can select which site the T6 portal will be installed on.
If the name defined for the portal already exists in IIS, it will not be possible to proceed with the installation; in this case, a different name must be defined.
After defining the portal names, click Next to advance to the next step, where we will handle the MicroStrategy parameters.
If the installation is integrated with MicroStrategy, check the Integrate Sysphera Portal with MicroStrategy checkbox and fill in the fields displayed on the screen; for more information, access: MSTR - Installation Guide.
This step is optional; if you do not use MicroStrategy, simply click Next to proceed.
The next screen, Confirm Installation, displays an installation summary; review the settings and, if correct, click Install to start the T6 Enterprise installation process.
On the next screen, Installation Progress, a progress bar will be displayed on the screen, indicating the progress of the installation as well as the installation summary, showing the completed steps and those still in progress.
→
Click Finish to complete the T6 Enterprise installation process.
If you see any errors during the installation process, refer to the Troubleshooting section of this manual.
¶ 3.3.3. Testing the Installation
To test the T6 Enterprise installation, open your preferred browser and enter the T6 portal URL configured earlier.
The browser used must support JavaScript.
¶ 3.3.4. First Access
When accessing the T6 Enterprise portal for the first time, you will be directed to the login screen. Use the default credentials below to perform the first access:
- User: admin
- Password: password
After the first access, it is highly recommended to change the default admin user password to ensure system security.
¶ 3.3.5. Creating the first application
After performing the first access to T6 Enterprise, you must create your first application. To do so, follow the steps below:
- In the T6 main menu, access the Explorer.
- In the ribbon, click New Item and select the Modeling option.
- Among the displayed options, select Application.
- A side panel will open, where we will fill in the application information.
¶ 4. T6 Enterprise Update
After performing the first T6 Enterprise installation, you can update your installation to more recent versions of the product, using the same installer used for the initial installation.
Verify that your license is valid for the version you want to update to.
¶ 4.1. Portal Backup
For security reasons, whenever a Portal update is performed, the T6 installer automatically creates a backup of the current portal.
A folder is created by the installer in the same directory where the T6 Portal was initially installed.
The example below shows the naming convention used to uniquely identify a backup directory, created during the update process of a T6 Enterprise installation:
The red part indicates the name of the portal being updated.
The blue part indicates the version number of the original T6 portal installed.
The orange part is the unique identifier number of the original installation, for that version.
NOTE: Before starting the update process, it is always ideal to perform a database backup to prevent any data loss.
To perform the update to version 12.3, verify that you are using the most recent build of version 12.1; this action will prevent possible errors in the database.
¶ 4.2. Running the Update
Before starting the T6 Enterprise update, it is important to note that the update can only be performed by a user with Administrator access on the operating system.
When running the installer, you will see a brief description of T6 Enterprise on the initial screen. To proceed with the update, click the Next button.
The next screen will display the available installation types: New installation, Update previous installation, and Remove previous installation.
- Select the Update previous installation option and click the Next button to proceed.
The T6 Enterprise License Agreement will be displayed. Read the agreement carefully and, if you agree to the terms, select the I accept the terms of the license agreement option and click the Next button to proceed.
On the next screen, you will see a list of installed T6 Enterprise portals. Select the portal you wish to update, verify the information displayed, and click Next to proceed.
There will also be an update confirmation screen, displaying a summary with the information of the selected installation. Verify the information and, if correct, click Update to start the T6 Enterprise update process.
After clicking Update, the installer will display an alert informing that the update process will restart IIS services. Click OK to proceed.
After confirming the IIS restart, the installer will start the update process, indicating the progress through a progress bar and also the update summary, showing the completed steps and those still in progress.
There will also be an update completion screen, indicating that the process finished successfully. Click Finish to complete the T6 Enterprise update process.
¶ 4.2.1. Performing a manual update
A manual update is recommended when it is necessary to restore a database with a lower build than the one installed on the portal.
This frequently occurs in environments with a Production server and a Staging server. In these types of environments, before performing the update on the Production server, T6 Enterprise tests are conducted on the Staging server database.
In this scenario, it is common to perform a backup of the Production server database and restore it on the Staging server, so that the staging portal will have a higher build than the database.
Once this restoration procedure is complete, the portal may stop working, as there are often structural changes to the database between one build and another. These changes must be applied to the restored database for the T6 Enterprise solution to work correctly.
To restore the database with a lower build and subsequently perform the manual portal update, follow the steps below:
- Restore the desired database.
- Access the address: http://<T6_Enterprise_server>/WebForm/Update.aspx to perform the update automatically.
Please note that this update can only be performed when both databases are on the same T6 Enterprise version.
¶ 5. T6 Enterprise Uninstallation
Before uninstalling T6 Enterprise, it is important to note that the uninstallation can only be performed by a user with Administrator access on the operating system.
When running the installer, you will see a brief description of T6 Enterprise on the initial screen. To proceed with the uninstallation, click the Next button.
The next screen will display the available installation types: New installation, Update previous installation, and Remove previous installation.
- Select the Remove previous installation option and click the Next button to proceed.
On the next screen, you will see a list of installed T6 Enterprise portals. Select the portal you wish to uninstall, verify the information displayed, and click Next to proceed.
There will also be an uninstallation confirmation screen, displaying a summary with the information of the selected installation. Verify the information and, if correct, click Remove to start the T6 Enterprise uninstallation process.
On the uninstallation progress screen, a progress bar will be displayed on the screen, indicating the progress of the uninstallation as well as the process summary, showing the completed steps and those still in progress.
→
There will also be an uninstallation completion screen, indicating that the process finished successfully. Click Finish to close the installer.
¶ 6. Troubleshooting
In this section, we will address possible errors that may occur during the T6 Enterprise installation or update process, as well as their respective solutions.
¶ 6.1. Error Running the T6 Enterprise Installer
When downloading the T6 Enterprise installer, Microsoft Defender SmartScreen may block the download from completing, displaying a warning message similar to the image below:
To resolve this issue, access your browser's Downloads and locate the downloaded Installer.exe file. Click the dropdown next to Delete and click the Keep anyway option to allow the file download.
If Microsoft Defender SmartScreen is not enabled in the browser, the file download will complete normally; however, a warning message may appear when trying to run it.
When trying to run the Installer.exe file, Microsoft Defender SmartScreen may display a warning message similar to the image below:
To resolve this issue, access the file location, locate the Installer.exe file, right-click on it, and select the Properties option.
In the file properties window, check the Unblock checkbox and click Apply to save the changes.
After performing this procedure, try running the Installer.exe file again.
¶ 6.2. Create Default Permission Denied in Database 'databaseName'
This error occurs when the user created in SQL Server for the T6 Enterprise installation does not have permission to create the T6 application tables. To resolve this issue, follow the steps below:
- Access SQL Server Management Studio (SSMS) and connect to the SQL server where the T6 Enterprise database is installed.
- In the Object Explorer, expand the Security folder and then the Logins folder.
- Locate the user used in the T6 Enterprise installation, right-click on it, and select the Properties option.
- In the user properties window, access the User Mapping tab.
- In the Users Mapped to This Login section, check the checkbox for the T6 Enterprise database.
- In the Database Role Membership section, verify that the db_owner option is checked; if it is not, check it.
- Click OK to save the changes.
¶ 6.3. Portal does not load or does not appear
When trying to open the portal, one of the following messages is displayed:
Message:
HTTP Error 404.0 - Not Found
The resource you are looking for has been removed, had its name changed, or is temporarily unavailable
Message:
HTTP Error 500.19 - Internal Server Error
The requested page cannot be accessed because the related configuration data for the page is invalid.
These errors occur when ASP.NET access is not configured in IIS. To resolve the issue, follow the steps described below:
- Access the IIS Services Manager.
- Click on ISAPI and CGI Restrictions.
- Select the ASP.NET v4 options and set them to Allowed, in the Restriction column.
After allowing ASP.NET v4, restart IIS and try to access the portal again.
¶ 6.4. Report Viewer Configuration Error
The Report Viewer Web Control HTTP Handler was not registered in the application's web.config file.
Message:
The Report Viewer Web Control HTTP Handler was not registered in the application's web.config file. Add <add verb="*" path="Reserved.ReportViewerWebControl.axd" type = "Microsoft.Reporting.WebForms.HttpHandler, Microsoft.ReportViewer.WebForms, Version=11.1.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91" /> to the system.web/httpHandlers section of the web.config file or add <add name="ReportViewerWebControlHandler" preCondition="integratedMode" verb="*" path="Reserved.ReportViewerWebControl.axd"type="Microsoft.Reporting.WebForms.HttpHandler, Microsoft.ReportViewer.WebForms, Version=12.1.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91" /> to the system.webServer/handlers section for Internet Information Services 7 or later.
To resolve this issue, switch the T6 Enterprise pool to classic mode.
¶ 6.5. Errors in the T6 Enterprise Update
During the T6 Enterprise update process, the installer may report error messages related to the update.
Below are some common errors and their respective solutions:
The installer version is lower than the version to be updated.
Solution: Verify that the installer used for the update is of a higher version than the installed version. Otherwise, download the correct version installer and perform the update again. The version to be installed must always be greater than the already installed version.
The installer version is equal to the version to be updated.
Solution: Verify that the installer used for the update is of a higher version than the installed version. Otherwise, download the correct version installer and perform the update again. The version to be installed must always be greater than the already installed version.
Application Locked.
Solution: The message informs which Application is locked and the user responsible for the lock. In this case, access T6 Enterprise and unlock the application.
Application pending publication.
Solution: The message informs which Application is pending publication. In this case, access T6 Enterprise and publish the indicated application.
