{"id":1149,"date":"2019-12-24T22:52:18","date_gmt":"2019-12-24T14:52:18","guid":{"rendered":"http:\/\/www.ilovekonan.com\/?p=1149"},"modified":"2019-12-29T14:14:43","modified_gmt":"2019-12-29T06:14:43","slug":"virtual-apps-and-desktops-7-1912-ltsr%e9%9b%86%e6%88%90db%e8%bf%81%e7%a7%bb%e5%88%b0sql-server-2016-alwayson%e7%94%9f%e4%ba%a7%e7%8e%af%e5%a2%83","status":"publish","type":"post","link":"https:\/\/www.charflower.com\/?p=1149","title":{"rendered":"Virtual Apps and Desktops 7 1912 LTSR\u96c6\u6210DB\u8fc1\u79fb\u5230SQL Server 2016 AlwaysOn\u751f\u4ea7\u73af\u5883"},"content":{"rendered":"\n

\u9996\u5148\u5411\u5723\u8bde\u524d\u591c\u8fd8\u5728\u56e0CVE-2019-19781\u4e4b\u7978\u800c\u52aa\u529b\u594b\u6597\u7684Citrix NetScaler ADC\/GW\u7b49\u5404\u7ea7\u5de5\u53cb\u4eec\u81f4\u656c\uff01<\/p>\n\n\n\n

\u4e4b\u524d\u63d0\u8fc7\uff0c\u6709\u65f6\u5019\u9700\u8981\u628a\u5355DB\u8f6c\u6210\u96c6\u7fa4DB\uff0c\u8fd9\u91cc\u66f4\u6781\u7aef\uff0c\u662f\u628aExpress DB\u79fb\u690d\u5230DB\u96c6\u7fa4\uff0c\u672c\u6b21\u73af\u5883\u57fa\u4e8e\u4ee5\u4e0b\u4ecb\u8d28\uff1a<\/p>\n\n\n\n

<\/p>Citrix_Virtual_Apps_and_Desktops_7_1912.iso
cn_sql_server_2016_enterprise_with_service_pack_1_x64_dvd_9538279.iso
cn_windows_server_2019_x64_dvd_2d80e042.iso
ADDS\uff1a2012 R2<\/cite><\/blockquote>\n\n\n\n

CVAD 1912\u81ea\u5e26\u7684\u662fSQL Server 2017 Express CU16\uff0c\u5982\u679c\u4f60\u6ca1\u6709SQLServer 2017 Enterprise\u7684ISO\u6587\u4ef6\uff08\u8c8c\u4f3c\u4e0d\u592a\u597d\u627ecn_sql_server_2017_enterprise_x64_dvd_11293608.iso\uff09\uff0c\u8fd9\u91cc\u4ee5\u4f4e\u7248\u672cSQL2016\u4e3a\u4f8b\uff0cSQL 2019\u5012\u662f\u5f88\u6d41\u884c(cn_sql_server_2019_enterprise_x64_dvd_2bfe815a.iso)\u3002<\/p>\n\n\n\n

SQL\u9ad8\u7248\u672c\u8fd8\u539f\u5230\u4f4e\u7248\u672c\u4e0d\u53ef\u76f4\u63a5\u7528\u4f20\u7edf\u5907\u4efd\/\u8fd8\u539f\u65b9\u5f0f\uff0c\u4f1a\u62a5\u7248\u672c\u4e0d\u5339\u914d\u9519\u8bef\u3002\u53ef\u4ee5\u901a\u8fc7\u6267\u884c\u751f\u6210\u7684SQL\u6587\u4ef6\u6765\u5b8c\u6210\u6570\u636e\u5e93\u8fd8\u539f\uff0c\u518d\u53bb\u6784\u5efaAlwaysOn\u96c6\u7fa4\u3002<\/p>\n\n\n\n

\"\"
\u6570\u636e\u7c7b\u578b\u9009\u62e9\u67b6\u6784\u548c\u6570\u636e<\/figcaption><\/figure>\n\n\n\n
\"\"
\u670d\u52a1\u5668\u7248\u672c\u9009\u62e92016<\/figcaption><\/figure>\n\n\n\n
\"\"
sql\u6587\u4ef6\u5927\u5199\u53d6\u51b3\u4e8e\u4f60\u7684POC\u73af\u5883\u590d\u6742\u7a0b\u5ea6\uff0c\u9700\u8981\u8010\u5fc3\u52a0\u8f7d\u548c\u6267\u884c\uff0c\u6267\u884c\u540e\u7684\u62a5\u9519\u53ef\u5ffd\u7565\uff01<\/figcaption><\/figure>\n\n\n\n
\"\"
DB\u4e00\u4fa7\u5b8c\u5de5\u540e\uff0c\u5269\u4e0b\u5c31\u662f\u56de\u5230DDC\u4e0a\u501f\u52a9PowerShell\u5404\u79cd\u795e\u64cd\u4f5c\u4e86\uff01<\/figcaption><\/figure>\n\n\n\n

\u89e3\u9664\u73b0\u6709\u7684DB\u8fde\u63a5<\/p>Load the Citrix snap-ins
asnp Citrix.*
Disable configuration logging for the XD site:
Set-LogSite -State Disabled
Clear the current Delivery Controller database connections
Note: AdminDBConnection must be the last command
Set-ConfigDBConnection -DBConnection $null
Set-AcctDBConnection -DBConnection $null
Set-AnalyticsDBConnection -DBConnection $null # for 7.6 and newer
Set-AppLibDBConnection -DBConnection $null # for 7.8 and newer
Set-OrchDBConnection -DBConnection $null # for 7.11 and newer
Set-TrustDBConnection -DBConnection $null # for 7.11 and newer
Set-HypDBConnection -DBConnection $null
Set-ProvDBConnection -DBConnection $null
Set-BrokerDBConnection -DBConnection $null
Set-EnvTestDBConnection -DBConnection $null
Set-SfDBConnection -DBConnection $null
Set-MonitorDBConnection -DataStore Monitor -DBConnection $null
Set-MonitorDBConnection -DBConnection $null
Set-LogDBConnection -DataStore Logging -DBConnection $null
Set-LogDBConnection -DBConnection $null
Set-AdminDBConnection -DBConnection $null -force<\/cite><\/blockquote>\n\n\n\n

\"\"
\u5145\u5206\u53c2\u8003 https:\/\/docs.citrix.com\/en-us\/advanced-concepts\/implementation-guides\/database-connection-strings.html<\/a> <\/figcaption><\/figure>\n\n\n\n

\u5efa\u7acb\u65b0\u7684DB\u8fde\u63a5<\/p>$ServerName = “CVADlis”
$SiteDBName = “cvadPOC”
$LogDBName = “<\/em> cvadPOC<\/em> “
$MonitorDBName = “<\/em> cvadPOC<\/em> “
$csSite = “Server=$ServerName;Initial Catalog=$SiteDBName;Integrated Security=True”
$csLogging = “Server=$ServerName;Initial Catalog=$LogDBName;Integrated Security=True”
$csMonitoring = “Server=$ServerName;Initial Catalog=$MonitorDBName;Integrated Security=True”
Set-AdminDBConnection -DBConnection $csSite
Set-ConfigDBConnection -DBConnection $csSite
Set-AcctDBConnection -DBConnection $csSite
Set-AnalyticsDBConnection -DBConnection $csSite # for 7.6 and newer
Set-HypDBConnection -DBConnection $csSite
Set-ProvDBConnection -DBConnection $csSite
Set-AppLibDBConnection \u2013DBConnection $csSite # for 7.8 and newer
Set-OrchDBConnection \u2013DBConnection $csSite # for 7.11 and newer
Set-TrustDBConnection \u2013DBConnection $csSite # for 7.11 and newer
Set-BrokerDBConnection -DBConnection $csSite
Set-EnvTestDBConnection -DBConnection $csSite
Set-SfDBConnection -DBConnection $csSite
Set-LogDBConnection -DBConnection $csSite
Set-LogDBConnection -DataStore Logging -DBConnection $csLogging
Set-MonitorDBConnection -DBConnection $csSite
Set-MonitorDBConnection -DataStore Monitor -DBConnection $csMonitoring<\/em><\/cite><\/blockquote>\n\n\n\n

\"\"<\/figure>\n\n\n\n

<\/p>\n\n\n\n

\"\"
\u5207\u6362\u6570\u636e\u5e93\uff0c\u67e5\u770bARP\u8f93\u51fa\u7684MAC\u5730\u5740\u6765\u9a8c\u8bc1DDC\u5de5\u4f5c\u60c5\u51b5\uff01\u6b64\u5916\u8fd8\u53ef\u4ee5\u5728DDC\u4e0a\u6267\u884c\u7ad9\u70b9\u68c0\u6d4b\uff0c\u5982\u679c\u51fa\u73b0\u8b66\u544a\u4fe1\u606f\uff0c\u53ef\u4ee5\u653e\u5fc3\u5ffd\u7565\uff01<\/figcaption><\/figure>\n\n\n\n

\u7528PS\u6765\u68c0\u6d4bdb\u8fde\u63a5\u60c5\u51b5\uff1a<\/p>Load the Citrix snap-ins
asnp citrix.*
$ServerName = ” CVADlis<\/em> “
$SiteDBName = ” cvadPOC<\/em> “
$LogDBName = ” cvadPOC<\/em> “
$MonitorDBName = ” cvadPOC<\/em> “
$csSite = “Server=$ServerName;Initial Catalog=$SiteDBName;Integrated Security=True”
$csLogging = “Server=$ServerName;Initial Catalog=$LogDBName;Integrated Security=True”
$csMonitoring = “Server=$ServerName;Initial Catalog=$MonitorDBName;Integrated Security=True”
Test-AcctDBConnection -DBConnection $csSite
Test-AdminDBConnection -DBConnection $csSite
Test-AnalyticsDBConnection -DBConnection $csSite # for 7.6 and newer
Test-AppLibDBConnection -DBConnection $csSite # for 7.8 and newer
Test-BrokerDBConnection -DBConnection $csSite
Test-ConfigDBConnection -DBConnection $csSite
Test-EnvTestDBConnection -DBConnection $csSite
Test-HypDBConnection -DBConnection $csSite
Test-LogDBConnection -DBConnection $csSite
Test-LogDBConnection -DataStore Logging -DBConnection $csLogging
Test-MonitorDBConnection -DBConnection $csSite
Test-MonitorDBConnection -Datastore Monitor -DBConnection $csMonitoring
Test-OrchDBConnection -DBConnection $csSite # for 7.11 and newer
Test-ProvDBConnection -DBConnection $csSite
Test-SfDBConnection -DBConnection $csSite
Test-TrustDBConnection -DBConnection $csSite # for 7.11 and newer<\/cite><\/blockquote>\n\n\n\n