The initial setup of {{UBIK}} and its components requires some extensive but straight forward steps. This guide gives an overview about the dependencies of the different components, whereas more detailed installation instructions can be found in separate linked articles, respectively.
A section The next sections covers the components required for the use cases as mentioned in the [[Getting_Started#Introduction|introduction]], respectively. Specific configurations related to the {{UBIK Web Service}} will be discussed subsequently.
== Setup for Data Model Administration ==
Of course, it is also possible to use another authentication mode like [[USAM#LAS_.28Local_Application_Service.29|Local Application Service]].
=== UBIK Database ===
Set up the database either by importing an export file of an existing database or by executing the
** [Create empty SQL DB + execute SQL script]
* UBIK Studio
* .NET Framework 4.0
• UBIK Application (Android, Windows)
• Use cases
o UBIK Studio only: SL
o Working with client (mobile, web): LAS + USAM
== Setup web
• Web service
o Content
o Optional: Push
***Configuration: endpoints, bindings
All content and configuration data of {{UBIK}} is managed in a [http://www.microsoft.com/en-us/sqlserver/default.aspx Microsoft SQL] database (2008 R2 or newer). Once the SQL server engines is installed successfully, an administrator can set up a new {{UBIK}} database simple using the available release database.
[[File:UI_SettingUpUBIKDatabase_01.png|thumb|alt=Microsoft SQL Server Management Studio|Microsoft SQL Server Management Studio]]
== Setting up {{UBIK}} database ==
# Start the ''Microsoft SQL Server Management Studio'' and connect to the database server
# Navigate to ''Databases'' and add a new database
# Choose ''Tasks → Restore → Database'' from the context menu
## Choose the newly created database in the setting ''In database''
## Choose the copied backup file in ''From media''
## Check ''Restore'' of the according backup set
# Switch to the options-slider and check ''Overwriting actual data'' (if necessary)
# Finish the process by clicking {{key press|OK}}
{{Attention|Use maintenance plans for periodic backup of your own and the system databases!}}
== Requirements ==
=== Database user ===
The database user configured in {{UBIK}} Studio used to connect to the database needs
* to have the role ''sys.admin'' assigned
* to be marked as ''Database owner'' (dbo) of the according {{UBIK}} database
=== Windows firewall ===
For a non-local SQL server make sure that the SQL server port (default: 1433) is unlocked by the Windows firewall Inbound and Exbound rules.
