|
|
| (32 intermediate revisions by 3 users not shown) |
| Line 1: |
Line 1: |
| − | {{Languages/sv}} | + | {{Languages | Install_SQL_Server}} |
| − | Microsoft SQL Server
| |
| | | | |
| − | Both input and result data is stored in SQL Server 2005 databas.
| + | See help documentation [{{HeurekaHelpLinkEng}}installera_sql_server.htm Install SQL Server] |
| | | | |
| | + | <!-- |
| | + | The Heureka softwares use Microsoft SQL Server for storing data (see also [[Introduction_to_Projects | Introduction to Projects]]). The input data is stored in one database (called "forest database"), and the result data in another ("result database"). You may store data locally, on a server, or both. At an organisation with many users, it may be practical to store forest input data on a central server, and result data locally on the client machines. |
| | | | |
| − | (in a wood base, see also [[Introduction_to_Projects | Introduction to Projects]]). To save the results do, however, preferably do this on your own computer (in a results database). Then you need database software SQL Server 2005, which is available as a free version called SQL Server 2005 Express. You may also want to install this to get away from being connected, and have input base on the computer instead of on the server.
| + | SQL Server is available both as commercial versions, and as a free version. The free version is called SQL Server 2005 Express. It has a limited storage capacity of 10 GB, but apart from that it has all the functionality needed for Heureka's applications. We recommend using version 2012, but versions 2005 and 2008 also work. |
| | | | |
| | == Installing SQL Server == | | == Installing SQL Server == |
| − | # Installing [http://www.microsoft.com/downloads/details.aspx?familyid=31711D5D-725C-4AFA-9D65-E4465CDFF1E7&displaylang=en SQL Server 2005 Express] | + | # Download SQl Server Express (free): |
| − | # Installing [http://www.microsoft.com/downloads/details.aspx?familyid=6053C6F8-82C8-479C-B25B-9ACA13141C9E&displaylang=en SQL Server Management Studio] | + | ## 32-bit version: [http://download.microsoft.com/download/5/2/9/529FEF7B-2EFB-439E-A2D1-A1533227CD69/SQLEXPRWT_x86_ENU.exe SQL Server 2012 Express 32 bit] |
| − | # You must have the .NET framework 2.0 or later installed (If not, th installation will automatically be invoked during installation). | + | ## 64-bit version: [http://download.microsoft.com/download/5/2/9/529FEF7B-2EFB-439E-A2D1-A1533227CD69/SQLEXPRWT_x64_ENU.exe SQL Server 2012 Express 64 bit] |
| | + | # You must have the .NET framework 4.0 or later installed (if not, the installation will automatically be invoked during installation). |
| | Note: The file management in SQL Server is different from that one may be used to from database software such as Access. In SQL Server, there are data files, but you do not open them directly, but install them as instances in SQL Server. When you connect to a database, you will choose the name you chose in paragraph 6 above. | | Note: The file management in SQL Server is different from that one may be used to from database software such as Access. In SQL Server, there are data files, but you do not open them directly, but install them as instances in SQL Server. When you connect to a database, you will choose the name you chose in paragraph 6 above. |
| | | | |
| | == Install the forest database == | | == Install the forest database == |
| − | The input database must be installed, while the result database is created programatically by RegWise and PlanWise. StandWise does save results. Instructions:
| + | After opening the Heureka program (for example PlanWise), create a new project and select the name of the input database. If the database does not exist, it will be created automatically, including some demonstration data if you want to. |
| − | #Download an empty backup file (. Bak) of [ftp://salix.slu.se/Download/Heureka/Databases/ SLU FTP server] and save to your hard disk, for example, C:\TEMP\. If you are installing on a server, the file must be available locally on the server, and you must be logged on the server. You can also use another backup of a database that already contains data, if you have access to such.
| |
| − | | |
| − | === Alternative 1: Use function in PlanStart to install database ===
| |
| − | This is the easiest method which does the same as in option 2 below, but in a simpler way. You use a function in PlanStart to create a database to which you can then import forest data, for example with [[The import of standalone registry | import a stock index]]. Do the following:
| |
| − | # Start PlanStart
| |
| − | # Select "Create Database Forest" from the "Tools" menu
| |
| − | # Click the "Browse"-button and select the directory where the backup file is located, eg C:\TEMP\.
| |
| − | # Select the backup file and click "Open". Note: Windows Vista may be sensitive to where the backup file is put, because SQL Server in Vista has restricted reading access. Anyhow, C:\temp\ should be OK.
| |
| − | # Enter the server name under the "Server":
| |
| − | # # If you have installed the free version, SQL Server 2005 Express, enter "localhost\SQLExpress"
| |
| − | # # 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 install locally, leave "Authentication" mode equal to "Windows authentication".
| |
| − | # In "Database name", type a database name (without blanks)
| |
| − | # Click the "Browse ..."-button next to "Location of data file", and specify a location where you want to save the database. See (4) above concerning problems with Vista.
| |
| − | # Click on "Create Database" and wait until ready.
| |
| − | | |
| − | If this does not work, then try the options below. See end of this page for common problems.
| |
| − | | |
| − | === Alternative 2: Run the "Restore" in SQL Server Management Studio ===
| |
| − | # Open Management Studio. Enter the server name (localhost, localhost\SQLExpress, or the server name).
| |
| − | # Right click on "Databases", select "New Database ..." and enter a name for the new database (no blanks or spaces)
| |
| − | # Right-click the new database, select "Tasks" > "Restore" > "Database ...".
| |
| − | # As the source, select "From device" and "..."-button. Click "Add", and locate the backup-file.
| |
| − | # Check "Restore" for both files (including log-file if it exists)
| |
| − | # In "Options", select "Overwrite ..." and change the "Restore as ..." to valid paths (folders must exist on your computer if you install locally, and on the server if you install on a remote server.
| |
| − | | |
| − | === Alternative. 3: Installing an .mdf file via the "Attach"-option in SQL Server Management Studio ===
| |
| − | This alternative is available if you have an -mdf-file instead of a backup (.bak) file.
| |
| − | # Open Management Studio. Enter the server name (localhost, localhost\SQLExpress, or the server name).
| |
| − | # Right click on "Databases", select "New Database ..." and enter a name for the new database (no blanks or spaces)
| |
| − | # Right click on "Databases" and select "Attach".
| |
| − | # Click "Add" and select the .ndf file.
| |
| − | # In the "Database details', check and if necessary edit the file path to valid ones.
| |
| − | | |
| | | | |
| | == Known issues == | | == Known issues == |
| Line 61: |
Line 29: |
| | # Right click on the "Login", select "New Login". Add User, type AD\nnn. | | # Right click on the "Login", select "New Login". Add User, type AD\nnn. |
| | # Before you close the window for "New login", click "Server Roles" and select "Sysadmin". | | # Before you close the window for "New login", click "Server Roles" and select "Sysadmin". |
| | + | |
| | + | --> |
| | | | |
| | [[Category: Database]] | | [[Category: Database]] |
| | [[Category: Reference Manual]] | | [[Category: Reference Manual]] |
