Jump to: navigation, search

Difference between revisions of "HowTo:Install UBIK Database"


 
(7 intermediate revisions by one other user not shown)
Line 4: Line 4:
 
== Setting up {{UBIK}} database ==
 
== Setting up {{UBIK}} database ==
 
# Start the ''Microsoft SQL Server Management Studio'' and connect to the database server
 
# Start the ''Microsoft SQL Server Management Studio'' and connect to the database server
# Navigate to ''Databases'' and add a new database
+
# Navigate to ''Databases'' and right click on ''Databases''→ select ''New database...''
# Choose ''Tasks → Restore → Database'' from the context menu
+
# 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 newly created database in the setting ''In database''
 
## Choose the copied backup file in ''From media''
 
## Choose the copied backup file in ''From media''
## Check ''Restore'' of the according backup set
+
## 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)
 
# Switch to the options-slider and check ''Overwriting actual data'' (if necessary)
 
# 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!}}
 
{{Attention|Use maintenance plans for periodic backup of your own and the system databases!}}
Line 23: Line 24:
 
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.
 
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.
  
[[Category:How-To]]
+
== See also ==
[[Category:Installing]]
+
* [[FAQ:Installation_and_Configuration#Network|FAQ: Installation and Configuration / Network]]
 +
 
 +
[[Category:How-To|Install UBIK Database]]
 +
[[Category:Installing|Install UBIK Database]]

Latest revision as of 08:52, 9 January 2020

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.

Microsoft SQL Server Management Studio
Microsoft SQL Server Management Studio

Setting up UBIK® database

  1. Start the Microsoft SQL Server Management Studio and connect to the database server
  2. Navigate to Databases and right click on Databases→ select New database...
  3. Right click on the newly created database and choose Tasks → Restore → Database from the context menu
    1. Choose the newly created database in the setting In database
    2. Choose the copied backup file in From media
    3. Check Restore of the according backup set
      Restore Database.PNG
  4. Switch to the options-slider and check Overwriting actual data (if necessary)
  5. Finish the process by clicking OK


IC Attention.pngUse 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.

See also