Difference between revisions of "Install SQL Server"
Jump to navigation
Jump to search
| (11 intermediate revisions by 2 users not shown) | |||
| Line 1: | Line 1: | ||
| − | {{Languages}} | + | {{Languages | Install_SQL_Server}} |
| − | + | See help documentation [{{HeurekaHelpLinkEng}}installera_sql_server.htm Install SQL Server] | |
| − | 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. | ||
| + | |||
| + | 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 == | ||
| − | # | + | # Download SQl Server Express (free): |
| − | # | + | ## 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 | + | ## 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 == | ||
| − | + | 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. | |
| − | |||
== Known issues == | == Known issues == | ||
| Line 26: | 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]] | ||
Latest revision as of 07:08, 19 April 2024
See help documentation Install SQL Server