Avamar: Il restore sql re-direct viene completato con un errore di connessione SMO

Summary: Il restore di SQL re-direct viene completato ma non riesce a connettersi all'istanza di origine.

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.
Check out other resources

Symptoms

ABC123\I65 è l'istanza SQL di origine.
XYZ\SQL02 è l'istanza SQL di destinazione:
Il processo mostra "Failed to connect to server FBLDB65\I65." quando viene eseguito un restore re-direct in un'istanza SQL di grandi dimensioni.  
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

Questo è un problema noto.

Resolution

Contattare il supporto e consultare l'articolo della Knowledge Base 000217122.
Restore di SQL re-direct completato ma con errore di connessione 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.