 |
 |
 |
 |
|
 |
 |
Gravitybox Schedule.NET User’s Guide
Page 27
1998-2004 Gravitybox Software LLC
Addendum
Manual database setup
In the case where something goes wrong with the setup or your database was not
created, you can manually create the database with the provided scripts. You must run
the install and at the very least check the box to copy SQL scripts to your hard drive. By
default they will be copied to the folder “C:\Program Files\Gravitybox
Software\WebSchedule.NET\Config”.
First to create the database you will need to open SQL Enterprise Manager and click on
the server where you wish to create the database. Then click on the “Databases” node.
Once this is selected click on the “Tools” menu and select the “SQL Query Analyzer”
menu item. This will open the SQL Query Analyzer tool. Make sure that the selected
database at the top of the screen is set to “master”. Use Windows Explorer to navigate
to your “config” folder described above. Open the file “CreateDb.sql” in notepad and
copy all of the text. Paste this text in the query window and execute the query. This will
create a database named “Gravitybox” on the selected machine.
Next use Windows Explorer to open the file “CreateSchema.sql” in the “config” folder in
notepad. Copy this text and paste into the query window. Execute the script to create
the table structure in the database. This completes the creation of the database.
Manual website setup
If the setup does not create the necessary website, you can do this manually by
following these instructions. First open IIS by clicking the menu Start | Programs |
Administrative Tools | Internet Information Services. Then from this application open the
tree items until you find the websites under the current computer name. Form here you
can create a new website if you are running a Server version of Windows. If you are
running a Professional version of Windows you can only create a new virtual directory.
To create a new website, right-click on the computer name and choose New | Website.
In the wizard, you must specify a name and port for the new website. By default the
installation names the website “Gravitybox” on port 9096 but you may choose any
values you wish. The path is the folder where you VS.NET solution resides for the
sample website. By default this path is located at the following location: “C:\Program
Files\Gravitybox Software\WebSchedule.NET\WebSample\VB.NET
Examples\WebScheduleSite”. Grant all permissions to the folder on the last screen of
the wizard as well.
Alternatively if you are using a version of IIS that does not support multiple websites,
you can create a new virtual directory. Right-click on the “Default Web Site” and choose
 |