| 1 | = How to setup an OKB server = |
| 2 | Warning: This page is work in progress. |
| 3 | == Certificate and Authentication == |
| 4 | * Follow UsersHowtosDevelopServices |
| 5 | * Notes on using SQL Server 2008 R2: |
| 6 | * In the connection string the `.\SQLEXPRESS` should be changed to `.` . For example in the command to create the ASP.NET authentication database: |
| 7 | `aspnet_regsql.exe -C "data source=.;Integrated Security=SSPI" -A all -d HeuristicLab.Authentication`. |
| 8 | * If the above mentioned command fails with a timeout, the error could be a compatibility problem between the 2005 and 2008R2 SQL Server versions. |
| 9 | SQL Server Management Studio offers the option in the database properties to set the compatibility level to SQL Server 2005 and this should fix the problem. |
| 10 | |
| 11 | == Setup IIS == |
| 12 | * Open IIS Manager |
| 13 | * Create an application pool (!HeuristicLab.OKB, .net 4.x, integrated) |
| 14 | * Open advanced settings of the application pool and select `NetworkService` as identity (if you don't have your own identities for IIS `AppPools`) |
| 15 | * Create a new website (or use an existing one) |
| 16 | * Go to bindings of the website. |
| 17 | * Add a http-binding with port 80. |
| 18 | * Create a new application within the website and call it !HeuristicLab.OKB and use the already created appPool !HeuristicLab.OKB |
| 19 | * Open advanced settings of the application and enter `http` as enabled protocols |
| 20 | * Grant the usergroup `IIS_IUSRS` read-permissions on the application directory |
| 21 | * Grant the `NETWORK SERVICE` group read access to the certificate you created in UsersHowtosDevelopServices |
| 22 | |
| 23 | == Add groups and users to the authentication db == |
| 24 | |
| 25 | |
| 26 | == Setup OKB database == |
| 27 | * Open `Create OKB.sql` and check if the path in the CREATE DATABASE statement is the location where you store your databases. |
| 28 | * Use the SQL Server Management Studio to open and execute the following two scripts in this order: |
| 29 | * `Create OKB.sql` |
| 30 | * `Initialize OKB.sql` |
| 31 | * Both scripts can be found in `HeuristicLab.Services.OKB.DataAccess\3.3\SQL Scripts` |
| 32 | * Use the SQL Server Management Studio to create a new login for the `NETWORK SERVICE` group (or the identity you defined when creating the application pool): In Object Explorer: Security -> Logins -> right click (New Login...). Next you have to add the login to the two created `HeuristicLab` databases (`HeuristicLab.Hive-3.3`, `HeuristicLab.Authentication`) in the `Users` section (in Object Explorer: Databases -> !HeuristicLab.* -> Security -> Users -> right click (New User...)). |