ASP NUKE SQL SERVER SETUP INSTRUCTIONS ====================================== 03/10/2005 This file describes how to manually setup a Microsoft SQL Server database using the supplied database scripts that come with ASPNuke. You should only attempt this if you have problems with the setup wizard or you prefer to do things the hard way! ;) SQL SERVER ---------- In order to setup the database schema, you will need to make sure you have access to a SQL Server 2000 database server and have the ability to create a new database. You may choose to have your database be hosted by a third party. In this case you will need to make sure that your login account has "db_owner" permissions giving you the ability to create, alter and delete tables. Another thing to keep in mind is that your ASP Nuke web site will need to have direct access to the server at all times. Usually, your web server and database server should be in the same room and be able to communicate with each other. Once your database is created, you will need to run the two setup scripts found in the distribution package. These files have the name: "/setup/schema.sql" and "/setup/data.sql" and will setup the database schema and data needed to run the application for the first time. The scripts contain Transact-SQL statements that you need to execute through SQL Query Analyzer.