Sql-Server

SQL Server 代理無法建立連接

  • October 9, 2019

我最近在 windows 2016 伺服器上安裝了 sql server 2014 企業版。由於某種原因,sql server 代理未啟動,但 sql server 服務已啟動並正在執行。我不確定發生了什麼。從 sql server 代理日誌文件中,我可以看到以下資訊。你認為我應該修復 sql server 嗎?我讀過其他可能是由於 sql server 本機客戶端安裝問題?此外,在事件日誌中,我注意到與權限相關的問題。我做了一些研究,並嘗試為該 APPID 和 CLSID 提供適當的權限,但我仍然無法啟動該 sql 代理。謝謝

========================================================

            2019-10-09 00:54:15 - ? [100] Microsoft SQLServerAgent 
          version 
          12.0.6024.0 (X64 unicode retail build) : Process ID 55496
          2019-10-09 00:54:15 - ? [495] The SQL Server Agent startup 
          service account is WORKGROUP\D03XXX
          2019-10-09 00:54:15 - ! [150] SQL Server does not accept the 
          connection 
         (error: 0). Waiting for Sql Server to allow connections. 
         Operation attempted was: Verify Connection On Start.
          2019-10-09 00:54:15 - ! [000] Unable to connect to server.    
           '(local)';     SQLServerAgent cannot start
         2019-10-09 00:54:15 - ! [298] SQLServer Error: 27, Registry 
          information is corrupt or missing. Make sure the provider is 
          installed and  registered correctly. [SQLSTATE 08001] 
          2019-10-09 00:54:15 - ! [298] SQLServer Error: 27, Client
          unable  to establish connection [SQLSTATE 08001] 
          2019-10-09 00:54:15 - ! [165] ODBC Error: 0, A network- 
           related or instance-specific error has occurred while.    
           establishing a connection to SQL Server. Server is not found 
            or not accessible.           
            Check if instance name is correct and if SQL Server is.   
           configured to allow remote connections. 

          For more information see SQL Server Books Online. 
          [SQLSTATE. 08001] 
          2019-10-09 00:54:15 - ! [382] Logon to server '(local)' failed 
          (DisableAgentXPs)
         2019-10-09 00:54:15 - ? [098] SQLServerAgent terminated
          (normally)

========================================================

     EVENT LOG snippet 

   The application-specific permission settings do not grant Local. 
    Activation permission for the COM Server application with CLSID 
    {D63B10C5-BB46-4990-A94F-E40B9D520160}
     and APPID {9CA88EE3-ACB7-47C8-AFC4-AB702511C276}
    to the user NT SERVICE\SQLSERVERAGENT SID (S-1-5-80- 
     344959196-2060754871- 
      2302487193-2804545603-1466107430) from address.     
     LocalHost (Using LRPC) 
     running in the application container Unavailable SID 
      (Unavailable). This security permission can be modified using 
     the Component Services administrative tool.

我已經重新安裝了 sql server 2014 並解決了這個問題。我已經意識到 sql server 本地客戶端沒有正確安裝。謝謝你的時間

引用自:https://dba.stackexchange.com/questions/250620