Changes

HowTo:Install UBIK Database

249 bytes added, 08:52, 9 January 2020
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<br/>[[File:UI_SettingUpUBIKDatabase_01.png|220 px|alt=Microsoft SQL Server Management Studio|Microsoft SQL Server Management Studio]]# Navigate to ''Databases'' and add a new right click on ''Databases''&rarr; select ''New database...''# Choose Right click on the newly created database and choose ''Tasks &rarr; Restore &rarr; Database'' from the context menu
## Choose the newly created database in the setting ''In database''
## Choose the copied backup file in ''From media''
## Check the ''Restore'' flagof the according backup set <br/> [[File:UI_SettingUpUBIKDatabase_01Restore Database.png|220 pxPNG|alt=Microsoft SQL Server Management Studio440px|Microsoft SQL Server Management Studioborder]]
# Switch to the options-slider and check ''Overwriting actual data'' (if necessary)
# Finish the process by clicking the {{key press|OK}}  {{Attention|Use maintenance plans for periodic backup of your own and the system databases!}}
== Requirements ==
* === Database user must ===The database user configured in {{UBIK}} Studio used to connect to the database needs* to have the role ''sys.admin'' assigned* Database user has to be marked as ''Database owner'' (dbo ) of the according {{UBIK}} database* If === Windows firewall is active, ===For a non-local SQL server make sure that the SQL server port (default: 1433 must be ) is unlockedby the Windows firewall Inbound and Exbound rules.
==See also==* [[Installation_UBIK_StudioFAQ:Installation_and_Configuration#Network|Set up {{UBIK}} Studio]]* [[Installation_UBIK_Enterprise_Service|Set up {{UBIK}} Enterprise Service]]* [[UBIK_Webservice|Set up {{UBIK}} Webservice]]* [[UBIK_Studio_Basics|{{UBIK}} Studio BasicsFAQ: Installation and Configuration / Network]]
[[Category:How-To|Install UBIK StudioDatabase]][[Category:ConfigurationInstalling|Install UBIK Database]]

Help improve this page!