Difference between revisions of "HowTo:Install UBIK Database"
(→See also) |
(→See also) |
||
| Line 18: | Line 18: | ||
* Database user has to be dbo of {{UBIK}} database | * Database user has to be dbo of {{UBIK}} database | ||
* If Windows firewall is active, the SQL server port 1433 must be unlocked | * If Windows firewall is active, the SQL server port 1433 must be unlocked | ||
| − | |||
| − | |||
| − | |||
[[Category:UBIK Studio]] | [[Category:UBIK Studio]] | ||
[[Category:Installing]] | [[Category:Installing]] | ||
Revision as of 13:32, 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
- 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 the OK
 | Use maintenance plans for periodic backup of your own and the system databases! |
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
