Avamar : La restauration re-direct SQL se termine avec une erreur de connexion SMO

Summary: La restauration re-direct SQL se termine, mais ne parvient pas à se connecter à l’instance source.

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 est l’instance SQL source.
XYZ\SQL02 est l’instance SQL cible :
la tâche affiche « Failed to connect to server FBLDB65\I65 ». Lorsqu’une restauration re-direct est effectuée sur une instance SQL volumineuse. 
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

Il s'agit d'un problème connu.

Resolution

Contactez le support technique et consultez l’article de la base de connaissances 000217122.
La restauration sql re-direct est terminée, mais présente une erreur de connexion SMO
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.