Navigation¶

• Main Page
  

• Random Page
• Create a new Page
• All Pages
• Categories
  

• Administration
• File Management
  

• Login/Logout
• Language Selection
• Your Profile
• Create Account
  

Quick Search
»
Advanced Search »

Installation

Table of Contents [Hide/Show] 1 - Setup    1.1 - SQL Setup       1.1.1 - Make new Database       1.1.2 - Make your SQL Login    1.2 - IIS Setup    1.3 - Folder Setup    1.4 - Modify your ConnectionString 2 - Installation Wizard    2.1 - Setup Instructions    2.2 - Database Creation    2.3 - Initial AD Setup    2.4 - Almost Done... 3 - Upgrading from v1.05 to v2.0 4 - More Information

1 - Setup¶

There are a few things you need to set up prior to running the installation wizard.

Top

1.1 - SQL Setup¶

Top

1.1.1 - Make new Database¶

• In SQL Server Management Studio right click on Databases and then click New Database...
• In the New Database dialogue make the Database name 'SlickTicket' and click OK
  

Top

1.1.2 - Make your SQL Login¶

You have a few ways to go about this:

• Make a Login/User with a Query (you can do this with the GUI as well if you know how)
  • Click the New Query button in the upper left
  • In the query window, enter the following SQL (substituting your 'loginName' and 'password' - remember these, as they will be use din your ConnectionString later) then click Execute:
    

    
    CREATE LOGIN loginName
    WITH PASSWORD = 'password';
    USE SlickTicket;
    CREATE USER loginName FOR LOGIN loginName
    

    
    
• Now that your user/login is made, you need to give it permissions
  • Under Databases > Security > Logins you will see your newly created login, right click on it and choose Properties
    • Change Default database to 'SlickTicket' click OK
  • Under Databases > SlickTicket > Security > Users you will see your newly created user, right click on it and choose Properties
    • Under General check db_onwer, db_reader and db_writer in Database role membership click OK
      

Now your DB User/Login is set up.

Top

1.2 - IIS Setup¶

• In IIS, make a new website
• Make sure you disable Anonymous Access
  

Top

1.3 - Folder Setup¶

• Copy all of the unzipped files from the download into your website folder assigned in IIS
• Set read/write permissions on the root/setup folder to Everyone
  1. Navigate to the "X:\root\setup" folder
  2. Right-mouse and select properties
  3. Select the "Security" tab
  4. Select "Add ..."
  5. Enter user "Everyone" and click "OK"
  6. Select read and write permissions (click the check-boxes).
  7. Click "OK".
• Set read/write permissions on the root/attachments folder to Authenticated Users
  • See instructions for "Everyone" above
• Set read/write permissions on the App_Data folder to Authenticated Users
  • See instructions for "Everyone" above
    

Note: I had more success by setting "Authenticated Users" with read/write/modify at the root. Otherwise changes to Admin/Settings/Appearance failed. roy_tate, 2010/08/25 15:16

Top

1.4 - Modify your ConnectionString¶

This is located in your web.config file in the root; if you are using SQLExpress on the local machine, leave the Data Source it as it is in the download.

• Windows Authentication
  

  
  <add name="SlickTicket" connectionString="
  Data Source=YOUR_SQL_SERVER;          
  Initial Catalog=SlickTicket;
  Integrated Security=True"
  providerName="System.Data.SqlClient"/>
  

  
  
• SQL Authentication
  

  
  <add name="SlickTicket" connectionString="
  Data Source=YOUR_SQL_SERVER;          
  Initial Catalog=SlickTicket;
  User ID=loginName;
  Password=password"
  providerName="System.Data.SqlClient"/>
  

  
  
  You are now set up and ready to run the install wizard!
  

Top

2 - Installation Wizard¶

This wizard walks you through the setup of your tables and initial Active Directory setup, it should be self-explanatory, there is also a handy installation video on the video page of Slick-Ticket.

Top

2.1 - Setup Instructions¶

• Navigate to your new website, you will automatically be redirected to root/setup
• Click Start Setup
  

Top

2.2 - Database Creation¶

• We have already gone through the notes on this page, just click on Create tables
• Click next
  

Top

2.3 - Initial AD Setup ¶

Here you will see a list of AD groups you are a part of. Initially, you must pick at least one of these groups and assign it an access level greater than 1; you can change this later though.

• Pick a group from the list of AD groups and pick an Access Level for it, click Commit
• Click next
  

Top

2.4 - Almost Done...¶

You are basically set up now, be sure to navigate to root/profile.aspx right away and fill out your profile, as the first person to fill out their profile will be made an admin. Be sure to complete the Initial Setup before you let your users loose.

Top

3 - Upgrading from v1.05 to v2.0¶

• Download the patch program
• Copy it over your 1.05 installation
• Run the upgrade wizard (just run the program)
• Download Slick-Ticket v2.0
• Copy it over the patch program
  

optional steps

• Run patch/globalization.sql on your database to turn all TEXT columns to NVARCHAR(MAX) and all remaining VARCHAR(x) columns to NVARCHAR(x)
• Delete the setup and patch folders
  
  

Top

4 - More Information¶

There are plenty of resources available for more information:

• Search this wiki for more info
• Check on your instance of SlickTicket under root/help.aspx as the FAQ will be pre-populated with some often asked questions
• For admin specific questions, check root/admin/info.aspx
• Hit the Slick-Ticket Forum on CodePlex
  

Top