SCSQL无法发现SQL实例

最后更新
另存为PDF

Views:

Visibility:: Public

Votes:: 0

Category:: snapcenter

Specialty:: snapx<a>2009年679160</a>

Last Updated:

适用场景

适用于SQL的SnapCenter 插件(SCSQL)

问题描述

SnapCenter资源窗格列出了一个带有红色挂锁的SQL实例。
选择实例将显示一条信息性消息The Microsoft SQL server or Windows credentials are necessary to unlock the selected instance. Click Refresh Resources to run a discovery with the associated Auth.""。
如果将SnapCenter配置为使用所需帐户并刷新实例的资源、则仍会显示相同的红色挂锁和信息性消息。

SQL实例credentials.png

用于SQL发现的SCSQL插件日志(SMSQL_xxx)显示以下错误：

2023-08-08T17:19:47.6446850+02:00 DEBUG SmSql_450726 PID=[3576] TID=[17] Connecting to SQL Server: [<SQL INSTANCE>]

2023-08-08T17:19:48.3634696+02:00 ERROR SmSql_450726 PID=[3576] TID=[10] ConnectionFailureException: Failed to connect to server <SQL INSTANCE>. Login failed for user '<USER ACCOUNT>'.

2023-08-08T17:19:48.3634696+02:00 ERROR SmSql_450726 PID=[3576] TID=[10] ErrorCode (10010), ErrorMessage (The user '<USER ACCOUNT>' does not have required permission to connect to the SQL instance '<SQL INSTANCE>'. Error: Login failed for user '<USER ACCOUNT>'.)

2023-08-08T17:19:48.3634696+02:00 ERROR SmSql_450726 PID=[3576] TID=[10] The user '<USER ACCOUNT>' does not have required permission to connect to the SQL instance '<SQL INSTANCE>'. Error: Login failed for user '<USER ACCOUNT>'.

2023-08-08T17:19:48.3634696+02:00 ERROR SmSql_450726 PID=[3576] TID=[10] Failed to enumerate SQL Server instance {<SQL INSTANCE>}