MS SQL Server - Knowledge Base

Skip to content

Knowledge Base
Back To Webstation

Wordpress

27

Reset User Account Password

Wordpress Posts

Manage News Categories
Manage News Entries
Add Featured Image to your News Entry
Add Photo into News Content
Add Video into News Content
Add Table into News Content
Add Button, External Link or File Download Link
Postdating or Scheduling a News for another time
How to Save and Publish News to your site

Plugins

User Activity Log

Check User Activity Log

Simple Job Board

Manage Job Categories
Manage Job Entries
Manage Job Type
Manage Job Location
Manage Job Custom Specification
Manage Job Application
Add Company Logo to your Job Entry
Add Photo into Job Content
Add Video into Job Content
Add Table into Job Content
Add Button, External link or File Download Link
Postdating or Scheduling a Job for another time
How to Save and Publish Job to your site
Manage Application Form Fields
Manage File Upload Extensions

PublishPress Future

Enable Post Expiration To A Page or Post

Website

3

WordPress

How to install WordPress via WordPress Hosting

Webstation Fileserver

How to Access and Download File from FileServer

IIS

Using Microsoft IIS to generate CSR and Private Key

Warranty & Service

20

DELL
AVITA
AOC
Philips
Lenovo
Brother
HP
Acer
D-Link
TP-Link
Samsung
Neuropower
Cooler Master
Logitech
Asus
Hikvision
Ezviz
VAIO
EPSON
APC

Software

78

Windows

How to set apps to always run as an administrator on Windows 10
Windows File Sharing Basics
Change Reset Account Lockout Counter for Local Accounts in Windows
How To Use Windows Search Service
How to Change User Account Control Settings on Windows 10
Windows Update Blocker
Fix Print Spooler
Adjust Receipt Printer Margins on Windows PC
Printer sharing problem after windows Update?
How to do a PING TEST on a Windows 10 PC
Finding the IP Address
How to Find Your Computer Name (PCNAME)
Fix Network Printer Error 0x0000011b on Windows 11/10
Remote Desktop Network Printer Redirection (Redirected Printer)
How to Restore Previous Versions of Files and Folders in Windows 11/10?
How to Clear Windows Credential Manager Stored Passwords
Change Power Plan in Windows 11
Check Your Network Connection Status
Install the .NET Framework 3.5 on Windows 11, Windows 10, Windows 8.1, and Windows 8
How To Solve Mouse Scroll Issue
How to adjust ClearType for better looking fonts on Windows 10
How to Enable AHCI Mode in Windows 10
How to Run Program as Administrator

Web Browser

How to Clear the Cache and Cookies in Your Web Browser

UBS Accounting

UBS Accounting 0x8002000e Error

SQL Account

Step by Step : SQL Account or Payroll – Network Setting
SQL Account System Requirements

RustDesk

How To Install RustDesk From Ipohserver.com

Printer

DPI and YOU – Understanding Resolution for Print and Web

Payroll

PCB, EPF, SOCSO, EIS and Income Tax Calculator 2021

Network IP Scanner

Angry IP Scanner Fast and Friendly Network Scanner

MS SQL Server

SQL Server Move Database Files Step By Step
SQL Server Configuration Manager Error 0x80041010
C2 Audit Tracing Has Brought Down The Instance

Million Business Software

Payroll

Million Payroll RELEASE NOTE (JAN 2022)
How To Send System Email Using Gmail Account

Microsoft Outlook

Outlook Junk E-mail Protection Level Changes Unexpectedly to Low
Managing Junk Mail in Outlook 2019: Microsoft Outlook Tutorial

Microsoft Office 365

How to Install Microsoft 365 for Home

LibreOffice

LibreOffice 7.3 New Features, Comparison and Download

Hikvision

Hikvision Google Chrome Plugin Compatibility Issue (solved)
Hikvision “Please click here to download and install the plugin-in” solved

SADP

SADP

FingerTec

Ingress Installation and Configuration
10 Common Mistakes Users Make During Ingress Setup
Ingress – Adding Devices & Activate Device
Troubleshooting on Ingress DB Installer for Ingress Software (mySQL database)
How To Create New User Using FingerTec Face ID 5
FingerTec Ingress Tutorial
How To Manage Inactive Users in Ingress Software

EPSON

Epson Printers – How to Align the Print Head

BANDICAM

How to Record Your Computer Screen

AVAST

Whitelist & Excluding Certain Files or Websites From Scanning in Avast Antivirus
What features are included in the different versions of Avast Antivirus?
Webcam Shield – Getting Started

AutoCount Accounting

