Getting Started

Here are the high-level steps to install Texdora:

  1. Download and install MS SQL Server 2014 Express Edition in your local machine or central server.
  2. Download and install SQL Server 2014 Management Studio.
  3. Create tables and upload seed date.
  4. Download and Install Texdora Installer.
  5. Edit the configuration files in Texdora User and Administration module.
  6. Verify your installation by logging into Texdora User and Administration.

Total time: 30 to 40 minutes

Important: Enterprise users must install the MS SQL Server 2014, SQL Server 2014 Management Studio, and Texdora Administration module in the central server. Roles, users, stylesets, and tree hierarchies are defined in the Texdora Administration module.

The Texdora User module must be installed in each user machine. The user machines connect to the central server to access the database and are granted access based on the roles and access defined in the Texdora Administration module. All content created in by users are stored in the database.

Use the Internet Protocol (IP) address of the central server in the configuration files for Texdora User and Administration module.

Single users must download and install the MS SQL Server 2014, SQL Server 2014 Management Studio, Texdora Administration, and Texdora User module in the local machine.

Download and install MS SQL Server 2014 Express Edition from the MSDN website

While most of the installation is straightforward, you must ensure that you select the Mixed mode (SQL Server authentication and Windows authentication) in the Database Engine Configuration screen.

By default, MS SQL Server assigns sa as the user ID. You can change this ID later but you must set the password in this screen. Remember to note down the password. You will need it to connect to the database using SQL Server 2014 Management Studio and to update the Texdora User and Administration configuration files later in the installation process. For details, see MSDN installation instructions.

Download and install SQL Server 2014 Management Studio from the MSDN website

  1. Click Download and scroll to the end of the page.
  2. Select the 32 or 64 bit installer depending on your system.

Create Tables and Upload Seed Data

  1. Go to Start > All Programs > Microsoft SQL Server 2014 > SQL Server 2014 Management Studio

  2. Enter these details to connect to SQL Server 2014 through the SQL Server 2014 Management Studio.

Server type: Database Engine

Server name: You PC name. In most cases, the server name is populated by default.

Authentication: SQL Server Authentication. Do not use Windows authentication.

Login: sa

Note: The Login name is set by system default. If you have changed the login name, then enter the new login name. We recommend that you do not change the login name unless you are very familiar with SQL Server 2014 Management Studio.

Password: Enter the password that you provided in the Database Engine Configuration page when installing SQL Server 2014.

*Note: If you don’t remember the password or didn’t specify Mixed Mode (SQL Server authentication and Windows authentication) in the Database Engine Configuration page, then exit SQL Server 2014 Management Studio and reinstall SQL Server 2014. Remember to select Mixed Mode and note the password this time around. *

Once you connect to SQL Server 2014, you need to run a script or restore the database which will create the required tables and populate the database with seed data. Seed data refers to minimum data, such as roles and user login accounts needed to get started with creating a new book.

Running a Script to Create Tables and Populate Database

  1. To run the script, download the script file, createdatabse.sql to your local machine. The script file is provided with the installer package.
  2. Open SQL Server 2014 Management Studio and click New Query.
  3. Go to the folder where you extracted TexdoraInstaller.zip, locate createdatabse.sql and double-click. A new pane will show up on the right in the QL Server 2014 Management Studio with the script.
  4. Click Execute.

This creates the Texdora database and populates it with minimum data to get started.

Using the Database Restore Method to Create Tables and Populate the Database

  1. Navigate to SQL Server 2014 through the SQL Server 2014 Management Studio.
  2. Connect to SQL Server SQL Server 2014 through the SQL Server 2014 Management Studio.
  3. Right-click on Database.
  4. Click Restore Database. The Restore Database window appears.
  5. Select Device.
  6. Click . The Select Backup Devices dialog appears.
  7. Click Add.
  8. Go to C:\Program Files\Microsoft SQL Server\MSSQL12.SQLEXPRESS\MSSQL\Backup.
  9. Select Texdora.bak. This file is provided as part of the installer package.
  10. Click Ok. This should create the Texdora database in your SQL Server.
  11. To verify the installation, expand the database, Texdora. You should see the tables within the database as shown below:

