Difference between revisions of "HowTo:Install UBIK Database"
| Line 1: | Line 1: | ||
| − | All content and configuration data of {{UBIK}} is managed in a [http://www.microsoft.com/ | + | 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]] | [[File:UI_SettingUpUBIKDatabase_01.png|thumb|alt=Microsoft SQL Server Management Studio|Microsoft SQL Server Management Studio]] | ||
| Line 12: | Line 12: | ||
# Finish the process by clicking {{key press|OK}} | # Finish the process by clicking {{key press|OK}} | ||
| − | {{ | + | {{Attention|Use maintenance plans for periodic backup of your own and the system databases!}} |
== Requirements == | == Requirements == | ||
Revision as of 07:32, 16 October 2013
All content and configuration data of UBIK® is managed in a 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.
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 OK
 | 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.
