적용 대상:
2013 2016 2019 Subscription Edition 
SharePoint in Microsoft 365
증상:
2018년 9월 .NET 4.6 이상 업데이트를 적용하면 크롤링이 실패하고 다음과 유사한 항목이 표시됩니다.
<date> <time> mssdmn.exe (0x2730) 0x00D8 SharePoint Foundation Database fa45 High System.TypeInitializationException: The type initializer for 'System.Data.SqlClient.SqlConnection' threw an exception. ---> System.IO.FileNotFoundException: C:\Program Files\Microsoft Office Servers\16.0\bin\mssdmn.exe at System.Diagnostics.FileVersionInfo.GetVersionInfo(String fileName) at System.Configuration.ClientConfigPaths.SetNamesAndVersion(String applicationFilename, Assembly exeAssembly, Boolean isHttp) at
System.Configuration.ClientConfigPaths..ctor(String exePath, Boolean includeUserConfig) at System.Configuration.ClientConfigPaths.GetPaths(String exePath, Boolean includeUserConfig) at System.Configuration.ClientConfigurationHost.RequireCompleteInit(IInternalConfigRecord
record) at System.Configuration.BaseConfigurationRecord.GetSectionRecursive(String configKey, Boolean getLkg, Boolean checkPermission, Boolean getRuntimeObject, Boolean requestIsHere, Object& result, Object& resultRuntimeObject) at
System.Configuration.BaseConfigurationRecord.GetSection(String configKey) at System.Configuration.ConfigurationManager.GetSection(String sectionName) at System.Data.SqlClient.SqlConnection..cctor() --- End of inner exception stack trace --- at
System.Data.SqlClient.SqlConnection..ctor(String connectionString) at Microsoft.SharePoint.Utilities.SqlSession.OpenConnection() at Microsoft.SharePoint.Administration.SPConfigurationDatabase.get_Local() at Microsoft.SharePoint.Administration.SPFarm.FindLocal(SPFarm& farm,
Boolean& isJoined)
<date> <time> mssdmn.exe (0x2730) 0x12E0 SharePoint Foundation Topology 88bl Monitorable An exception occurred while trying to acquire the local farm: System.TypeInitializationException: The type initializer for 'System.Data.SqlClient.SqlConnection' threw an exception. ---> System.IO.FileNotFoundException: C:\Program Files\Microsoft Office Servers\16.0\bin\mssdmn.exe at System.Diagnostics.FileVersionInfo.GetVersionInfo(String fileName) at System.Configuration.ClientConfigPaths.SetNamesAndVersion(String applicationFilename, Assembly exeAssembly,
Boolean isHttp) at System.Configuration.ClientConfigPaths..ctor(String exePath, Boolean includeUserConfig) at System.Configuration.ClientConfigPaths.GetPaths(String exePath, Boolean includeUserConfig) at
System.Configuration.ClientConfigurationHost.RequireCompleteInit(IInternalConfigRecord record) at System.Configuration.BaseConfigurationRecord.GetSectionRecursive(String configKey, Boolean getLkg, Boolean checkPermission, Boolean getRuntimeObject, Boolean requestIsHere, Object& result,
Object& resultRuntimeObject) at System.Configuration.BaseConfigurationRecord.GetSection(String configKey) at System.Configuration.ConfigurationManager.GetSection(String sectionName) at System.Data.SqlClient.SqlConnection..cctor() --- End of inner exception stack trace ---
at System.Data.SqlClient.SqlConnection..ctor(String connectionString) at Microsoft.SharePoint.Utilities.SqlSession.OpenConnection() at Microsoft.SharePoint.Administration.SPConfigurationDatabase.get_Local() at
Microsoft.SharePoint.Utilities.SqlSession.ExecuteReader(SqlCommand command, CommandBehavior behavior, SqlQueryData monitoringData, Boolean retryForDeadLock) at Microsoft.SharePoint.Utilities.SqlSession.ExecuteReader(SqlCommand command, Boolean retryForDeadLock) at Microsoft.SharePoint.Utilities.SqlSession.ExecuteReader(SqlCommand command) at Microsoft.SharePoint.Upgrade.SPDatabaseSequence.GetVersion(SPDatabase database, Guid id, Version defaultVersion, SqlSession session, SPDatabaseSequence sequence) at Microsoft.SharePoint.Upgrade.SPDatabaseSequence.get_SchemaVersion() at Microsoft.SharePoint.Upgrade.SPSequence.get_IsBackwardsCompatible() at Microsoft.SharePoint.Upgrade.SPUpgradeSession.IsBackwardsCompatible(Object o, Boolean bRecurse)
원인:
에 대한 SqlColumnEncryptionEnclaveProviders 구성 섹션은 정의되지 않았지만 .NET Sql Client에서 필요합니다.
해결 방법 1:
아직 존재하지 않는 경우 mssdmn.exe 대한 구성 파일을 만듭니다(기본적으로 존재하지 않음). 구성 파일에 다음 콘텐츠가 있는지 확인합니다.
mssdmn.exe.config 콘텐츠:
<?xml version="1.0" encoding="UTF-8"?>
<configuration>
<configSections>
<section name="SqlColumnEncryptionEnclaveProviders"
type="System.Data.SqlClient.SqlColumnEncryptionEnclaveProviderConfigurationSection, System.Data, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" />
</configSections>
</configuration>
일반적으로 파일은 다음 위치에 있어야 합니다.
SharePoint 2013: C:\Program Files\Microsoft Office Servers\15.0\bin\mssdmn.exe.config
SP 2016 및 SP 2019: C:\Program Files\Microsoft Office Servers\16.0\bin\mssdmn.exe.config
해결 방법 2:
해결 방법 1은 검색 문제를 해결할 수 있지만 다른 구성 요소에 문제가 있을 수 있습니다. 다른 구성 요소에 문제가 계속 표시되는 경우 변경 내용을 포함하도록 machine.config 수정할 수 있습니다.
다음 스크립트는 자동으로 변경합니다. 문제가 있는 모든 서버에서 이 작업을 실행해야 합니다.
<#
Copyright (c) Microsoft Corporation. All rights reserved.
MIT License
Permission is hereby granted, free of charge, to any person obtaining a copy
of this software and associated documentation files (the ""Software""), to deal
in the Software without restriction, including without limitation the rights
to use, copy, modify, merge, publish, distribute, sublicense, and/or sell
copies of the Software, and to permit persons to whom the Software is
furnished to do so, subject to the following conditions:
The above copyright notice and this permission notice shall be included in all
copies or substantial portions of the Software.
THE SOFTWARE IS PROVIDED *AS IS*, WITHOUT WARRANTY OF ANY KIND, EXPRESS OR
IMPLIED, INCLUDING BUT NOT LIMITED TO THE WARRANTIES OF MERCHANTABILITY,
FITNESS FOR A PARTICULAR PURPOSE AND NONINFRINGEMENT. IN NO EVENT SHALL THE
AUTHORS OR COPYRIGHT HOLDERS BE LIABLE FOR ANY CLAIM, DAMAGES OR OTHER
LIABILITY, WHETHER IN AN ACTION OF CONTRACT, TORT OR OTHERWISE, ARISING FROM,
OUT OF OR IN CONNECTION WITH THE SOFTWARE OR THE USE OR OTHER DEALINGS IN THE
SOFTWARE.
#>
function Add-SQLEntry([string]$path)
{
# Load machine.config file
Write-Host "*** Config file: $path ***"
$config = [xml](Get-Content $path -ErrorAction Stop)
# Confirm whether the entry is already there
$node = (Select-Xml -xml $config -xpath '//configuration/configSections/section[@name="SqlColumnEncryptionEnclaveProviders"]');
if($node -ne $null)
{
Write-Host "1. Entry was already present";
Write-Host "2. No change necessary"
return $false
}
Write-Host "1. Entry for SqlColumnEncryptionEnclaveProviders is missing";
$newNode = $config.CreateElement('section');
$newNode.SetAttribute('name','SqlColumnEncryptionEnclaveProviders');
$newNode.SetAttribute('type','System.Data.SqlClient.SqlColumnEncryptionEnclaveProviderConfigurationSection, System.Data, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089');
$node = $config.SelectSingleNode('//configuration/configSections');
$node.AppendChild($newNode);
Write-Host "2. Adding entry"
Write-Host "3. Backing up machine.config"
# Make a backup of machine.config
$addDate = (Get-Date).ToString('yyyyMMddHHmmssfff')
Rename-Item -Path $path -NewName "$path.$addDate" -ErrorAction Stop
Write-Host "4. Saving changes";
$config.Save($path);
Write-Host "5. Changes saved successfully"
Write-Host ""
& notepad $path
return $true
}
$confPath32 = "$($env:windir)\Microsoft.NET\Framework\v4.0.30319\config\machine.config";
$confPath64 = "$($env:windir)\Microsoft.NET\Framework64\v4.0.30319\config\machine.config";
$addDate = (Get-Date).ToString('yyyyMMddHHmmssfff')
$success = Add-SQLEntry $confPath64
$success = Add-SQLEntry $confPath32
추가 정보:
August-September 2018 .NET Framework 업데이트 후 .NET 4.6 이상에서 SqlConnection 인스턴스화 예외