NetWorker SQL 备份失败 — 无法登录 SQL Server 默认实例

Summary: NetWorker SQL 备份失败 - 无法登录到 SQL Server 默认实例。 共享内存提供程序:管道的另一端没有进程。

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

NetWorker SQL 备份失败,并显示以下错误:
 

Cannot login to SQL Server Default Instance.
 

SQL Server 上的示例错误包括:
 

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

请参阅以下 Microsoft 链接。


https://learn.microsoft.com/en-us/sql/tools/configuration-manager/creating-a-valid-connection-string-using-shared-memory-protocol?view=sql-server-ver16此超链接会将您带往 Dell Technologies 之外的网站。
 

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.
 

结论

必须在 SQL Server 上启用共享内存,才能使 NMM 正常工作。
 

Resolution


使用 SQL 配置管理器启用 SQL Server 共享内存协议。
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.