How to Attach xPortalNet Database to SQL Server

Problem (Issue) Statement:

How to attach xPortalNet database to SQL Server

Description:

A guide to attach xPortalNet database to SQL Server.

Related Software:

  • xPortalNet v1.0.0.69
  • SQL Server Express 20008 R2 (Version: 10.50.4000.0)

Related Hardware:

NA

System Application:

xPortalNet Software

Symptom and Finding:

NA

Cause:

For first time attaching of xPortalNet database to SQL Server.

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.

.

.

Summary

  • To attach xPortalNet database to SQL Server.


Note

The process of attaching database to SQL Server is to establish a communication link between the physical database files to SQL Server records. Please make sure that the physical database folder exists in the location C: Program Data\MicroEngine\xPortalNet v1\Server\Database


Step by Step:

  • To attach xPortalNet database to SQL Server:

Step 1: To close xPortalNet Server & Client if any of the software instances are still running.


Step 2: Right-click the xPortalNet Service icon, click Stop. Wait for the pop-up message indicating that the xPortalNet Service has been stopped.
Right-click xPortalNet Service Icon and Click Stop
Figure 1: Right-click xPortalNet Service Icon and click Stop



xPortalNet Comm Service Stopped Pop-up Message
Figure 2: xPortalNet Service Stopped Pop-up Message


Step 3: Open SQL Server Management Studio on desktop.
SQL Server Management Studio Icon
Figure 3: SQL Server Management Studio Icon


Step 4: The Connect to Server window will be shown. Click Connect to continue.
Connect to Server Window from SQL Server Management Studio Software
Figure 4: Connect to Server Window


Note

  • If Authentication is done under SQL Server Authentication, please key-in the User Name and Password before clicking Connect.
  • The User Name and Password is created during Microsoft SQL Server 2012 installation. Please refer to How to Install Microsoft SQL Server 2012 for the installation step.



Step 5: Under the Object Explorer window, expand the Databases folder.
Databases Folder under the Object Explorer Window
Figure 5: Databases Folder under the Object Explorer Window


Step 6: To attach the database, right click the Databases > Attach…
Attaching Database Components
Figure 6: Attaching Database Components


Note

Users may notice that the list of database shown is different. There will not be any components shown under the Databases folder before users attach the database components.




Step 7: The Attach Database window will be shown as below. Click Add to browse the database file to be attached.
Attach Databases Window
Figure 7: Attach Databases Window


Step 8: The Locate Database File window will then be shown. Select the database to be attached, and then click OK. (E.g.: XPNDB.mdf)
Locate Database Files Window
Figure 8: Locate Database Files Window


Step 9: The following window will be shown after the database file has been selected. Click OK to start attaching the database to SQL Server.
Attach Databases Window
Figure 9: Attach Databases Window


Step 10: The window will automatically be closed after the database is successfully attached and you should notice that the XPNDB database is listed under the Databases folder.
Attached Database Components Shown under Databases Folder
Figure 10: Attached Database Components Shown under Databases Folder


Step 11: Repeat steps 6 to 10 to attach all remaining database components.


Step 12: Users may run the xPortalNet software after attaching all components of the database to verify that the existing database is shown in xPortalNet software.

Date Documentation:

30/5/2018 (Rev 1.0)

PROOF-READ

.

.


.

© MicroEngine Technology Sdn Bhd (535550-U). All rights reserved.