Difference between revisions of "Installation"

From dbscript Online Help
Jump to: navigation, search
(IIS Server)
(SQL Server)
Line 14: Line 14:
 
* create.sql
 
* create.sql
 
* valuescript.sql
 
* valuescript.sql
 +
* codesnippets.sql
  
* In the Users table, create a record with the ID containing the desired username, and IsAdmin set to true.
+
The Users table contains one record with the ID "Administrator". You can change the ID to your desired username to log in to the application.
 
 
* Run codesnippets.sql
 
  
 
SQL Server must allow SQL Server authorization.  
 
SQL Server must allow SQL Server authorization.  

Revision as of 19:08, 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
  • codesnippets.sql

The Users table contains one record with the ID "Administrator". You can change the ID to your desired username to log in to the application.

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
  • Copy web.config 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