SQL management tool連線時出現錯誤:此憑證鏈結是由不受信任的授權單位發出的

 

環境:

MS SQL2022

異常狀況:

SQL management tool連線時出現錯誤:此憑證鏈結是由不受信任的授權單位發出的

解決過程:

錯誤訊息「此憑證鏈結是由不受信任的授權單位發出的」是因為 SQL Server 2022 預設強制執行加密連線。

勾選下午的「信任伺服器憑證」選項，即可正常登入。

Environment:

MS SQL Server 2022

Issue:

When connecting using the SQL management tool, the following error appears:

“The certificate chain was issued by an authority that is not trusted.”

Resolution:

This error occurs because SQL Server 2022 enforces encrypted connections by default.

Enable the “Trust Server Certificate” option in the connection settings, and then you will be able to log in normally.

SQL 2022安裝時卡住不動

環境:

MS SQL2022

Kaspersky endpoint security

異常狀況:

MS SQL2022安裝到一半停住很久，cpu跟ram的使用資源都不會動。

解決過程:

將Kaspersky endpoint security防護暫停後，就會繼續安裝過程，完成剛裝

Environment:

MS SQL Server 2022
Kaspersky Endpoint Security

Issue:

During the installation of MS SQL Server 2022, the setup process gets stuck for a long time.
CPU and RAM usage remain unchanged and the installation does not continue.

Resolution:

After temporarily disabling Kaspersky Endpoint Security protection, the installation process resumes and completes successfully.

Synology 取消 "此裝置以後不需要驗證"

 環境:

Synology  NAS啟用 2FA的"此裝置以後不需要驗證"，需要取消

解決過程:

管理者登入後，到使用者設定中，在該帳號底下，選擇"登出所有裝置"，就會跳出說明，提醒這樣也會取消信任裝置。

之後同設備要登入時，就要輸入2FA的驗證碼。

Environment:

On a Synology NAS, 2FA is enabled and the option “Trust this device / Do not require verification on this device in the future” needs to be revoked.

Resolution / Steps:

1. Log in as an administrator.

2. Go to User settings.

3. Under the target user account, select “Sign out of all devices”.

4. A prompt will appear explaining that this action will also revoke trusted devices.

After this, when the same device logs in again, it will be required to enter the 2FA verification code.

Backup exec 的資料庫備份

  環境:

Backup exec 2014

異常狀況:

想要透過Backup exec 本身的工具beutility.exe，把Backup exec 自己的設定db檔匯出到其他存放。

但執行beutility.exe指令時，都會先跳出一個警告視窗，因為無法設定用batch自動執行。

解決過程:

Backup exec 的主程式裡就有可以設定db檔定期匯出到預設資料夾的功能了，不需要額外用beutility.exe來執行。

在"組態與設定"->"Backup Exec設定"，裡面有一個"資料庫維護"，就可以設定排程來做這件事。

Environment:

Backup Exec 2014

Issue:

Attempting to use Backup Exec’s built-in tool beutility.exe to export the Backup Exec configuration database to another storage location.
However, when running beutility.exe, a warning dialog always appears, making it impossible to automate the process using a batch script.

Resolution / Workaround:

Backup Exec already provides a built-in feature to periodically export the database to a default folder, so there is no need to use beutility.exe.

In Configuration and Settings → Backup Exec Settings, there is a Database Maintenance option where you can configure a scheduled task to perform this database export automatically.

python抓取元大rtd裡的欄位即時資料範例

 import xlwings as xw

import time

# 連接當前開啟的 Excel 檔案

wb = xw.Book('txf.xlsm')

sheet = wb.sheets['價格記錄']

while True:

    # 假設元大 RTD 資料在 A1 儲存格

    price = sheet.range('A2').value

    print(f"當前即時價格: {price}")

    # 根據需求設定取樣頻率 (例如每秒 1 秒)

    time.sleep(1)

Windows 資料夾透過FASTCOPY同步到NAS共用資料夾 權限並沒有同步

 環境:

Windows 資料夾透過FASTCOPY，同步到NAS共用資料夾

異常狀況:

資料夾開始建立進行同步時，發現權限並沒有同步過去

解決過程:

研究了很久，發現測試的資料夾正常，正式要同步的資料夾會有問題。

