Navigation:  Installation >

Setting up the Database : Database Manager

Previous pageReturn to chapter overviewNext page

Database Manager Starts Automatically on First Run

After the installation is done, when the FusionRetail 6 is run for the first time, Database Manager window will open.

       Key Information

Database Manager starts automatically if the config file FusionRetail.exe.config is not found in the  installation folder.

 

To manually start the Database Manage, please Delete / Rename the above config file.

This will guide you through database setup process. Click “Next” to continue.

 

FusionRetail 6 Database Manager will now search for available database servers in the Network. After that  Specify appropriate field values. We recommend using default settings.

Note : In case you already have SQL Server installed, please consult your system administrator.

 

Database Server

Database Server is the name of the computer on which SQL Server is installed.

By default, installer creates a new instance of SQL Server by the name of Rancelab2008.

This instance is accessible by typing <ServerName>\Rancelab2008.

Authentication

There are two authentication modes.

SQL ServerDefault and Recommended authentication mode.

Windows – Alternate authentication mode

User Name

Specify User Name.

“sa”Default user name

User Password

Specify User Password.

blank – Default user password

 

Press next and you will see the following screen:

Use Existing Database

Use to select any existing database. This is basically used to connect the Server Database from Node / Client system.

Create New Database

Use to create a new and blank database. This is used for a new installation.

Restore

Use to restore data backup.

Attach

Use to attach the .mdf database file. This is used where latest .mdf file is available instead of latest data backup.

Create Demo Database

Use to create a new demo database.

 

The above menu shows the database processing modes. Details of each of the modes are explained next. Select the desired mode to get the following screen:

Database

Click the drop down arrow to select a database from the list.

Select Station

Click the drop down arrow to select a Station from the list.

Service Port

Type a data service port ranged between 6161 to 6262. Where 6161 is default and recommended.

 

Select the Station Carefully. For more information of station please see Station Setup

Press next and you will see the below screen:

Click on “Finish” to complete database setup process.

Restart the FusionRetail 6 after the database creation is complete.