Changes between Version 20 and Version 21 of Documentation/Howto/SetupHiveServer

Timestamp:

07/10/14 17:06:57 (10 years ago)

Author:

ascheibe

Comment:

--

Documentation/Howto/SetupHiveServer

@@ -73 +73 @@
  * 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...)).
 
+== Setup Access Service database ==   
+
+Hive uses HeuristicLab's Access Service. This service is a wrapper around ASP.NET's authentication service and provides besides user management also client management functionality. Hive directly uses the Access Service's assemblies, so you don't have to set up the Access service, but you need to create the database:  
+
+* Use the SQL Server Management Studio to open and execute the following three scripts in this order (located in HeuristicLab.Services.Access.DataAccess\3.3\SQL Scripts\):   
+   * `Create AccessServiceDB.sql`  
+   * `Initialize AccessServiceDB.sql`  
+   * `Create Initial Values.sql`  
+* Add the user `NETWORK SERVICE` (or the identity you defined when creating the application pool) to the database: in the `Users` section (in Object Explorer: Databases -> HeuristicLab.AccessService -> Security -> Users -> right click (New User...) give the new user at least read and write access.  
+
+
 == Install the Janitor Service ==
 There are some tasks on the server which have to be executed periodically. Previously this logic was executed with the heartbeats that the slaves sent. Because this lead to performance problems there is now an own windows service with an installer. Simply copy the  !HeuristicLab.Services.Hive.!JanitorServiceSetup-3.3.msi file to your server and install it.