Installing and Configuring Texdora User Manager and Texdora Client

  1. Go to www.texdora.com/Trail
  2. Complete the payment to download a licensed copy of Texdora User and Administration modules. Texdora Installer consists of two folders: TexdoraSetup and Texdora User Manager within TexdoraInstaller.zip. Extract the zip file in your local machine or server. Enterprise users must install Texdora User Manager in the central server.
  3. Unzip TexdoraInstaller.zip in your local machine. You can unzip the folders in either C: or D: drive. A new folder, Texdora User Manager is created.

Setting Up the Administration Module

  1. Open Texdora User Manager and double-click Setup.exe.
  2. Click through the wizard until the installation is complete. The User Manager would have deployed the files in a folder named, TexdoraAdmin.
  3. Navigate to the Texdora Admin folder and look for the TexDora Administration.exe.config file. Do not attempt to open the file directly.
  4. Go to the Windows Start button and type Notepad in the Search bar.
  5. When Notepad appears under program, right-click.
  6. Open Notepad in Run as Administrator mode.
  7. Navigate to the Texdora Admin folder and open the TexDora Administration.exe.config file.
  8. Scroll down to the bottom of the notepad file and search for:

<value>Data Source=JOHN-LAP\SQLEXPRESS;Database=Texdora;Persist Security Info=True;User ID=sa;Password=mypassword</value>

  1. Replace the values in the file with your machine name, user ID and password that you entered when installing the database. For example:

<value>Data Source=JOHNC-LAP\SQLEXPRESS;Database=Texdora;Persist Security Info=True;User ID=sa;Password=yourpassword</value>

  1. Save the notepad file.
  2. To verify that the installation has been successful, double-click TexDora Administration.exe.
  3. Click Run.
  4. Enter mandy as the user ID, role as System Administrator, and password as mandy123.

Note: Texdora Admin must be connected to the database correctly for you to be able to log into the system successfully. The values you set in the TexDora Administration.exe.config is key to establishing a working connection. If your connection is not set up correctly, the system will throw an error message when you try to select a role the first time. See the Troubleshooting section for solutions to common errors. We are soon coming up with a common installer that will install all the artifacts automatically. Stay tuned!

  1. If your database installation and the settings in the configuration files are correct, the Texdora Admin window comes up after successful login.

Setting Up the User Module

  1. Open the TexdoraSetup folder and double-click setup.exe.
  2. Click through the wizard until the installation is complete. Texdora Setup would have deployed the files in C:\Program Files (x86)\Default Company Name\TexdoraSetup
  3. Open the Texdora.exe.config file in Run as Administrator mode.
  4. Scroll down to the bottom of the notepad file and search for:

<value>Data Source=JOHN-LAP\SQLEXPRESS;Database=Texdora;Persist Security Info=True;User ID=sa;Password=mypassword</value>

  1. Replace the values in the file with your machine name, user ID and password that you entered when installing the database. For example:

<value>Data Source=JOHN-LAP\SQLEXPRESS;Database=Texdora;Persist Security Info=True;User ID=sa;Password=yourpassword</value>

  1. Save the notepad file.
  2. To verify that the installation has been successful, double-click Texdora.exe.
  3. Click Run.
  4. Enter mandy as the user ID, role as System Administrator, and password as mandy123.

Note: Texdora User must be connected to the database correctly for you to be able to log into the system successfully. The values you set in the Texdora.exe.config file is key to establishing a working connection. If your connection is not set up correctly, the system will throw an error message when you try to select a role the first time. See the Troubleshooting section for solutions to common errors. We are soon coming up with a common installer that will install all the artifacts automatically. Stay tuned!

  1. If your database installation and the settings in the configuration files are correct, the Texdora User module comes up after successful login.