Il backup di NetWorker SQL ha esito negativo - Impossibile accedere all'istanza predefinita di SQL Server
Summary: Il backup di NetWorker SQL ha esito negativo: impossibile accedere all'istanza predefinita di SQL Server. Provider di memoria condivisa: Nessun processo si trova all'altra estremità del tubo. ...
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
Il backup SQL di NetWorker ha esito negativo con questo errore:
Cannot login to SQL Server Default Instance.
Esempi di errori in SQL Server sono:
nsrnmsqlra NSR critical Cannot login to SQL Server <SQLName> nsrnmsqlra NSR critical Microsoft SQL server documentation provides details about the following SQL Server Provider error: nsrnmsqlra NSR critical Shared Memory Provider: No process is on the other end of the pipe. nsrsqlsv NSR critical Cannot login to SQL Server Default Instance. nsrsqlsv: Shared Memory Provider: No process is on the other end of the pipe. nsrsqlsv: (Error: 233)
Cause
Vedere il seguente link Microsoft.
Connections to SQL Server from a client running on the same computer use the shared memory and named pipes protocols. Shared memory has no configurable properties. Shared memory is always tried first, and can't be moved from the top position of the Enabled Protocols list in the Client Protocols Properties list. The Shared Memory protocol can be disabled, which is useful when troubleshooting one of the other protocols.
Conclusioni
È necessario abilitare la memoria condivisa su SQL Server affinché NMM funzioni correttamente.
Resolution
Abilitare il protocollo di memoria condivisa di SQL Server utilizzando SQL Configuration Manager.
Article Properties
Article Number: 000228421
Article Type: Solution
Last Modified: 17 Sep 2024
Version: 1
Find answers to your questions from other Dell users
Support Services
Check if your device is covered by Support Services.