Skip to main content
NetApp Response to Russia-Ukraine Cyber Threat
In response to the recent rise in cyber threat due to the Russian-Ukraine crisis, NetApp is actively monitoring the global security intelligence and updating our cybersecurity measures. We follow U.S. Federal Government guidance and remain on high alert. Customers are encouraged to monitor the Cybersecurity and Infrastructure Security (CISA) website for new information as it develops and remain on high alert.
NetApp Knowledge Base

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

Views:
276
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. 

 

Scan to view the article on your device
CUSTOMER EXCLUSIVE CONTENT

Registered NetApp customers get unlimited access to our dynamic Knowledge Base.

New authoritative content is published and updated each day by our team of experts.

Current Customer or Partner?

Sign In for unlimited access

New to NetApp?

Learn more about our award-winning Support