There are a large number of SQL Server Native Clients in the "System Management Events" of the SQL Server server 11.0 mistake，I originally thought it was a problem of SQL operation level, and I ignored it.，Then one day I checked online，Only to find that it is related to ESET。
SQL Server Native Client 11.0: Unable to load sqlnclir11.rll due to either missing file or version mismatch. The application cannot continue.
Recently, a large number of event records of remote desktop 4105 Warning message，Follows：
The remote desktop authorization server cannot be an Active Directory domain “xxx.com.tw” Of users “bill” Update authorization attributes。Please make sure the computer account of the authorization server is an Active Directory domain “xxx.com.tw” Member of the Terminal Server License Servers group。
Recently, the company's computers and servers have been unable to log in，The message only tells that the password is wrong，Most computers can log in after rebooting，One of the servers is to log in to the local account，Re-add domain to login。
When checking system records today，See MariaDB has a lot of error messages，Follows：
InnoDB: Table mysql/innodb_index_stats has length mismatch in the column name table_name. Please run mysql_upgrade
Unifi Network Controller is written in JAVA，So before it was installed in Window 7，But it often happens that the program fails，Later, it will restart almost every day，So I was thinking about whether I could make it a service，And the official does provide practice，But when doing，Pay attention to some places。
Edge 79 Start of edition，The core is changed to Chromium，So the browsing experience has improved a lot，But my colleagues reacted，When opening a PDF document online，Part of the content will be blank，I'm not sure this PDF was developed by Edge itself，Still use Chromium，Finally, try two methods to let User choose。
Our remote connection server (Windows Server 2012 R2) As long as there is a user connected，A record appears in the event record 20499 A warning：
"Remote Desktop Services" took too long to load the user settings of user bbb from server aaa
Before installing Windows Server 2019 Time，Have noticed that the Server Core environment is selected by default，I feel that Microsoft wants to push the operating environment of this instruction mode。And after completing the Windows Server installation，When opening the Server Manager，Then it will suggest that we try to use “Windows Admin Center” IT，So if you want to say it, then try Windows Server 2019 Server Core install Windows Admin Center。
Wrote an article last week "Application specific permission settings cannot include CLSID – SQL」，At that time, I saw it in the system event record on SQL Server，The permissions in question are in the role of SQLSERVERAGENT，There is no problem with the permissions of the server itself (SYSTEM 及 Administrator)。I saw the same message on the AD server today，This time, the server itself has insufficient permissions，Therefore, multiple steps are required to retrieve the permissions from regedit。
Recently check the "event log" of each server，Want to reduce invalid information，And handling error information。This time on SQL Server，There will always be an error message like this：
應用程式特定 權限設定無法將含有 CLSID {806835AE-FD04-4870-A1E8-D65535358293} 與 APPID {EE4171E6-C37E-4D04-AF4C-8617BC7D4914} 之 COM 伺服器應用程式的 本機 啟用 權限授與來自位址 LocalHost (使用 LRPC) (在應用程式容器 無法使用 SID (無法使用) 中執行) 的使用者 NT SERVICE\SQLSERVERAGENT SID (S-1-5-80-344959196-2060754871-2302487193-2804545603-1466107430)。您可以使用元件服務系統管理工具修改此安全性權限。
Anson | 
05 28th, 2020| 