Applies to: SmarterTrack 3.x

Download and Install Microsoft SQL Server 2005
Download and Install Microsoft SQL Management Studio Express

1. Open Microsoft SQL Management Studio Express
2. Login identifies Server Name = XXVESUPXX\SQLEXPRESS
3. Authentication = Windows
   1. Click Connect
4. Right click the Security tab
   1. Click New Login
      1. Enter a Login Name = SmarterTrack
   2. Choose SQL Server Authentication
   3. Uncheck Enforce Password Policy
   4. Create a Password
   5. Confirm Password
   6. Click OK
5. Right click the Database Folder
   1. Click New Database
   2. Enter Database Name
   3. SmarterTrack
6. Click the Browse button to establish the Database Owner and select the SmarterTrack user you created above. 
7. Go back to the Security tab
   1. Right click SmarterTrack User
      1. Click User Mapping
      2. Check SmarterTrack database
      3. Check db_owner 
      4. Check OK  
8. Once, the database is created, login into SmarterTrack as the SysAdmin.
   1. Click on Settings
   2. Click on Database Folder
      1. Click Database Settings
      2. Enter the following:
      3. Database Type = Microsoft SQL – SQL Authentication
      4. Database Server = XXVESUPXX\SQLEXPRESS
      5. Database Name = SmarteTrack
      6. Table Prefix = st_
      7. Username  = SmarterTrack
      8. Password = XXXXXX