主页 / dba / 问题 / 140493
Accepted
Craig Efrein
Asked: 2016-06-07 01:59:22 +0800 CST

升级到 2016 后，SQL Server 代理无法连接到实例

  • 772

在带有 SQL Server 2014 Enterprise 的群集 Windows 2012 R2 服务器上。

刚刚将实例从 2014 SP1 CU4 升级到 2016 RTM，现在尝试启动 SQL Server 代理时出现此错误。

SQL 服务器代理日志

2016-06-06 11:53:58 - ? [100] Microsoft SQLServerAgent version 13.0.1601.5 (X64 unicode retail build) : Process ID 10884
2016-06-06 11:53:58 - ? [495] The SQL Server Agent startup service account is DOMAIN\USERNAME.
2016-06-06 11:54:28 - ! [150] SQL Server does not accept the connection (error: 65535). Waiting for Sql Server to allow connections. Operation attempted was: Verify Connection On Start.
2016-06-06 11:54:28 - ! [000] Unable to connect to server 'SERVERNAME\INSTANCENAME'; SQLServerAgent cannot start
2016-06-06 11:54:33 - ! [298] SQLServer Error: 65535, SQL Server Network Interfaces: Error Locating Server/Instance Specified [xFFFFFFFF]. [SQLSTATE 08001] 
2016-06-06 11:54:33 - ! [165] ODBC Error: 0, Login timeout expired [SQLSTATE HYT00] 
2016-06-06 11:54:33 - ! [298] SQLServer Error: 65535, 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] 
2016-06-06 11:54:33 - ! [382] Logon to server 'SERVERNAME\INSTANCENAME' failed (DisableAgentXPs)
2016-06-06 11:54:33 - ? [098] SQLServerAgent terminated (normally)

Windows 应用程序日志

SQLServerAgent could not be started (reason: Unable to connect to server 'A08SQL-EDI\EDI'; SQLServerAgent cannot start).

代理启动并运行大约 30 秒，然后因上述错误而死。有人遇到这个问题吗？你知道如何解决它吗？

sql-server upgrade

2 个回答

  1. 通过向 SQL Server 代理配置中的实例添加别名解决了问题。

    别名是使用服务器的完全限定域名定义的。示例：servername.domain.biz\instance_name否则代理仍会出错并关闭。

    在此处输入图像描述

    此外，代理在 sp_configure 中被禁用

    sp_configure 'Agent XPs', 1
go

reconfigure with override
go

    所以重新启用它。

    • 12
  2. Best Answer

    https://support.microsoft.com/en-nz/kb/3185365

    13 版本的 ODBC 问题。请申请 13.1

    • 4

相关问题