1
edit
Changes
→Database Step Up
===Database Step Up===
# Create a database in MS Open ''SQL Query Analyzer'', and connect to the warp server (''http://warp.senecac.on.ca''), using whichever database name SQL Authentication. # Enter your user ID and password, and click ''Connect''<br/> (INSERT SCREEN SHOT)# Once you would likeare authenticated, select ''File -> Open'' and navigate to the location where the script, ''otts_schema.sql'' is located.#Validate the script by pressing ''CTRL + F5''# Run Once the validation is complete, run the MS SQL script provided by pressing ''F5''oTTs. The query should read '', otts_schema1 row(s) affected.'' The database is now setup.sql<br/>(INSERT SCREEN SHOT)
<br />
'''Note:''' By default after the script has been executed, there will be a master adminstrator login in the database. It is recommended to use this login in order to create the initial adminstrator login before using the system. It is also '''''highly''''' recommended that the master administrator login be deleted upon initial login. Since the master adminsitrator login does not have a valid email, simply changing the password is not allowed.<br/><br />
