Skip to main content
NetApp Knowledge Base

SnapCenter SQL backups are failing with "Error:The referenced account is currently locked out and may not be logged on to"

Views:
281
Visibility:
Public
Votes:
0
Category:
snapcenter
Specialty:
snapx
Last Updated:

Applies to

  • SnapCenter Server 4.x
  • SnapCenter Plug-in for SQL 4.x

Issue

SnapCenter SQL backups are failing with "Error:The referenced account is currently locked out and may not be logged on to".

SnapCenter SMSQL Log:

ERROR SmSql_306130 PID=[9132] TID=[42] ConnectionFailureException: The referenced account is currently locked out and may not be logged on to.

ERROR SmSql_306130 PID=[9132] TID=[42] ErrorCode (-1), ErrorMessage (The SQL instance 'Database Instance name' is either stopped or the user 'User name' does not have required permission. Error: The referenced account is currently locked out and may not be logged on to.)

ERROR SmSql_306130 PID=[9132] TID=[42] The SQL instance 'Database Instance name' is either stopped or the user 'user name' does not have required permission. Error: The referenced account is currently locked out and may not be logged on to.

ERROR SmSql_306130 PID=[9132] TID=[42] Failed to enumerate SQL Server instance {Database Instance name}

ERROR SmSql_306130 PID=[9132] TID=[310] ErrorCode (0), ErrorMessage (Discovery of SQL Instances 'Database Instance name' failed. Ensure the SQL server(s) are in running state with sysadmin privileges.)

 

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.