AppSync：SQL 服务计划在应用程序发现阶段失败，并显示以下错误：Unable to connect to database（无法连接到数据库）。

摘要: SQL 服务计划在应用程序发现阶段失败，并显示以下错误： Unable to connect to database Unable to connect to database. This can happen if either SQL database is not in online state or ODBC driver is not properly installed. Check the AppSync host plug-in log for more details. ...

本文适用于 本文不适用于 本文并非针对某种特定的产品。 本文并非包含所有产品版本。
查看其他资源

症状

服务计划在应用程序发现阶段失败，并显示以下错误： Unable to connect to database Unable to connect to database <Db name>. This can happen if either SQL database is not in online state or ODBC driver is not properly installed.
Check the AppSync host plug-in log for more details.

AppSync 事件日志：
 
Application discovery,7d2c438e-6ea7-4bb9-b515-0ce2594f9315,SQL_000141,<AppSync Server>,Unable to connect to database <Db name>. This can happen if either SQL database is not in online state or ODBC driver is not properly installed.Check the AppSync host plug-in log for more details.
 
AppSync 服务器日志：
 
07-02-2021 06:00:05.840 INFO [Thread-28455 (HornetQ-client-global-threads-320952484)] [com.emc.archway.service.eventservice.EventServiceBean] [ASServer] [] d96dbf19-8962-4ef4-9e53-9d22e4af3e33->>> EVENT [SQL_000141]: Unable to connect to database hostname.master. This can happen if either SQL database is not in online state or ODBC driver is not properly installed. Check the AppSync host plug-in log for more details.(METADATA: TYPE-ERROR, TIME-2021-07-02 06:00:05.840-0600NATIVETIME-2021-07-02 06:00:05.643-0600, HOST-hostname.a.b.corporate. com, PHASE-Application discovery, THREAD=17152, USER-null, CATEGORY-GENERIC, SESSIONID-null)
07-02-2021 06:00:05.841 ERROR [Thread-28455 (HornetQ-client-global-threads-320952484)] [org.jboss.as.ejb3.invocation] [ASServer] [] WFLYEJB0034: EJB Invocation failed on component SqlServiceBean for method public com.emc.archway.objectmodel.host.sql.SqlServerInstances com.emc.archway.service.sqlservice.SqlServiceBean.discoverDatabases(com.emc.archway.context.ExecutionContext,com.emc.archway.objectmodel.host.AgentHost,com.emc.archway.objectmodel.host.sql.SqlServerInstances) throws java.net.UnknownHostException,com.emc.archway.service.eventservice.exceptions.HostPluginDownException: javax.ejb.EJBException: java.lang.RuntimeException
07-02-2021 06:00:06.032 ERROR [Thread-28455 (HornetQ-client-global-threads-320952484)] [com.emc.archway.application.sqlserver.SqlServerCommandListenerBean] [ASServer] [] d96dbf19-8962-4ef4-9e53-9d22e4af3e33->>> Exception Occurred: RuntimeException
07-02-2021 06:00:06.035 ERROR [Thread-28455 (HornetQ-client-global-threads-320952484)] [com.emc.archway.application.sqlserver.SqlServerCommandListenerBean] [ASServer] [] d96dbf19-8962-4ef4-9e53-9d22e4af3e33->>> Exception Occurred: EJBException, Message: java.lang.RuntimeException
07-02-2021 06:00:07.272 INFO [Thread-28456 (HornetQ-client-global-threads-320952484)] [com.emc.archway.service.eventservice.EventServiceBean] [ASServer] [] d96dbf19-8962-4ef4-9e53-9d22e4af3e33->>> EVENT [MILE_000005]: Application discovery phase for hostname:Utility completed with errors(METADATA: TYPE-ERROR, TIME-2021-07-02 06:00:07.272-0600NATIVETIME-2021-07-02 06:00:07.272-0600, HOST-ASServer, PHASE-Application discovery, THREAD=Thread-28456 (HornetQ-client-global-threads-320952484), USER-null, CATEGORY-MILESTONE, SESSIONID-null)

原因

SQL 数据库的保护失败，因为提供给 AppSync for SQL 的用户没有所需的权限。
 


解决方案


将数据库的 Windows 验证重置为正确的用户将可解决该问题。

重置验证的步骤：
 
1.在 AppSync 控制台上，选择“Copy Management”。
2.从“Copies”下拉列表中，选择“Copies”。
3.从“Select Application”下拉列表中，选择“Microsoft SQL Server”，以显示实例页面。
4.选择某个数据库，然后单击“CONNECTION SETTINGS”。
此时将会出现“SQL Server Connection settings”对话框。
5.在“Authentication”字段中，根据站点要求选择以下其中一项：
● Windows Authentication
● SQL Server Authentication
6.为以下字段指定值：
● Username
● Password
7.单击“OK”

受影响的产品

AppSync

产品

Data Protection, Data Backup & Protection Software
文章属性
文章编号: 000189823
文章类型: Solution
上次修改时间: 22 10月 2024
版本:  6
从其他戴尔用户那里查找问题的答案
支持服务
检查您的设备是否在支持服务涵盖的范围内。