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/de-de/server/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. | |
| + | |||
| + | == Setting up {{UBIK}} database == | ||
[[File:UI_MSSQL.png|thumb|alt=Alt text|Connect to MS SQL Management Studio]] | [[File:UI_MSSQL.png|thumb|alt=Alt text|Connect to MS SQL Management Studio]] | ||
[[File:UI_RestoreDB.png|thumb|alt=Alt text|Restore database]] | [[File:UI_RestoreDB.png|thumb|alt=Alt text|Restore database]] | ||
| − | + | # Start the SQL Management Studio and connect to the database server | |
| − | # Start the | + | # Navigate to ''Databases'' and add a new database |
| − | # Navigate to | + | |
# Choose "Tasks / Restore / Database" from the context menu | # Choose "Tasks / Restore / Database" from the context menu | ||
## Choose the newly created database in the setting "In database" | ## Choose the newly created database in the setting "In database" | ||
Revision as of 13:18, 30 September 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
File:UI MSSQL.png
Connect to MS SQL Management Studio
File:UI RestoreDB.png
Restore database
- Start the SQL 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 the "Restore" flag
- Switch to the options-slider and check "Overwriting actual data"
- Finish the process by clicking the "OK"
Requirements
- Database user must have role sys.admin
- Database user has to be dbo of UBIK® database
- If Windows firewall is active, the SQL server port 1433 must be unlocked
