Create Forest Database: Difference between revisions

From Heureka Wiki
Jump to navigation Jump to search
← Older editNewer edit →
No edit summary
No edit summary
Line 6: Line 6:


# Start PlanStart
# Start PlanStart
# Select "Create Database Forest" from the "Tools" menu
# Select "Create Forest Database" from the "Tools" menu
# Enter the server name under "Server":
# Enter the server name under "Server":
## If you have installed the free version, SQL Server 2005 Express, enter "localhost\SQLExpress"
## If you have the free version, SQL Server 2005 Express, enter "LOCALHOST\SQLEXPRESS" if you are about to install the database locally
## If you have the commercial version of SQL Server, enter "localhost" if you install the database locally, or the server name if you are installing on a remote server.
## If you have the commercial version of SQL Server, enter "LOCALHOST" if you are about to install the database locally
# If you install locally, leave "Authentication" mode equal to "Windows authentication".
## If you are about to install the database on a remote server, enter the remote server name
# In "Database name", type a database name (without blanks).
# If you install locally, leave "Authentication" mode equal to "Windows Authentication"
# Check "Create demo database" if you want to create a database with som demonstration data. Leave it unchecked to create an empty database.
# In "Database name", enter a database name (without blanks)
# Click on "Create Database" and wait until ready.
# Check "Include demo data" if you want to create a database with some demonstration data. Leave it unchecked to create an empty database
# 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.''


[[Category:Reference Manual]]
[[Category:Reference Manual]]

Revision as of 08:45, 1 October 2010

Languages Languages: 

English  • svenska

See also Install Existing 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.

Retrieved from "https://www.heurekaslu.se/w/index.php?title=Create_Forest_Database&oldid=4843"