How to Initialize xPortalNet Software Database

Problem (Issue) Statement:	How to initialize xPortalNet software database
Description:	A guide to initialize xPortalNet software database.
Related Software:	/wiki/spaces/SRN/pages/97157540 SQL Server Express 20008 R2 (Version: 10.50.4000.0)
Related Hardware:	NA
System Application:	xPortalNet Standard Software
Symptom and Finding:	NA
Cause:	For first time installation of the xPortalNet software and initialize the software database.
Solution:	Warning! Users are not recommended to run any xPortal software in Windows XP* operating system as the system is unstable* Users are also advised to stop the xPortal Services before shutting down the Server PC* to prevent any missing transaction issues.* . . Knowledge Base Link Ensure that the PC to be installed meets the xPortalNet software requirements. Ensure that the software's pre-requisite installation has been completed. Users may refer to How to Install Microsoft SQL Server 2012 to complete the pre-requisite installation. Ensure that the xPortalNet software is installed. Users may refer to TIKB-000020 How to install xPortalNet software for the complete installation procedures. . . Summary To run the xPortalNet Server to initialize the database. . Step-by-step Guide: To run the xPortalNet Server to initialize the database: Step 1: To avoid any general exception handling issues during running the xPortalNet software, users are encouraged to check the xPortalNet software for any compatibility issues. Step 2: Right-click xPortalNet Comm Service Controller desktop icon > Properties. Figure 1: To Check for any Compatibility Issues Step 3: Go to Compatibility tab, check the Run this program as an administrator checkbox. Click Apply and click OK. Figure 2: The Properties Window Step 4: Run the xPortalNet Services. Figure 3: To Run the xPortalNet Service Software Step 5: The following screenshots are messages that will be shown at your taskbar: Figure 4: xPortalNet Comm Service Running Message Figure 5: xPortalNet Comm Service Database Not Initialized Yet Message . Note The Database Not Initialized Yet Message will only be shown for first time installation where the software does not detect an initialized database. . . Figure 6: USB Dongle Licese Detected Message Figure 7: USB Dongle Detection Failure . Note For dongle detection errors: Have you plugged in the dongle license to the Server PC? Have you installed the dongle license's driver? . . Step 6: Run the xPortalNet Server to initialize the database. Figure 8: To Run the xPortalNet Server Software Step 7: The following window will be shown. Users must fill up the Server Name and Password field with information from the SQL Server Management Studio. Figure 9: xPortal Comm Server Window . Note Ensure that the Server Name is the same as *SQL Server Name* and password is SQL Server password. . . Step 8: To check your SQL Server Name and password, open the SQL Server Management Studio. Figure 10: To run the SQL Server Management Studio Step 9: The following window will be shown. Copy the SQL Server Name and paste to the xPortalNet Comm Server window as shown in Step 7. Figure 11: The Connect to Server Window in SQL Server Management Studio Step 10: Next, key in the SQL Server password and click Initialize Database. Figure 12: To Initialize the Database . Knowledge Base Link The password is created during Microsoft SQL Server 2012 installation, please refer How to Install Microsoft SQL Server 2012 . . Step 11: Wait until the configuration process is finished. Figure 13: Configuring the new Database Step 12: The following window will be shown once the database has been successfully created: Figure 14: The Database Created Successfully Window Step 13: Users can now login to xPortalNet Server accordingly. Figure 15: xPortalNet Comm Server Login Window . YouTube Installation Guide - As Additional Reference To view the YouTube installation guide for xPortalNet, click here
Date Documentation:	17/7/2019