Install SQL Server

Languages:

[[::Install SQL Server|English]]  • [[::Install SQL Server/sv|svenska]]

The Heureka softwares use Microsoft SQL Server 2005 for storing data (see also 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 2005 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 4 GB, but apart from that it has all the functionality needed for Heureka's applications.

Installing SQL Server

1. Installing SQL Server 2005 Express
2. Installing SQL Server Management Studio
3. You must have the .NET framework 2.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.

Install the forest database

• Install new database with or without demo data.
• Install existing database.

Known issues

• If you experience problems such as "Cannot connect ..." it may be due to that the local database server is not started. Go to Control Panel > Administrative Tools > Services. Make sure "SQL Server (SQLExpress)" or "SQL Server (MSSQLSERVER)" is running. If not, right click and select "Start". Make sure it is set to start automatically.

• If you experience problems such as error 1069 and the server does not seem to be running, it may be because you have changed your Windows or AD password. The SQL Server service must be updated manually, it is not done automatically. Under Administrative Tools > Services, right-click SQL Server (MSSQLSERVER) or SQL Server (SQLEXPRESS) and select "Properties", tab "Log on", and enter the password.

• Vista user? When running SQL Server 2005 Express in Vista environment it may be necessary to edit permissions [1]. Try the following:

1. Log in to SQL Server 2005 Express as an administrator by right-clicking the SQL Server Management Studio and select "Run as admininstrator" (possibly you may have to go into the "Control Panel" , select "User" (?) and disable the UAC).
2. Select localhost\SQLExpress as the server.
3. Select the "Security" option from the tree view in Object Explorer.
4. Right click on the "Login", select "New Login". Add User, type AD\nnn.
5. Before you close the window for "New login", click "Server Roles" and select "Sysadmin".