How to Setup AutoCount Backup
Backup Option
How to Setup Scheduled Auto Backup
How to Attach Account Book in AutoCount?
Receipt Printer Not Working In Autocount
Manage Fiscal Year
Troubleshooting Error when register Database Server to USB Key Server -TCP channel protocol violation
Accounting 2.0 – Login Issue: Login Error – The underlying connection was closed: The connection was closed unexpectedly
Controlled by USB Key
Pos3 / Pos5 / FNB: How to change auto synchronization time interval?
AutoCount Tips: File is not a valid archive. I/O error occur – WinRAR
AutoCount Import Template Download and Guidelines
Import By Excel Template – AutoCount
AutoCount Batch Mail Configuration
Clear Cache and Criteria Data
Change Regional Format to English (Malaysia)

FnB

AutoCount : How To Turn Off Auto Print Order Slip When Confirm Order

AutoCount UniCart Plugin

Common Error – Failed to Enable Constraints

AutoCount POS

Column Modifier not belong to PosDtl Error Message
POS Posting transaction is missing
POS Posting backup in frontend

Anydesk

How To Install Anydesk From Download.webstation.my

Adobe Reader

Troubleshooting Adobe Acrobat Reader DC Problem: Unable open multiple PDF from network share

Payment Methods

1

How to transfer money from Payoneer to bank account

Network

1

Difference between Network and Internet

Marketplace

7

Shopee Seller

Shopee Change Bank Accounts

Lazada Seller

Lazada Account Statements
Lazada Order Overview
Lazada Transaction Overview
Lazada Change Bank Accounts

Lazada Malaysia

Lazada Malaysia Cancel Order Refund
Lazada Malaysia Return and Refund Process

Internet

3

Malaysia VLAN Setting at Router – Fiber

Internet Setting

How to configure VLAN ID for your internet connection on Router

TM Unifi VLAN Setting at Router
Maxis Fibre VLAN Setting at Router

Hardware

43

Wi-Fi

Change WiFi Roaming Sensitivity to improve wireless reception & performance

Universal Serial Bus (USB)

What are the differences between USB1.0/2.0/3.0/3.1/3.2?

TSC

TSC TE200 / TE300 Desktop Printer: Loading the ribbon
TSC Barcode Printer – TTP 244 Pro : How To Calibration, Self Test & Reset Printer?

TP-Link

How to create an account in Tapo app
Tapo C310 Setup Video
How to Manage VIGI Cameras and NVRs via VIGI App

TOTOLINK

Setup TOTOLINK EX200 – Keep SSID & Password

TimeTec & FingerTec

Introduction to TimeTec AWDMS
AWDMS Specs You Need to Know
AWDMS / Ingress Quick Installation Guide – FingerTec Face ID 5 Series

Tally DASCOM

Tally DASCOM Printer Setup 2.0

How to Set Paper Size for Half Letter Page

Standard RAID Levels

RAID 0 vs RAID 1

SD Card

How to Test Memory Card Real Capacity

Router

TP Link Archer AX Series Unboxing and Setup

Ricoh

Ricoh Printer Counter Check

Printer

Troubleshooting Printer

Troubleshooting offline printer problems

Epson

Epson L220 Printer Head Cleaning Solution
Epson LQ 300 & LX 300+II Printer’s Default Settings and Change Configuration (Auto Tear-Off Mode)
LQ 310 Using EPSON Status Monitor 3

Network Crimping Color Code

Ethernet Cables – RJ45/Colors & Crossover
Ethernet Cables – RJ45 Pinout T-568B

LCD Monitor

Refresh Rate Recommended For LCD Monitor

IP CCTV Camera

Tp-Link Tapo C310

How to Connect Tapo Camera to a NAS
Tapo Smart Camera Unboxing and Setup Video
How to Install microSD Card and Reset Your Camera

HP

HP Laserjet Pro MFP m130fw Wireless Setup
HP printer setup (HP Smart app)

Laptop Battery

How to Fix a Laptop That Won’t Charge

HIKVISION CCTV

How to reset Hikvision password
Disable No HDD Exception in Hikvision DVR / NVR
Setup Motion / Event Alarm notification on Hikvision DVR / NVR and Push alarm to hik-connect mobile App
How To Change 4MP To 5MP Resolution For Hikvision TVI Cameras If This Is 5MP Camera @ HUHI

Hikvision

Hikvision “No Resource” Error
What is the difference between the main stream and the sub stream?

Graphics Device

PEG vs IGD, which one to use?

Fiber Optic Cable

APC vs UPC: What’s the Difference?

EZVIZ

