Avamar: SQL re-direct restore completes with SMO connection error
Summary: SQL re-direct restore completes but fails to connect to the source instance.
This article applies to
This article does not apply to
This article is not tied to any specific product.
Not all product versions are identified in this article.
Symptoms
ABC123\I65 is the source SQL instance.
XYZ\SQL02 is the target SQL instance:
The job shows "Failed to connect to server FBLDB65\I65." when a re-direct restore is performed to large SQL instance.
XYZ\SQL02 is the target SQL instance:
The job shows "Failed to connect to server FBLDB65\I65." when a re-direct restore is performed to large SQL instance.
2023-05-03 18:24:49 avsql Info <15739>: Redirected restore target path is: 'XYZ\SQL02'
2023-05-03 18:24:49 avsql Error <40258>: sqlconnectimpl_smo::connect Microsoft.SqlServer.Management.Common.ConnectionFailureException: Failed to connect to server ABC123\I65. ---> System.Data.SqlClient.SqlException: 使用者 'TW\SPTWFAP00335$' 的登入失敗。
於 System.Data.SqlClient.SqlInternalConnectionTds..ctor(DbConnectionPoolIdentity identity, SqlConnectionString connectionOptions, SqlCredential credential, Object providerInfo, String newPassword, SecureString newSecurePassword, Boolean redirectedUserInstance, SqlConnectionString userConnectionOptions, SessionData reconnectSessionData, DbConnectionPool pool, String accessToken, Boolean applyTransientFaultHandling, SqlAuthenticationProviderManager sqlAuthProviderManager)
於 System.Data.SqlClient.SqlConnectionFactory.CreateConnection(DbConnectionOptions options, DbConnectionPoolKey poolKey, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningConnection, DbConnectionOptions userOptions)
於 System.Data.ProviderBase.DbConnectionFactory.CreateNonPooledConnection(DbConnection owningConnection, DbConnectionPoolGroup poolGroup, DbConnectionOptions userOptions)
於 System.Data.ProviderBase.DbConnectionFactory.TryGetConnection(DbConnection owningConnection, TaskCompletionSource`1 retry, DbConnectionOptions userOptions, DbConnectionInternal oldConnection, DbConnectionInternal& connection)
於 System.Data.ProviderBase.DbConnectionInternal.TryOpenConnectionInternal(DbConnection outerConnection, DbConnectionFactory connectionFactory, TaskCompletionSource`1 retry, DbConnectionOptions userOptions)
於 System.Data.SqlClient.SqlConnection.TryOpenInner(TaskCompletionSource`1 retry)
於 System.Data.SqlClient.SqlConnection.TryOpen(TaskCompletionSource`1 retry)
於 System.Data.SqlClient.SqlConnection.Open()
於 Microsoft.SqlServer.Management.Common.ConnectionManager.InternalConnect(WindowsIdentity impersonatedIdentity)
於 Microsoft.SqlServer.Management.Common.ConnectionManager.Connect()
— 內部例外狀況堆疊追蹤的結尾 —
於 Microsoft.SqlServer.Management.Common.ConnectionManager.Connect()
於 SMOWrap.SMO_Connect(SMOWrap* , Char* server, Char* login, Char* password, Int32 timeout, Char* file_description, Boolean applicationintentreadonly)
2023-05-03 18:24:49 avsql Warning <19462>: SMO connection failed.Cause
This is a known issue.
Resolution
Contact Support and reference knowledge article 000217122.
SQL re-direct restore completed but has SMO connection error
SQL re-direct restore completed but has SMO connection error
Article Properties
Article Number: 000217122
Article Type: Solution
Last Modified: 18 Dec 2023
Version: 2
Find answers to your questions from other Dell users
Support Services
Check if your device is covered by Support Services.