Create Forest Database

From Heureka Wiki
Revision as of 09:45, 1 October 2010 by Hah (talk | contribs)
Jump to navigation Jump to search

See also Install database

(New since version 1.0.3).

  1. Start PlanStart
  2. Select "Create Forest Database" from the "Tools" menu
  3. Enter the server name under "Server":
    1. If you have the free version, SQL Server 2005 Express, enter "LOCALHOST\SQLEXPRESS" if you are about to install the database locally
    2. If you have the commercial version of SQL Server, enter "LOCALHOST" if you are about to install the database locally
    3. If you are about to install the database on a remote server, enter the remote server name
  4. If you install locally, leave "Authentication" mode equal to "Windows Authentication"
  5. In "Database name", enter a database name (without blanks)
  6. Check "Include demo data" if you want to create a database with some demonstration data. Leave it unchecked to create an empty database
  7. Click the "Create Database"-button and await success

NB: The folder where the forest database is locally stored (e.g., C:\PROGRAM\MICROSOFT SQL SERVER\MSSQL10.MSSQLSERVER\MSSQL\DATA) can not be in "Compression mode". Right-click the DATA folder, select "Properties" and "Advanced settings..." and make sure "Compress content..." is unchecked.