How to Setup and Install EZVIZ BC1 Battery Camera Kit
How to Subscribe to EZVIZ CloudPlay
EZVIZ Camera Advanced Settings

CPU

CPUs: Core Count vs. Clock Speed, Which Is Better?

Apple Mac

How to Reset a Mac: Factory reset a MacBook Air or MacBook Pro
Check and Change Your Privacy And Security Settings on Your Mac

FingerTec

27

HOW TO REBOOT FACE ID 5 SERIES DEVICE WITHOUT ON OFF POWER

Ingress Software

Ingress Installation and Configuration
10 Common Mistakes Users Make During Ingress Setup
Ingress – Adding Devices & Activate Device
Troubleshooting on Ingress DB Installer for Ingress Software (mySQL database)
FingerTec Ingress Tutorial
How To Manage Inactive Users in Ingress Software
Introduction to Ingress
10 Useful Features of Ingress
FingerTec Ingress – Setup
FingerTec Ingress – Startup
Ingress – Access Level
Ingress – Adding Department
Ingress – Adding Devices
Ingress – Adding Doors
Ingress – Assigning Users
Ingress – Fingerprint Enrolment by OFIS Scanner
Ingress – Monitoring
Ingress – System Settings
Ingress – Advanced Access Control System (User Guide)
How To Connect Gmail SMTP In Ingress
TCMS V3/Ingress – How To Utilize Gmail In Report Scheduler Settings

Hardware

How To Create New User Using FingerTec Face ID 5
How To Set Idle Time To Sleep Using Face ID 5

AWDMS

AWDMS Specs You Need to Know
AWDMS / Ingress Quick Installation Guide – FingerTec Face ID 5 Series
Introduction to FingerTec AWDMS

Email

12

WebStation Email Server Setting & Configuration

Office 365

How to Whitelist Training Emails in Microsoft 365
How to Whitelist by IP Address in Exchange 2013, 2016, or Microsoft 365
How to Change Junk Email Options in Outlook – Office 365

Microsoft Outlook

How to setup an IMAP email account in Microsoft Outlook 2016

Gmail Settings

Fetch emails using Gmail
Gmail SMTP Settings and Gmail Setup
Read Gmail Messages On Other Email Clients Using POP
Check Gmail Through Other Email Platforms – IMAP
What to Do if Outlook Cannot Connect to Gmail Account?
Less secure apps & your Google Account

EXABYTES

Simple Guide To SET UP Emails with POP3 & SMTP

E-Commerce

146

Sitegiant Multichat Add User Login
SiteGiant ERP

SiteGiant Lite

SiteGiant Lite Training
Sitegiant Multichat Add User Login

WhatsApp

How to Boost Your Sales with WhatsApp Commerce

Webstore

How to Set Website Theme Color
How to Add Favicon and Logo for Webstore
How to Add Slideshow Image
How to Add Featured Products
How to Add Social Media Icons in Website
How to Add Product Reviews and Ratings in your website
How to Apply Product Label on your Webstore’s Product
How to Manage Your Webstore Layout
How to Add Photo Collages with PhotoGrid
How to Create Content Editor
How to Manage Navigation Menu
How to Create Pages

Unicart

How to Integrate Unicart Store
How to Create New Unicart Listing (without variant)
How to Create New Unicart Listing (with variant)
Sitegiant Multichat Add User Login

Telegram

How to Set Up Telegram Order Forms

Shopify

How to Integrate Shopify Store with Shopify Sync
How to Retrieve Shopify Admin API Password
How to Create New Shopify Listing (without variant)
How to Create New Shopify Listing (with variant)

Settings

How to Edit Warehouse and Rack Information
How to Add Staff and Assign Permission
How to Add a Sales Channel
How to Manage Sales Channels Setting
How to Add-on More Sales Channels
How to Set Shipping Method Based on Weight
How to Set Shipping Method Based on Item Quantity
How to Set Flat Rate Per Order Shipping Method
How to Customize Notification Email Templates
How to Edit your Store Information
How to Change Invoice Prefix
How to Set your Store to Maintenance Mode
How to install SiteGiant MultiChat
How to Set up Channels in SiteGiant MultiChat
How to Assign Staff to Manage MultiChat
How to Set Up Cash On Delivery Payment Method
How to Set Up Bank Transfer Payment Method
How to Add Paypal Payment Gateway
How to Customize the Checkout Process
How to Add iPay88 Payment Gateway
How to Add eGHL Payment Gateway
How to Add Razer Payment Gateway

Products

