Professional ASP.NET 1.1

------------------------------------- Data Access Samples for Professional ASP.NET 1.1 Special Edition ------------------------------------- Setup Notes ------------------------------------- -------------------------------------- Creating the Database for the Examples -------------------------------------- To create the sample database in SQL Server (based on version 7.0): - Using Enterprise Manager create a new empty database named "WroxBooks" - Open SQL Server Query Analyzer from the Tools menu - Make sure you select "WroxBooks" from the drop-down DB list - Open the file "make_tables.sql" and execute it - Open the file "insert_data.sql" and execute it Then edit the file "config.web" in the samples root directory so that the connection strings point to your server. The user "anon" is created by the scripts above and automatically given full access. -------------------------------------- Specifying the File Access Permissions -------------------------------------- Some of the examples files require Write access to the servers wwwroot folder and subfolders below this. By default, ASP.NET runs under the context of the ASPNET account that is created by the installation and setup of the .NET Frameworks. This is a relatively unprivileged account that has similar permissions by default as the IUSR account that is used by Internet Information Services. To give folders Write access for ASP.NET, right-click on the wwwroot folder in Windows Explorer and open the Properties dialog. In the Security tab, select the ASPNET account and give it Write permission or Full Control. Then click Advanced and tick the checkbox at the bottom of this page ("Reset permissions on all child objects..."). Alternatively, configure ASP.NET to run under the context of the local System account by editing the machine.config file located in the config directory of the installation root. By default this directory is: C:\WINNT\Microsoft.NET\Framework\[version]\CONFIG\. NOTE: You should only do this while experimenting, and only on a development server. For a production server, you should set up only the minimal permissions required for your applications to run. -------------------------------------