i4connected Knowledgebase 5.6

Configuring the SQL Database

Abstract

The following article follows the steps required to properly set up the SQL database for using it with the i4connected portal or server.

The following article follows the steps required to properly set up the SQL database for using it with the i4connected portal and/or server.

The configuration of the database consists in restoring the SQL Database and Analysis Services database backups. Once the databases are restored, the connection must be restored between them. Other access and security settings will be made in order to ensure a proper functionality.

The SQL Database backup (.bak) and the Analysis Services Database backup (.abf) files are required in order to proceed with this guide. Because there is no default place where the Database backups are located, both Database and Analysis Services backup files should be requested from the development team.

  1. For a new setup, take the i4_Empty_V55.bak file and restore it to the database server with a speaking name, as follows:

    1. Open the SQL Server Management Studio and connect to the Database Engine server.

      Clipboard01.jpg
    2. Right-click on the Databases to open the contextual menu. Select Restore Database....

      Clipboard01.jpg
    3. In the Restore Database dialog, select Device and browse for the backup (.bak) file.

      Clipboard01.jpg
    4. In the Select backup devices dialog, make sure that the Backup media type is set to File and click Add to browse for the backup file.

      Clipboard01.jpg
    5. The Locate Backup File dialog will point you to the exact location of the backup file (copied earlier to the backup folder of the SQL Server). Select the backup file and press OK.

      Confirm the Select backup devices dialog, as well. If the dialog doesn't point directly to the backup file location, use the left-side tree structure to locate the backup file on your hard drive.

      Capture976.jpg
    6. Back in the Restore Database window, another option is needed, if the backup to be restored will overwrite an existing Database. Hence, select the Options page from the left-side menu and enable the Overwrite the existing database (WITH REPLACE) option.

      Clipboard01.jpg
    7. Click OK to start the restore process. A dialog will confirm the success of the restore operation.

  2. Next, open the i4connected Migrations folder and identify the WEBfactory.DWH.Data.Migrations.exe.config file. Open the file with an editor tool and configure the connection string to point to the local SQL.

  3. Run the migration tool to set up the initial Database, as follows:

    1. Open the Command Prompt application with Administrative rights;

    2. Run the -b webfactory -u flags for WEBfactory brand and unattended migration.