NetWorker SQL 백업 실패 - SQL Server 기본 인스턴스에 로그인할 수 없음

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)

다음 Microsoft 링크를 참조하십시오.

https://learn.microsoft.com/en-us/sql/tools/configuration-manager/creating-a-valid-connection-string-using-shared-memory-protocol?view=sql-server-ver16
 

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.

결론

NMM이 제대로 작동하려면 SQL Server에서 공유 메모리를 활성화해야 합니다.