Other Technical Tips

QLS related_Optimum

Database 'XXX' on server 'qned3' is not currently available
Scenario  Login to QNE Cloud (qned3) database via QNE Optimum prompted  “Database 'XXX' on server 'qned3' is not currently available...
Fri, 1 Oct, 2021 at 2:10 PM
Get license from server failed. Status Code: 0 in QLS Agent
Scenario  Perform “Transfer License in from Cloud” encountered error “Get licenses from server failed. Status Code: 0”.   This error will occur when QL...
Tue, 12 Oct, 2021 at 11:35 AM
The Index 'XXX' is dependent on column 'XXX' when upgrade database in Optimum
Scenario  When upgrade database in QNE Optimum prompted “The index ‘XXX’ is dependent on column ‘Debit’. ALTER TABLE ALTER COLUMN Debit failed because on...
Tue, 12 Oct, 2021 at 1:27 PM
Clone button missing
Scenario  Clone button in Transaction missing after upgrade database   Solution  1. Go to File > Modules 2. Click “Apply Changes” > Click...
Wed, 15 Dec, 2021 at 1:13 PM
YEAR END PROCESSING / PURGING IN OPTIMUM
Scenario    When there are too many data in the database after few years. Some of the user would request for database purging in order to remove previou...
Fri, 25 Feb, 2022 at 12:06 PM
Start QLS Agent prompted Time out has expired and the operation has not been completed
Scenario  Start QLS Agent prompted “Time out has expired and the operation has not been completed”   Solution  Method 1: Update QLS Agent to late...
Mon, 30 May, 2022 at 6:30 PM
Unable to launch SQL Server Configuration Manager – Invalid class [0x80041010]
Scenario If double click to Execute SQL Server Configuration Manager Error Occurs as below: Solution: C:\WINDOWS\system32>mofcomp "C:...
Mon, 13 Jun, 2022 at 4:39 PM
Failed to Start SQL Services due to Error Code
Scenario When try to Start SQL Server but it failed due to Error Code 3411 Verify To verify Press Start > Search for Event Viewer Inside Ev...
Tue, 14 Jun, 2022 at 9:43 AM
Minimum Requirement use SQL Server in Windows 11
Unable to install SQL Server on Windows 11 the resource of article/KB are provided by Microsoft. For Windows 11 and Windows Server 2022 F...
Tue, 14 Jun, 2022 at 3:19 PM
Determine database version from a bak file
Scenario: Have you ever imagine you can determine the version of SQL Server from a bak or a MDF file? I have been in situations where I received a bak or MD...
Mon, 4 Jul, 2022 at 3:17 PM