Jump to: navigation, search

Install UBIK Database


Revision as of 11:51, 20 September 2013 by KNO (Talk | contribs)

Configuration of SQL database

File:UI MSSQL.png
Connect to MS SQL Management Studio
File:UI RestoreDB.png
Restore database
  1. Copy the file UBIK.RELEASE.bak to the local drive
  2. Start the application MS SQL Management Studio and connect to the database server
  3. Navigate to "Databases" and add a new database
  4. 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 the "Restore" flag
  5. Switch to the options-slider and check "Overwriting actual data"
  6. 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

See also