SqlServer 2008-通过命令行启用网络命名管道 [英] SqlServer 2008 - Enable Net Named Pipes via command line

问题描述

作为集成构建的一部分，我们将sql server 2008安装在一台计算机上，然后在其上部署各种软件.一款软件需要启用网络命名管道"才能安装.

As part of our Integration build we are installing sql server 2008 on a machine then deploying various software on it. One piece of software requires that Net Named pipes is enabled for it to install.

由于服务器是在连续构建过程中自动构建的，因此我们必须能够通过非交互式命令行来做到这一点.

As the server is built automatically as part of our continuous build process, we have to be able to do this via a non-interactive command line.

有人知道没有gui的"Sql Server Network Configuration"部分中启用命名管道的方法吗? (即仅命令行)

推荐答案

结果表明，协议信息存储在注册表中:

Turns out that the protocol information is stored in the registry at :

HKLM\Software\Microsoft\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQLServer\SuperSocketNetLib

在Sql Server的Binn目录中，还有一个名为sqlps.exe的Sql Server Powershell.这样还可以通过编程方式访问配置.

There is also a powershell for Sql Server that is called sqlps.exe that is in the Binn directory of Sql server. That also offers programatic access to the configuration.

对于我来说，为网络命名管道导入以前导出的注册表项也可以，正如我想要的那样.

In my case, importing a previously exported registry key for the net named pipes works just as I want it too.

这篇关于SqlServer 2008-通过命令行启用网络命名管道的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！