|
Frequent Asked Question - Port Klang*Net Smart Client
|
How To Attach PKNet Database To Existing SQL Server
Objective:
- This guide will show on how to attach PKNet database for company who is already have SQL Server on their Server @ Main PC
- Suitable for company who want to use LAN Version of PKNet System ( all clients will use 1 database only so all clients can view same jobs, responses, etc regardless who key in the data)
Please follow below steps :
1. Download the Installer
- Login to Port Klang*Net Web (http://www.my1port.com) using admin account
- Click on Menu –> Maintenance –> License & Installer –> Software Installer –> Click PKNet FA Installer (for FA) to download
- Once downloaded, Run the Installer (1_PKNet_FA_Installer.exe)
- Once the Installation complete, you can see PKNet databases will be created under this folder C:\Program Files\Rank Alpha Technologies\Database
![PKNetWin_AttachDatabase_1](/KnowledgeBased/Images/Smart_Client/PKNetWin_AttachDatabase_1.png)
- Please remember the database path, as it will be use on next steps
2. Attach PKNet Database
- Open SQL Management Studio and connect to your SQL Server
- Right click on Database and click Attach
![PKNetWin_AttachDatabase_2](/KnowledgeBased/Images/Smart_Client/PKNetWin_AttachDatabase_2.png)
- New window will popup, click Add
![PKNetWin_AttachDatabase_3](/KnowledgeBased/Images/Smart_Client/PKNetWin_AttachDatabase_3.png)
- Search the database under C:\Program Files\Rank Alpha Technologies\Database, select PKNet_FADB.mdf and click OK
![PKNetWin_AttachDatabase_4](/KnowledgeBased/Images/Smart_Client/PKNetWin_AttachDatabase_4.png)
![PKNetWin_AttachDatabase_5](/KnowledgeBased/Images/Smart_Client/PKNetWin_AttachDatabase_5.png)
- Click Add again, and this time select CELC_TC_PKNet.mdf and click OK
- You can now see those 2 database are ready to be attach
![PKNetWin_AttachDatabase_6](/KnowledgeBased/Images/Smart_Client/PKNetWin_AttachDatabase_6.png)
- Click OK to start attach the database
![PKNetWin_AttachDatabase_7](/KnowledgeBased/Images/Smart_Client/PKNetWin_AttachDatabase_7.png)
- When the process completed, you can see those 2 database already listed under your SQL Databases and your PKNet database has been attach successfully
3. Setup Configuration Files on Client PC
- This step is to make sure your client can connect to your PKNet database
- On client PC, run again the Installer you downloaded from My1Port (1_PKNet_FA_Installer.exe)
- Once done, you can see this PKNet FA shortcut created on your desktop
- Right click the shortcut and click Open File Location, it will open new window
![PKNetWin_AttachDatabase_8](/KnowledgeBased/Images/Smart_Client/PKNetWin_AttachDatabase_8.png)
- Or you can simply browse to C:\Program Files\Rank Alpha Technologies\PKNet FA
![PKNetWin_AttachDatabase_9](/KnowledgeBased/Images/Smart_Client/PKNetWin_AttachDatabase_9.png)
- Find a file name RankAlpha.PKNet_FAgent.MainCenter.exe and double click to open/edit it (make sure the file type is CONFIG File)
![PKNetWin_AttachDatabase_10](/KnowledgeBased/Images/Smart_Client/PKNetWin_AttachDatabase_10.png)
- Change the SqlServer / UserID / Password value following your SQL Server Name & Credentials (refer to above picture)
- Once done, you can double click on the PKNet Icon on your desktop and it can be open successfully now
- For enquiries, kindly call Rank Alpha Technologies office – 03-80738488