Difference between revisions of "Installation"

From dbscript Online Help
Jump to: navigation, search
(→‎SQL Server)
(→‎SQL Server)
Line 12: Line 12:
 
* Create a database
 
* Create a database
 
* In the database, run the scripts:
 
* In the database, run the scripts:
−
* dbscript.sql
+
* create.sql
−
* values.sql
+
* valuescript.sql
−
* codesnippets.sql
 
  
−
SQL Server must allow SQL Server authorization. Make sure you can connect to the database with the intended username and password. The username should have dbo access to the database.
+
* In the Users table, create a record with the ID containing the desired username, and IsAdmin set to true.
  
−
* The Users table contains a single record. Set the ID value to the username you want to use as login to the web application (this is *not* the database username)
+
* Run codesnippets.sql
 +
 
 +
SQL Server must allow SQL Server authorization.
 +
 
 +
Create a database login:
 +
 
 +
* SQL Server authorization
 +
* no password policy)
 +
* dbo access to the database.
  
 
=== IIS Server ===
 
=== IIS Server ===

Revision as of 19:54, 13 November 2008

Server Requirements

  • IIS running on Windows 2000 or higher.
  • ASP.Net 2.0
  • MS Ajax Control Toolkit
  • SQL Server 2000 or higher

Software Installation

SQL Server

  • Create a database
  • In the database, run the scripts:
  • create.sql
  • valuescript.sql
  • In the Users table, create a record with the ID containing the desired username, and IsAdmin set to true.
  • Run codesnippets.sql

SQL Server must allow SQL Server authorization.

Create a database login:

  • SQL Server authorization
  • no password policy)
  • dbo access to the database.

IIS Server

  • Create a directory, virtual directory, or website in IIS Administrator
  • Extract web.zip into the directory
  • Extract web.config.zip into the directory
  • Locate the connection string in web.config and adjust server name, catalog, username, and password.
  • Start your webbrowser and navigate to the URL of your installation
  • Login using the selected username without password
  • Navigate to Settings, upload you license key file