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:
346
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

Scan to view the article on your device