Installing the Job Site


To install the job site, you need to complete the following two steps:

  1. Create a virtual directory named aspnetjobs .

  2. Execute the InstallAspNETJobsDatabase.sql script to install all the necessary database objects.

First, copy all the files from the CD-ROM to a directory on your computer. Next, launch Internet Services Manager and create a new virtual directory named aspnetjobs that points to the directory where you copied the files.

Next, install all the tables and stored procedures used by the job site. An installation script for the database objects is included on the CD-ROM that accompanies this book. Follow these steps:

  1. Launch Microsoft SQL Server Query Analyzer. Make sure you login using the sa account.

  2. Open the InstallAspNETJobsDatabase.sql script in Query Analyzer.

  3. Execute the script (click the green VCR Run button) in Query Analyzer.

The script creates a new database named AspNETJobs . It automatically adds all the necessary database tables and stored procedures. Finally, it adds a new login named AspNETJobsUser with the password secret .

CAUTION

The InstallAspNETJobsDatabase.sql script assumes that you have your SQL Server database configured to use SQL Server authentication. If you have only Windows authentication enabled, you need to manually add a login that has access to the AspNETJobs database. You'll also need to modify the Web.Config file to use the proper login.


After you complete these steps, you can request the home page of the job site application by entering the following URL in your browser:

http://localhost/aspnetjobs

NOTE

If you encounter problems when executing the InstallAspNETJobsDatabase.sql script, try stopping and starting your database server to clear away any existing connections.




ASP.NET Unleashed
ASP.NET 4 Unleashed
ISBN: 0672331128
EAN: 2147483647
Year: 2003
Pages: 263

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net