CODEWITHSUNDEEP
sql-server-2008command-linenamed-pipes
Ash
Ash

Reputation: 5087

SqlServer 2008 - Enable Net Named Pipes via command line

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.

Does anyone know of a way to enable the named pipes within the "Sql Server Network Configuration" section without a gui? (I.e. Command line only)

Upvotes: 1

Views: 4288

Answers (2)

Ash
Ash

Reputation: 5087

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

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

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.

Upvotes: 1

Mithrandir
Mithrandir

Reputation: 25387

I think the cli tool sac will do, what you need to do.

http://blogs.technet.com/b/matthewms/archive/2005/10/13/412453.aspx

See the -N option.

Upvotes: 1

Related Questions