Install SQL 2017 CU4 non-English locale without internet access(離線安裝SQL 2017 CU4)

Install SQL 2017 CU4 without internet access (離線安裝SQL 2017 CU4)


週日接到微軟一位Machine Learning專家James Chang訊息,詢問如何離線安裝SQL 2017 CU4

了解狀況後,原來是SQL 2017 CU4在安裝過程中,需要下載Machine Learning(R Server and Python Server)相關cab檔,因為沒有網際網路,所以一直無法成功。

Error log出現要下載下列幾個檔案:
SRO_3.3.3.300_1028.cab
SRS_9.2.0.400_1028.cab
SPS_9.2.0.400_1028.cab
SPO_9.2.0.24_1028.cab

經過來回確認與research,最後的解決方法是

1.download Cab file

透過這篇官方文件,下載需要的cab檔

Installing machine learning components without internet access

2.rename cab file

由於這些cab檔案名稱是1033(English語言環境),如果SQL Server是繁體中文版,在CU4的安裝過程中指定這些cab檔案的所在目錄會無法辨識,需手動將cab檔案名稱更名,將1033改為1028

3.provide the location of the correct version of the CAB files

然後在CU4的安裝過程中指定這些cab檔案的所在目錄,這樣才能順利安裝成功。

 

Refenece:

Installing machine learning components without internet access Do it right! Deploying SQL Server R Services on computers without Internet access SQL Server 2016: patching CU with R Services