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