原來是資料夾第一次在同步時，還沒全部完成前去查看資料夾權限時，不會是最後的結果，所以要等同步完再檢查，就會發現資料夾的ACL權限有全部同步過去了。

Environment:

Windows folders synchronized to a NAS shared folder using FastCopy.

Issue:

When the folder creation and synchronization start, the folder permissions (ACLs) do not appear to be synchronized to the NAS.

Resolution / Findings:

After extensive investigation, it was found that test folders behaved normally, while the production folders showed this issue.

The root cause is that during the initial synchronization, if you check the folder permissions before the sync process has fully completed, the permissions shown are not the final result.
Once the synchronization finishes completely and you recheck the folder permissions, you will see that the ACL permissions have been fully and correctly synchronized.

Unifi Controller 與 AP 設定

 環境:

Unifi  軟體式Controller，安裝在windows主機。

搭配 U6 無線AP 。

設定過程:

1.先下載windows版的controller程式"UniFi Network Application 10.0.160 for Windows"

https://ui.com/download/releases/network-server 

2.安裝在windows主機上後，一開始會叫你登入unifi官網的帳號密碼，可以跳過，直接設定一組在這個controller上單獨登入的帳密就好。

3.在Setting功能中，去設定WIFI的SSID跟密碼。

4.AP直接接上網路，讓它自動透過DHCP抓到IP，要先跟controller同網段才行。

5.回到controller的畫面，在Unifi Device的頁籤裡，就會自動去找到網路環境中的AP，畫面上會顯示Adope的選項。

6.Adope之後，AP就可以加入這個controller的管控，之後AP就可以改成其他網段的IP。

筆電安裝win10/11 找不到ssd硬碟

環境:

ASUS or ACER筆電

異常狀況:

重灌win10 or win11系統時，在選擇要安裝在哪個磁區，不會顯示ssd硬碟的磁區。

解決過程:

1.下載irst這個驅動程式，asus網站上有提供。

https://www.asus.com/tw/supportonly/irst/helpdesk_download/

2.將該程式放入win10 or win11的安裝usb中。

3.安裝win10 or win11系統時，在選擇要安裝在哪個磁區的步驟，選擇載入驅動程式，然後選擇irst。

4.ssd磁碟就會正常顯示出來。

Environment:

ASUS or ACER laptops

Issue:

When reinstalling Windows 10 or Windows 11, the SSD drive does not appear during the disk selection step of the installation process.

Resolution / Troubleshooting Steps:

1. Download the IRST (Intel Rapid Storage Technology) driver (available on the ASUS website).

2. Copy the driver to the Windows 10 or Windows 11 installation USB drive.

3. During the Windows installation, at the step where you choose the disk to install the OS, select Load driver, then choose the IRST driver.

4. The SSD drive will then be displayed correctly.

點選右下角的日期時間 不會跳出月曆

   環境:

WIN 11點選右下角的日期時間，不會跳出月曆

解決過程:

1.windows鍵+ r鍵 ，輸入 regedit

2.找到HKEY_CURRENT_USER\SOFTWARE\Policies\Microsoft\Windows\Explorer\

3.把DisableNotificationCenter設成 0

Environment:

On Windows 11, clicking the date and time in the bottom-right corner does not display the calendar.

Resolution :

1.Press Windows key + R, then type regedit.

2.Navigate to:

HKEY_CURRENT_USER\SOFTWARE\Policies\Microsoft\Windows\Explorer\

3.Set DisableNotificationCenter to 0.

強制移除DC主機

 環境:

網域中某台DC有狀況，已無法正常與其他DC同步提供服務，或無法在登入使用之類的狀況。

因無法以正常的方式降級DC角色(dc-a)，必須以其他方式移除該DC主機角色

解決過程:

假設五大角色並是在正常的DC主機(dc-b)中，我們就到該DC主機中做下列兩個步驟:

1. 開啟"Active Directory站台及服務" ，這邊會有每台DC，還有它跟哪些DC同步。

在裡面找到需移除的DC，都它們都刪掉，這樣正常的DC才不會去找它做同步。

2. 在DNS裡，正向對應區域裡，需移除的DC，通通移除掉(包含底下其他資料夾底下的資料)，這樣才能確認其他主機透過DNS要詢問資訊時，不會回應錯誤的資訊。