How to Create New Webstore Listing (without variant)
How to Create New Webstore Listing (with variant)
How to Sync Back Products from Shopee
How to Add New Product & Publish to Shopee (without variant)
How to Add New Product & Publish to Shopee (with variant)
How to Edit and Publish My Existing Shopee Listing
How to Sync Back Products from Lazada
How to Add New Product & Publish to Lazada
How to Edit and Publish My Existing Lazada Listing
How to Bulk Edit Lazada Listing
How to Integrate with Zalora MY
How to Create New Zalora Product
How to Bulk Edit Shopee Listing

Orders

How to Print Shopee Shipping Label
How to Print Lazada Shipping Label
How to Move Old Orders into Printed Tab
How to Generate Invoice Number
How to use Carrier Manifest
How to use Order Fulfillment Assistant for Lazada and Shopee Orders
How to use Order Fulfillment Log
How to Manually Fulfill Orders and Update Tracking Number
How to Cancel Order
How to Send Payment Reminder to Customer
How to Create Order Manually
How the Order Status, Remark & Fulfillment Status Works
How to Remind Customer who has Abandoned Checkout
How to Process Order with Express Fulfillment
How to Configure Shopee & Lazada Shipping Label Settings
How to Insert Serial Number and Print out in Invoice
How to Print PosLaju SendParcel Shipping Label
How to Print GDEX Shipping Label
How to Print Shopee & Lazada Shipping Label

My Apps

How to Keep Track of Marketplace Competitor’s Products
How to use the Barcode Label
How to Sync with SQL Accounting
How to Restock for Marketplace Return Order
How to Set Up E-Invoice
How to Add Login with Google

Marketplaces

How to Use Bulk Copy Listing
How to Boost Your Shopee Products Automatically
How to Use Shopee & Lazada Payment Reconciliation
How to Use the Bulk Inventory Linking Tool
How to Use Shopee Product Watermark
How to Use Lazada Product Watermark
How to Change Shopee Shipping Label Sender Information for Dropship
How to Check the Gross Profit for Marketplace Order
How to Scrape Product Listing from the Marketplace
How to Link Marketplace Product with Existing Inventory Item
How to Manage Item Linking in Bulk Inventory Linking
How to Download Watermark Template
How to Remove Shopee and Lazada Product Watermark
How to Replace the Watermark Origin Image

Inventory

How to Manage Your Inventory Stock
How to Bulk Update Item Stock Quantity
How to Set Parent SKU (Item Group) for Inventory
How to Stock In for your Inventory
How to Stock Out your Inventory
How to Use Inventory Forecasting
How to Create Inventory Item
How to Create a New Kit
How to Add Inventory Item from Product Listing
How to Create Purchase Order
How to Bulk Update Inventory Stock with Item Group
How to Manage Marketplace Price with Item Group
How the Inventory Item Stock Details Works
How to Update Inventory with Shopee Campaign Reserved Stock
How to Manage Warehouse
How to Manage Rack & Rack Group
How to Assign Item With Rack
How to Bulk Update Rack
How to Bulk Assign Item to Rack with Excel
How to Perform Stock Adjustment with Excel

Facebook

How to Set Up Facebook Business Extension Version 2.0
How to Manage Your Facebook Page Shop
How to Manage Facebook Messenger Chat
How to Manage Business Account, Facebook Pixel & Facebook Ads
How to Uninstall Facebook Business Extension
How to Add Login with Facebook

Customers

How to Add and Manage Customer Account
How to Manage Customer Groups

Customer Service

How to install SiteGiant MultiChat
How to Set up Channels in SiteGiant MultiChat
How to Assign Staff to Manage MultiChat
How to Set Up Shopee Chat Auto-Reply

Analytics

How to analyze the Marketplace Channel Report
How to analyze the Order Report
How to analyze the Inventory Performance Report
How to analyze the Inventory Purchased Report
How to analyze the Dead Stock Report

SiteGiant ERP

SiteGiant ERP
Sitegiant ERP Change Sale Channel Name

SiteGiant

SQL Accounting Sync
Sitegiant Unicart Facebook Live Function
How to Install Google Analytics
How to Embed Google Map for Store Location
How to Setup SEO for Your UniCart Store
E-Commerce SEO Tips
How to Make Customers Register Quickly with Google Login

Courier

1

Ninjavan Registration Form (Open Account)

Apple

1

IPHONE

How do I configure the iPhone for my email accounts?

Home
Webstation
Software
MS SQL Server

MS SQL Server

SQL Server Move Database Files Step By Step
SQL Server Configuration Manager Error 0x80041010
C2 Audit Tracing Has Brought Down The Instance

WordPress Theme: Chronus by ThemeZee.