NetWorker: Unable to backup SQL server 2022 with non-default TCP port
Résumé: When specifying a non-default TCP port in SQL 2022, the SQL backup job fails.
Cet article concerne
Cet article ne concerne pas
Cet article n’est associé à aucun produit spécifique.
Toutes les versions du produit ne sont pas identifiées dans cet article.
Symptômes
In SQL server configuration manager, -> SQL Server Network configuration -> Protocols for MSSQLSERVER -> TCP/IP
The customer modified TCP Dynamic ports to use 6201 instead of default port 1433. The SQL backup job fails with the following error messages.
The customer modified TCP Dynamic ports to use 6201 instead of default port 1433. The SQL backup job fails with the following error messages.
153887:nsrsqlsv: Microsoft SQL server documentation provides details about the following SQL Server Provider error: 67945 nsrsqlsv NSR critical Cannot login to SQL Server Default Instance. 38008:nsrsqlsv: Named Pipes Provider: Could not open a connection to SQL Server [2]. 153416:nsrsqlsv: (Error: 2)
Cause
In SQL previous versions, this issue can be fixed by modifying SQL native client configuration to specify the none default port as well. But since SQL 2022, SQL native client is no longer a part of SQL server installation, customer side refused to install this feature separately.
Résolution
If using a non-default TCP port, enable the "Named Pipes" protocol under SQL server network configuration.
Propriétés de l’article
Numéro d’article: 000226446
Type d’article: Solution
Dernière modification: 19 août 2024
Version: 2
Trouvez des réponses à vos questions auprès d’autres utilisateurs Dell
Services de support
Vérifiez si votre appareil est couvert par les services de support.