Skip to main content
NetApp Knowledge Base

SnapCenter SQL backup fails with error: Failed to connect to server ServerName. Login failed for user UserName

Views:
437
Visibility:
Public
Votes:
1
Category:
snapcenter
Specialty:
snapx
Last Updated:

Applies to

  • SnapCenter (SC) 4.1 and higher
  • SnapCenter Plug-In for SQL (SCSQL) 4.1 and higher

Issue

Backup failure in SCSQL

  • Failed to connect SQL server
  • Login failed
  • Error message in SMSQL log:
DEBUG SmSql_22499 PID=[51744] TID=[9] GetSqlAccess Enter
DEBUG SmSql_22499 PID=[51744] TID=[9] Connecting to SQL Server: <ServerName>
ERROR SmSql_22499 PID=[51744] TID=[9] ConnectionFailureException: Failed to connect to server <ServerName>. Login failed for user <UserName>
ERROR SmSql_22499 PID=[51744] TID=[9] ErrorCode (-1), ErrorMessage (The SQL instance <InstanceName> is either stopped or the user <UserName> does not have required permission. Error: Failed to connect to server <ServerName>)
DEBUG SmSql_22499 PID=[51744] TID=[9] Retrying Sql connection with user: <UserName>
DEBUG SmSql_22499 PID=[51744] TID=[9] Connecting to SQL Server: <ServerName>
ERROR SmSql_22499 PID=[51744] TID=[9] ConnectionFailureException: The user name or password is incorrect.
ERROR SmSql_22499 PID=[51744] TID=[9] ErrorCode (-1), ErrorMessage (The SQL instance <InstanceName> is either stopped or the user <UserName> does not have required permission. Error: The user name or password is incorrect.

Error message in SQL error log:
Logon       Error: 18456, Severity: 14, State: 11.
Logon       Login failed for user <UserName>. Reason: Token-based server access validation failed with an infrastructure error. 

 

Sign in to view the entire content of this KB article.

New to NetApp?

Learn more about our award-winning Support

NetApp provides no representations or warranties regarding the accuracy or reliability or serviceability of any information or recommendations provided in this publication or with respect to any results that may be obtained by the use of the information or observance of any recommendations provided herein. The information in this document is distributed AS IS and the use of this information or the implementation of any recommendations or techniques herein is a customer's responsibility and depends on the customer's ability to evaluate and integrate them into the customer's operational environment. This document and the information contained herein may be used solely in connection with the NetApp products discussed in this document.