All content and configuration data of {{UBIK}} is managed in a [http://www.microsoft.com/deen-deus/serversqlserver/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 right click on ''Databases''→ select ''New database...''# Choose Right click on the newly created database and 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<br/> [[File:Restore Database.PNG| 440px|border]]
# Switch to the options-slider and check ''Overwriting actual data'' (if necessary)
# Finish the process by clicking the {{key press|OK}}
{{HintAttention|'''Use maintenance plans for periodic backup of your own and the system databases!'''}}
== Requirements ==
=== Database user ===
The database user configured for connecting 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 ===
Make For a non-local SQL server make sure that the SQL server port, (default : 1433, ) is unlocked on by the Windows firewallInbound and Exbound rules. == See also ==* [[FAQ:Installation_and_Configuration#Network|FAQ: Installation and Configuration / Network]]
[[Category:How-To|Install UBIK Database]][[Category:Installing|Install UBIK Database]]